Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Database Performance Analyzer (DPA) > Database Performance Analyzer Getting Started Guide > Integrate DPA with the Orion Platform > DPA and SAM integration

DPA and SAM integration

Table of contents
No headers
DPA_GS_Home.png
video-icon.png
Check out this video (3:44) on integrating DPA and SAM.
 

When you integrate DPA with the Orion Platform, information from DPA is added to SolarWinds SAM resources to provide an application-centric perspective of database performance. Database administrators and system administrators can use the DPA and SAM integration to:

  • Analyze database performance within the context of a specific application.
  • Monitor applications, databases, and server performance from a single interface, and drill down to find the root cause of slow application performance.
  • Understand the relationships and dependencies among the layers of infrastructure from the perspective of an application.

Updated: November 30, 2017

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:

  • A SAM application and a DPA database instance are monitoring the same application.
  • A SAM application queries a DPA database instance.

The first relationship type adds a DB Performance tab to the Application Details view for quick access to DPA resources.

File:Success_Center/Reusable_content_-_InfoDev/DPAIM/DPAIM_Admin_Guide/0010-Introduction_to_the_DPA_Integration_Module/0020-DPA_and_SAM_integration/db-perf-tab.png

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.

File:Success_Center/Reusable_content_-_InfoDev/DPAIM/DPAIM_Admin_Guide/0010-Introduction_to_the_DPA_Integration_Module/0020-DPA_and_SAM_integration/apps-using-all-my-databases.png

Applications Using My Databases

This resource displays the applications monitored by SAM that query database instances monitored by the selected DPA server.

apps-using-my-databases.png

Applications Using This Database

This resource is on the Database Instances view. It tells you which applications are querying this database instance.

File:Success_Center/Reusable_content_-_InfoDev/DPAIM/DPAIM_Admin_Guide/0010-Introduction_to_the_DPA_Integration_Module/0020-DPA_and_SAM_integration/apps-using-this-database.png

Database Response Time (Client)

This resource is on the Application views for applications that query databases monitored by DPA. Click a client application in the "Applications Using..." resources to access these views. 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 File:Success_Center/Reusable_content_-_InfoDev/DPAIM/DPAIM_Admin_Guide/0010-Introduction_to_the_DPA_Integration_Module/0020-DPA_and_SAM_integration/info-icon.png 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.

File:Success_Center/Reusable_content_-_InfoDev/DPAIM/DPAIM_Admin_Guide/0010-Introduction_to_the_DPA_Integration_Module/0020-DPA_and_SAM_integration/database-response-time-client.png

Last modified

Tags

Classifications

Public