View tour to see how you can quickly correlate VMware metrics and configuration to the database and identify the performance impact of events like vMotion™ (3 min)
Optimize Database Performance on VMware
Finally, you can monitor performance of Oracle, DB2, Sybase and SQL Server on VMware within a single tool. The DPA VM Option provides a complete picture in visual charts that are easy to understand. See a direct correlation between SQL query response time and VMware resource metrics. Understand the real impact of VMware configuration and events like vMotion on your database performance. Stop wasting time chasing down the wrong path.
It's the one tool that all DBAs, Developers, DBA managers, and Virtual Administrators can use to quickly pinpoint the root cause of performance issues and prioritize action.
TOP 5 Reasons to Use SolarWinds’ Database Performance Analyzer VM Option
Maximize performance of Oracle, DB2, Sybase, and SQL Server on VMware.
The DPA VM Option correlates SQL response time with VM resources, the physical host, storage, and network.
When running databases on VMware servers, there is often concern about performance degradation. In fact, many IT pros find it challenging to monitor and analyze database performance on virtual machines because there is no way to see through the entire stack, from database to resources. VMware tools don’t cover the database layer, and conventional database tools don’t capture meaningful resource information from virtual servers.
For example, what happens if resource contention results from additional VMs being placed on the same host where the database VM is located? Similarly, who will have the visibility needed to monitor how performance is impacted if a VM is moved to another physical host with limited resources?
DPA VM Option provides this critical visibility, giving DBAs, developers, DBA managers and virtual administrators simple visual charts that clearly correlate VMware metrics and configuration to database performance. DPA VM Option exposes the multiple layers of the database and virtual machine architecture, including database instance, virtual server and physical host server resources. By knowing what changes in the virtual server impact CPU, memory, or I/O, a DBA can ensure reliable operations and service levels, and optimize performance in a virtualized environment.
Learn More about SQL Server and Oracle on VMware »
Resolve Database Virtualization Issues Faster
The Database Performance Analyzer VM Option helps quickly identify the root cause of performance issues for databases on VMware
Resolving problems with databases on VMware can be more time-consuming and complex than for databases on physical servers. Is the cause of the problem on the physical host or the virtual host? Is the cause of the problem related to VMware configuration? Is there a “noisy neighbor” in the virtual environment causing resource contention? Was there a vMotion event in the virtual environment? A great deal of time can be wasted guessing the cause and making fixes that won’t resolve the issue.
With DPA VM Option, DBAs can quickly identify the exact root cause of database application performance issues. Using easy-to-understand bar charts, DPA VM Option gets to the problem quickly and shows objective evidence, so there is no finger-pointing about who is responsible.
DPA VM Option is the only performance solution that shows three key components of the problem: the query affected, the wait event or 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 DPA VM Option the fastest way to resolve issues for databases on VMware.
Learn More about identifying the root cause in 4 clicks»
Eliminate finger-pointing across the IT team
Database Performance Analyzer VM Option builds collaboration among DBAs, Developers, Q/A, and Virtual Administrators
Often, VM administrator and DBA teams are siloed, making it challenging to find and fix the root cause of performance problems. DPA VM Option allows everyone in IT to collaborate on the performance of applications in a virtualized environment, enabling better service and faster time to market.
With DPA VM Option, virtual administrators can quickly assess the impact of changes in the virtual environment with database performance. Developers have read-only visibility to query performance on production and staging servers, allowing them to incorporate application performance into their development cycles. 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 databases and monitoring load.
Learn More »
Improve End-User Application Performance
Response Time Analysis helps you make changes that end-users will notice when their apps run faster.
DPA VM Option applies Response Time analysis, measuring the time for query response, rather than focusing on conventional server health metrics. DPA VM Option measures time associated with each tiny operation - or wait type or wait type - and uses it to expose delays in end user service. This is the most important indicator, since it shows applications waiting on the database to respond.
DPA VM Option doesn’t stop there. It gathers real time session data, server resource levels, and query information of your database performance. It also analyzes historical trends of response time over multiple dimensions - such as wait type program, and execution plan. Then DPA VM Option correlates the data to lead the DBA through the most important problems and solutions.
Software as a Service (SaaS) companies face a critical decision when it comes to maximizing application performance while scaling rapidly. See how to prepare for when you company goes supernova.
Learn More »
No Agents and No Load
SolarWinds’ database virtualization software is unique with no installed agent and less than 1% load on monitored servers.
DPA VM Option monitors database instances, virtual hosts, and vCenter without installing any software on the monitored systems. It is the lightest, least-intrusive method of capturing combined database, physical server, and virtual server data.
DPA VM Option 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. DPA VM Option is installed on Windows® or UNIX®/Linux® servers. The repository database is configured in a SQL Server or Oracle® instance, often a test or development system. DPA VM Option's agentless probes reach across the network to the monitored databases - SQL Server as well as other vendors - and pull performance statistics back to the repository for analysis and reporting.
Learn More about agentless database tuning »
System Requirements - One Software Fits All
Windows, Linux or UNIX
- Database Performance Analyzer for VM repository can be either SQL Server 2005, 2008, 2012, 2014
- Oracle 9i,10g, 11g, 12c (Single tenant)
Supported monitored databases in 9.0 include:
- SQL Server 2005, 2008, 2012, 2014
- Oracle 9i,10g, 11g, 12c (Single tenant)
- Sybase ASE 15.0.x, 15.5, 15.7 (also called 16)
- DB2 LUW 9.x, 10.1, 10.5
2GB per monitored instance
- - "Express" editions of either SQL Server or Oracle can be used for the DPA VM Option 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, DPA VM Option should not be installed on a laptop or any other computer that gets powered down frequently.
- - DPA VM Option needs to be installed on a server that does not contain monitored instances in order to ensure negligible load on the monitored Instances.
- - For VMware vCenter Servers: DPA VM Option supports connections to ESX/ESXi and/or vCenter. vCenter is not required, but highly recommended.
- VMware ESX/ESXi 4.0 and higher
- VMware vCenter 4.0 and higher
- One time entry of a read-only VMware password will be required. The password is encrypted and not visible to DPA end-users.
NOTE: The minimum server requirements listed assume default configuration. Significantly increasing the poll rate or statistic collection rate could result in additional load on the server, which may require a larger CPU or additional memory.
5 Risks for Databases on VMware
Virtualization makes it much more difficult for DBAs to see the interaction between the database and the underlying server resources. Here are five scenarios that merit attention for DBAs with VMware.
Monitoring Database Performance on VMware
Databases are one of the last frontiers for virtualizing into a VMware environment. They can be very resource intensive, so many companies have been hesitant to move them into a virtual environment. Most of the hesitation has come from poor experiences during initial tests of VMware. Many of our customers are successfully running databases inside VMware and the key for them was monitoring the correct metrics that can help show where the bottlenecks are. This paper will review the VMware metrics that helped many companies have a far better virtualization experience.
Q: How is DPA VM Option licensed??
A: Database Performance Analyzer VM Option is an additional cost add-on option. It is licensed per monitored SQL Server instance and per core on Oracle, DB2 and Sybase (the lesser of vCPUs or physical CPU cores). Using the 100% web-based interface, an unlimited number people, including DBAs, system/virtualization admins, and storage admins can access DPA without additional cost.
DPA’S pricing model makes adding additional monitored instances more affordable and less confusing than the core-based licensing for Oracle®, DB2®, and Sybase® products.
Q: On what server is DPA VM Option installed?
A: It is recommended that DPA is installed on a non-production Windows, Linux or UNIX server. No software is installed on the database servers to be monitored.
Q: Are there agents or other DPA VM Option software installed on the database instance to be monitored?
A: No, DPA VM Option is agentless, and places less than 1% load on the monitored server. Nothing is installed on the monitored servers or VM.
Q: What is involved in running a DPA VM Option trial?
A: A free trial is instantly available by downloading DPA 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. After purchase the license key will unlock these time restrictions.
Q: Which databases can DPA VM Option monitor?
A: All downloads of DPA contain the ability to monitor SQL Server, Oracle, DB2, and Sybase on bare metal, VMware, Windows, or Linux/UNIX. There are only two different downloads of DPA: one for Windows, and oone for Linux/UNIX installation.
- 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 for SQL Server
- 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 DPA deployments
- Single view of critical problems worldwide.
- Scales to thousands of monitored instances.
- Read Less
+ Read More
To see a complete version history for SolarWinds Database Performance Analyzer, please visit our release notes