Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Integration Module 11.0 Administrator Guide > References > Prepare SAM applications for integration

Prepare SAM applications for integration

Table of contents
No headers
Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Feb 20, 2017

Views: 27 Votes: 0 Revisions: 4

The DPA Orion Integration Module looks for database instances to relate to each other for the following application templates:

  • AppInsight for SQL
  • SQL Server 2005 - 2008 Performance (SQL)
  • SQL Server 2005 - 2008 Performance (WMI)
  • SQL Server 2012 Performance (SQL)
  • SQL Server 2012 Performance (WMI)
  • Oracle Database
  • Sybase ASE
  • IBM DB2
  • MySQL
  • MySQL 5.7.9 and later (Windows)
  • MySQL 5.7.9 and later (Linux/UNIX)
  • MySQL 5.7.8 and earlier (Windows)
  • MySQL 5.7.8 and earlier (Linux/UNIX)
  • MySQL Replication (Windows)
  • MySQL Replication (Linux/UNIX)

You can help successfully integrate more database instances by modifying some of your applications. These steps assume you assigned applications to nodes and all components use the correct credentials and connection settings.

AppInsight for SQL

To ensure that all component monitors use the correct credentials and connection settings:

  1. Edit the application monitor, and select all component monitors.
  2. Click Assign Credentials, and make sure that the correct credentials are used.
  3. With all of the components still connected, click Multi Edit.
  4. This step only applies to the SQL Server application templates: enter the database instance name.

SQL Server 2005 - 2008 Performance (SQL)

  1. Edit the application monitor, and open the settings for the User Connections component monitor.
  2. Override the SQL Server Instance property with the instance name, or leave it blank.

SQL Server 2005 - 2008 Performance (WMI)

  1. Edit the application monitor, and open the settings for the Buffer Manager: Buffer cache hit ratio component monitor.
  2. Override the Instance property with the instance name, or leave it blank.

SQL Server 2012 Performance (SQL)

  1. Edit the application monitor, and open the settings for the User Connections component monitor.
  2. Override the SQL Server Instance property with the instance name, or leave it blank.

SQL Server 2012 Performance (WMI)

  1. Edit the application monitor, and open the settings for the Buffer Manager: Buffer cache hit ratio component monitor.
  2. Override the Instance property with the instance name, or leave it blank.

Oracle Database

  1. Edit the application monitor, and open the settings for the Available free space (MB) component monitor.
  2. Set the Destination Point Type property to SERVICE_NAME or SID, according to the monitored Oracle database.
  3. Override the Destination Point Name property with the service name or SID.

Sybase ASE

  1. Edit the application monitor, and open the settings for the Transactions/sec component monitor.
  2. Override the Connection String property with the connection string for the Sybase database.

IBM DB2

  1. Edit the application monitor, and open the settings for first the Database Used Space (MB) component monitor.
  2. Override the Connection String property with the connection string for the DB2 database.

MySQL

  1. Edit the application monitor, and open the settings for first the Total Memory Used (MB) component monitor.
  2. Override the Connection String property with the connection string for the MySQL database.

MySQL Replication

  1. Edit the application monitor, and open the settings for first the Slave Replication Status component monitor.
  2. Override the Script Arguments property with:
    • Windows: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe,root,your_password
    • Linux: /usr/bin/mysql root your_password
Last modified
14:41, 20 Feb 2017

Tags

Classifications

Public