When you integrate DPA with the Orion Platform, DPA and SolarWinds SAM can be integrated to provide an application-centric perspective of database performance. Database administrators and system administrators can use the DPA and SAM integration to:
Integrating DPA with SolarWinds Server & Application Monitor (SAM) provides specific features only available when DPA and SAM are integrated.
You can create two types of relationships between applications monitored by SAM and database instances monitored by DPA:
The first relationship type adds a DB Performance tab to the Application Details view for quick access to DPA resources.
The second relationship type populates data to the following resources:
Applications Using All My Databases
This resource displays all applications monitored by SAM that query database instances monitored by all your DPA servers.
Applications Using My Databases
This resource displays the applications monitored by SAM that query database instances monitored by the selected DPA server.
Applications Using This Database
This resource is on the Database Instances view. It tells you which applications are querying this database instance.
Database Response Time (Client)
This resource is on the Application views for applications that query databases monitored by DPA. You can access these views by clicking a client application in the "Applications Using..." resources. For example, in the image above, click Microsoft IIS.
The Database Response Time (Client) resource tells you how long your application is waiting on the database and why. The histogram breaks down the amount of time your application waited into discreet wait types, which identify what the database was doing. It often identifies resource contention. The icon next to each wait type provides a description of what this wait type means, common solutions, and the role within your organization most capable of this work.