SQL Query Monitors

 

Creating SQL Query Monitors

Follow the given steps:

  1. Click on New Monitor. Click on SQL Query Monitor.

  2. Provide Display Name.

  3. Enter the Host Name of machine in which DB is running

  4. Enter the Port Number

  5. Select the DB you require.

  6. Enter the User Name, Password, Database name of the selected DB

  7. Select Yes if you want to see the SQL Query output

  8. Enter the SQL Queries you want to monitor

  9. Enter the polling interval time in minutes.

  10. If you are adding a new monitor from an Admin Server, select a Managed Server.

  11. Choose the Monitor Group from the combo box to which you want to associate the Monitor (optional). You can choose multiple groups to associate your monitor.

  12. Click Add Monitor(s). Upon adding the SQL Query monitor, you can view the details of the newly added SQL Query monitor


See Also