Integrating Database Performance Analyzer (DPA) with a system like SolarWinds Orion helps in expanding obtainable data. This makes it easier to identify the cause of performance problems. If you want to get a more all-inclusive opinion of what is affecting both the user and your Information Technology (IT) infrastructure, you can see database instance data together with other environmental aspects.
Consider a system that displays a DPA-specific resource that retrieves information directly from the DPA. Additionally, integration helps in expanding the information in other system resources. Information like database wait time plays a vital role in improving the capability to troubleshoot slow reaction times or identify database cases that require additional resources. Once you have integrated the DPA, you will be able to do various tasks.
Viewing information from several DPA servers
When you incorporate several DPA servers with a platform, the Database summary view display will capture the aggregated from all serves. Therefore, this allows you to dig deep and have a chance to view data from a server.
Incorporate with server and application monitor (SAM)
In case you are using SAM, the integration with DPA adds observations and resources that are accessible with integration only. This information presents an application-centric viewpoint of database presentation assists you to understand that the primary cause of performance issues is in the submission or the database. Moreover, a Database category is included in the Application Stack offered by SAM, whereby you can use the database instance to examine the general health of your database instance and to troubleshoot the performance and availability issues.
Incorporate with SRM
If your system is designed to use SRM, incorporation with DPA will add views and resources that are found only with integration. This is very important since the information provided you with a storage-centric perspective of database performance and assists you to find out of the primary source of performance glitches is in the storage object or the data. With this integration, you have a chance to build signals in the Web Console that are influenced by data aggregated from database instances. Additionally, you can choose DPA resources while creating information in the Web Console. If you incorporate DPA (Integrating Database Performance Analyzer) metrics with metrics from different products, the dashboard will help you determine how inquiries and database waiting time is connected to application and groundwork enactment. Note that both the DBAs and non-DBAs are designed to use DPA information to assist you defines if the cause of the performance problems is the database or application.
How it works
The integration involves logging to the folder comprising JSON formatted for various events API. After that, a VBScript iterates across all the files in the queue where alerts are produced and send the JSON to the system. It erases the file alert folders once it has been accepted by the server