Documentation forDatabase Performance Analyzer

Prepare SAM applications for DPAIM integration

The Database Performance Analyzer 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 LUW
  • 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