Creating SQL Query Monitors
Follow the given steps:
Click on New Monitor. Click on SQL Query Monitor.
Provide Display Name.
Enter the Host Name of machine in which DB is running
Enter the Port Number
Select the DB you require.
Enter the User Name, Password, Database name of the selected DB
Select Yes if you want to see the SQL Query output
Enter the SQL Queries you want to monitor
Enter the polling interval time in minutes.
If you are adding a new monitor from an Admin Server, select a Managed Server.
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.
Click Add Monitor(s). Upon adding the SQL Query monitor,
you can view the details of the newly added SQL Query monitor
See Also