- Release Notes
- Install or Upgrade
- DPA Installation and Upgrade Guide
- DPA installation overview
- DPA installation preflight checklist
- DPA system and monitoring requirements
- Install DPA
- Create the repository database
- Uninstall DPA
- Upgrade DPA
- Get Started
- DPA Getting Started Guide
- How do I get started with DPA?
- Register database instances
- Examples of investigating performance issues with DPA
- Create a DPA alert to monitor SQL statement execution time
- Create a DPA report to track wait types for a single SQL statement
- After evaluation, activate DPA licenses
- Integrate DPA with the Orion Platform
- Beyond Getting Started with DPA
- DPA Administrator Guide
- DPA licensing
- DPA license types
- DPA registration and licensing options for clustered environments
- Requirements for monitoring a database instance running in a VM cluster
- Purchase and view DPA licenses
- Activate DPA licenses
- Allocate or deallocate DPA licenses
- Troubleshoot over-allocated DPA licenses
- Deactivate your DPA licenses
- Register a database instance for monitoring with DPA
- Database instances DPA can monitor
- Register multiple database instances
- Register an Oracle database
- Register a SQL Server database
- Register a Sybase database
- Register a DB2 database
- Register a MySQL database
- Register an Amazon RDS for Oracle database
- Register an Amazon RDS for SQL Server database
- Register an Amazon RDS for MySQL or Aurora database
- Register an Azure SQL database
- Unregister a monitored database instance
- Database instance groups
- Monitor database instances with DPA
- Investigate performance issues with DPA
- Access DPA query or table tuning advisors
- Use DPA's query performance analysis to find the root cause of performance issues
- Investigate inefficient queries running against a table
- Identify blocking sessions and deadlocks with DPA
- Find and investigate unusually long wait times (anomalies)
- About anomaly detection in DPA
- Add an annotation to document a change to the database
- Manage SQL statement properties
- Resource metrics in DPA
- DPA user accounts
- DPA alerts
- View the status of DPA alerts
- Configure a DPA alert
- Send SNMP traps from DPA alerts
- Stop DPA alerts for a period of time
- Use DPA to alert on increases in SQL wait times
- Create a custom DPA alert to display the name of the active node in a SQL Server cluster
- Create a DPA alert group
- Create and manage DPA contacts and contact groups
- Notification policy for DPA alerts
- DPA reports
- Link together separate DPA servers
- Automate tasks with the DPA REST API
- DPA administrative tasks
- View DPA data in the Orion Web Console with DPAIM
- Architecture of the DPA Integration Module
- DPA and SAM integration with DPAIM
- DPA and SRM integration with DPAIM
- Azure SQL support with DPAIM
- DPAIM integration overview
- Requirements for the DPA Integration Module
- Prepare SAM applications for DPAIM integration
- Set up the DPA Integration Module
- Manage relationships to database instances, applications, and storage objects
- DPAIM relationship detection
- DPAIM Discovery Central
- DPA data in the Orion Web Console
- DPA alerting in the Orion Platform
- DPA reporting in the Orion Platform
- Database instances in the AppStack environment
- Customize a DPAIM view and apply limitations
- DPAIM account limitations
- Troubleshooting DPAIM issues
Register a virtual machine and view performance data
When a database instance runs on a virtual machine, you can register the VM in addition to the database instance. When you register a VM, you can view performance metrics from the VM, the physical host, and the storage system. DPA displays metrics from all these layers of infrastructure on a single screen. You can use this data to correlate events in the underlying layers with performance issues in the database instance.
Monitoring a VM requires a VM license.
Register a VM
- Near the top left of the DPA homepage, click Register VMware for Monitoring.
- Enter the connection credentials for a VMware ESX/ESXi Host or a vCenter Server.
In most cases, DPA automatically detects the database instances running on the virtual machine. On the DPA homepage, the VM icon is displayed in the Type column.
Manually link a database instance to a VM
If DPA does not automatically associate a database instance with the VM that it runs on, you can manually link it.
- On the DPA homepage, click the Action menu to the right of the database instance name.
- Select Link to Virtual Machine.
- Select the virtual machine and click Link.
Click Yes at the confirmation message, and then click OK.
The database instance is listed under Running in a VM, and the VM icon is displayed in the Type column.
View VM performance data
After you register a VM, you can view recent performance data immediately. DPA must gather data for a few days before it shows performance trends and baselines.
If the trial period is over, you must allocate a VM license to the database instance before you can view VM performance data.
- At the top of the DPA homepage, click Virtualization.
In the Database Instance list, click a database instance.
DPA shows performance data from the database instance followed by metrics from the VM, the physical host, and the storage layer. Use these graphs to correlate waits in the database instance with events in the underlying layers.