Three minute video illustrates how Database Performance Analyzer for SAP ASE finds and resolves SAP ASE performance problems in just four clicks.
SAP ASE Performance Problems Resolved:
Database Performance Analyzer for SAP ASE is the one ASE database performance monitoring, analysis and tuning solution designed specifically to prevent and solve the toughest performance problems. Database Performance Analyzer for SAP ASE goes where conventional SAP ASE health monitors can’t, and covers SAP ASE along with Oracle®, DB2® and SQL Server® from one system. It’s the one tool that all DBAs, Developers and DBA Managers can use, collaborating to save DBA and Developer time and measurably improve SAP ASE application performance.
TOP 5 Reasons to use Database Performance Analyzer for SAP ASE
Identify performance issues that impact application response time the most
Response Time Analysis helps you make changes that end-users will notice when their apps run faster.
Database Performance Analyzer applies Response Time analysis to measure the time for query response, rather than focusing on conventional server health metrics. Database Performance Analyzer measures time associated with each tiny operation—or wait type—and uses it to expose delays in end-user service. This is the most important indicator, since it shows applications waiting to respond.
Database Performance Analyzer doesn’t stop there. It gathers real time session data, server resource levels, and query information on database performance. It also analyzes historical trends of response time over multiple dimensions —such as wait type, program, and execution plan. Then Database Performance Analyzer correlates the data to lead the DBA through the most important problems and solutions. Database Performance Analyzer also helps you maximize performance in the Cloud. Further, it provides a clear correlation between database response time to the applications and server resource provisioning, allowing you to right size your AWS®, Azure™, and vCloud®.
Cloud companies face a critical decision when it comes to maximizing application performance while scaling rapidly.
See how to prepare for when your company goes supernova .
Learn More about Application Performance »
Get unparalleled visibility to performance on the Amazon® Cloud. Database Performance Analyzer’s Multi-Dimensional Performance Analysis identifies historical performance trends and gives you actionable advice on the inner workings of database instances deployed on an Amazon AWS RDS and EC2® virtual machine.
Eliminate finger-pointing across the IT team
SolarWinds SAP ASE performance monitoring software builds collaboration among DBAs, Developers, and Q/A & Server Administrators.
Database Performance Analyzer allows the entire team—DBAs, developers, QA engineers, and architects—to collaborate on the performance of applications, enabling better service and faster time to market.
In turn, freeing them from dependence on DBAs for production data. QA engineers can locate performance issues before deployment and easily communicate these issues to the development team. DBAs are then able to collaborate with the extended IT organization while maintaining 100% control over production servers and monitoring load.
Learn More about SAP ASE Monitoring »
Database Performance Analyzer supports ALL database deployment options
Instead of being forced to use different monitoring tools for On-Premise and in the Cloud/Virtualized, get DPA. It’s the only tool that provides full coverage of all three deployment options offering consistent monitoring, minimized costs, and a thorough management of performance complexity.
Improve Performance Without Additional Server Resources
Investing in hardware to resolve application performance problems is a big gamble unless you are certain the performance bottleneck is, in fact, caused by server resources. DPA helps pinpoint the root cause of problems and allows you to validate your hardware purchases.
Database Performance Analyzer for SQL Server repository can be either
- SQL Server 2008, 2012, 2014
- Oracle 10g, 11g, 12c (Single tenant )
Supported monitored databases in 9.1 include:
- SQL Server 2008, 2012, 2014
- Oracle 10g, 11g, 12c (Single tenant)
- SAP ASE 15.0.x, 15.5, 15.7, 16
- DB2 LUW 9.x, 10.1, 10.5
Windows, Linux or UNIX
2GB per monitored instance
- “Express” editions of either SQL Server or Oracle can be used for DPA’s repository database, but please note that these free editions do have restrictions that can limit analysis performance and historical repository size for larger deployments.
- To ensure consistent 24/7 monitoring, Database Performance Analyzer should not be installed on a laptop or any other computer that gets powered down frequently.
- Database Performance Analyzer for SAP ASE needs to be installed on a server that does not contain monitored instances in order to ensure negligible load on the monitored Instances.
NOTE: The minimum server requirements listed assume default configuration. The number of monitored instances, transactional load on the monitored instances, and number of active client sessions can increase the resource requirements of the server that Database Performance Analyzer is installed on.
Must Have features of SolarWinds SAP ASE Performance Monitoring Software
SQL Query Tuning
Often, database performance issues result from poorly written queries, bad design, or index strategies. Unlike hardware upgrades, query tuning can offer immediate and powerful results. However, effective tuning requires not only knowing the top SQL statements, but also the top wait types, SQL plans, the effect of missing indexes, blocked queries, and resource contention. Database Performance Analyzer isolates the root cause and provides the much needed tuning advice. Therefore, Database Performance Analyzer is a must for effective SAP ASE Performance Tuning.
Isolate Root Causes by Performing Multi-Dimensional Analysis
Get to the root cause of database performance issues without getting lost in statistics.
Most database tools present a maze of screens and stats, but no answers. Database Performance Analyzer for SAP ASE clearly identifies the exact root cause of DB2 application performance issues. It gives you the ability to analyze and optimize application performance based on Queries, Sessions, Servers and Storage systems, etc. Using bar charts even a manager can understand, with alarms that lead directly to the detailed data, Database Performance Analyzer for DB2 gets to the problem and shows objective evidence fast, so there is no finger pointing about who is responsible.
Database Performance Analyzer for DB2 is the only performance solution that shows three key components of the problem: the query affected, the DB2 Wait Type, and the response time impact of each bottleneck. Finding the exact cause of the problem, from initial alarm to detailed analysis in only four clicks makes Database Performance Analyzer for DB2 the fastest way to improve DB2 performance.
Learn More about Resolving SAP ASE Performance Issues »
SAP ASE on VMware®
Get comprehensive visibility to both the physical and virtual resources impacting SAP ASE performance.
The VM Option, a chargeable feature of Database Performance Analyzer for SAP ASE, provides DBAs with visibility into how virtual machine and host performance impacts database performance. There are performance issues that can occur when SAP ASE runs on VMware. The dynamic nature of the virtual infrastructure can quickly impact the SQL Server. For example, resource contention can occur when additional VMs are placed on the same host where the SAP ASE VM is located or the SAP ASE server’s performance could be impacted if that VM is moved to another physical host with limited resources.
The problem many DBAs face is that they’re not responsible for the virtual infrastructure, and this responsibility is often siloed to the virtual admin. In addition, the virtual infrastructure has no visibility to the applications or databases that run on the VMs which makes it very difficult to map database and virtual machine performance.
The VM Option for Database Performance Analyzer for SAP ASE solves this problem by providing a contextual view of virtual machine and host performance with SAP ASE database performance.
No Agents and No Load
Database Performance Analyzer for SAP ASE is unique with no installed agent and less than 1% load on monitored server.
Database Performance Analyzer for SAP ASE monitors databases without installing any software on the production systems. Database Performance Analyzer for SAP ASE is built on a three tier architecture, with software installed only in the middle tier. DBAs, developers and managers access the solution from their browser. Database Performance Analyzer for SAP ASE is installed on any Windows®, UNIX® or Linux® server. The repository database is configured in an Oracle or SQL Server instance, often a test or development system. Database Performance Analyzer for SAP ASE’s agentless probes reach across the network to the monitored databases – SAP ASE as well as other vendors - and pull performance statistics back to the repository for analysis and reporting.
Learn More about Agentless SAP ASE Performance Monitoring »
Database Performance and Server Health in a single pane of glass
From a single pane of glass, you can identify the database issues and easily collaborate with system, application, network and database professionals to resolve those.
See database performance data from the perspective of poorly performing applications
DPA 9.2 allows integration with SAM. Customers can now get database information in context to nodes and applications
Q: How is Database Performance Analyzer for SAP ASE licensed?
A: Database Performance Analyzer for SAP ASE is licensed based on the number of instances on the SAP ASE server to be monitored. An unlimited number of instances can be monitored, and used by an unlimited number of DBAs, Developers and Managers to view performance of any SAP ASE instance on the licensed server. DPA’S pricing model makes adding additional monitored instances more affordable and less confusing than the core-based licensing for Oracle®, DB2®, and SAP ASE® products.
Q: On what server is Database Performance Analyzer for SAP ASE installed?
A: Database Performance Analyzer for SAP ASE is installed on any Windows, Linux or UNIX server. No software is installed on the SAP ASE server to be monitored.
Q: Are there agents or other Database Performance Analyzer for SAP ASE software installed on the SAP ASE Server to be monitored?
A: No, Database Performance Analyzer for SAP ASE is agentless, and places less than 1% load on the monitored server. Nothing is installed on the SAP ASE server to be monitored.
Q: What is involved in running a Database Performance Analyzer for SAP ASE trial?
A: A free trial is instantly available by downloading Database Performance Analyzer for SAP ASE from this site. The install takes just minutes, and as soon as data is captured, you’ll begin seeing results. A free trial key enables unrestricted usage across an unlimited number of servers for a 14 day period.
Q: Can Database Performance Analyzer for SAP ASE monitor other databases besides SAP ASE Server?
A: Yes, Database Performance Analyzer for SAP ASE also supports SQL Server, Oracle and DB2, all from the same installation. Just point Database Performance Analyzer for SAP ASE at the database instances to be monitored, then view them all from the same interface.
- See database performance information for specific application within the SolarWinds Orion interface
- Identify performance bottlenecks in both Amazon RDS and databases running on EC2 instances
- Simplified deployment using a pre-configured Amazon Machine Image (AMI)
- Annotation Tracking: Add notes to timeline to enable developers see what has changed during the specified period
- Storage I/O Analysis
- Monitoring, correlation and history on I/O performance
- Latency and throughput of storage systems
- Clear visibility of storage performance and it’s effect on SQL response time
- Resource Metrics Baselines
- SQL Statement Analysis and Advise Database File/drive tab
- Alert Improvements
- Resource Metric Alerts
- Alerting Blackouts
- Extended Version Support
- SQL Server 2014
- Oracle 12c (single tenant)
- DB2 10.5
- Read Less
+ Read More
Active Directory Integration - Authentication support via Windows Active Directory (AD)
- Use Active Directory credentials for Database Performance Analyzer login, roles and permissions.
- Single sign-on streamlines the login process.
- Ensure compliance with password strength and expiration policies through Active Directory.
Ignite Central - Scales to support large Database Performance Analyzer deployments
- Single view of critical problems worldwide.
- Exception based management -only see extraordinary events.
- Scales to thousands of monitored instances.
- Read Less
+ Read More
To see a complete version history for SolarWinds Database Performance Analyzer, please visit our