We recommend testing the T-SQL query in Redgate Monitor to make sure that data can be successfully collected from monitored objects within a reasonable duration.

1.  In the displayed dialog, the databases previously specified are selected by default. If you don't want to test every object, change the selection by unchecking the boxes.

   
   

2. Click the Test collection button. Redgate Monitor tests the query once against each selected database and displays its progress at the bottom of the dialog.

If an object fails the test, or the duration is significantly longer than expected:

• Check the exception or error messages displayed in the Return value column.
• Make sure the T-SQL query complies with the details mentioned in the Configure metric documentation
• Check for other problems with the T-SQL, such as invalid syntax or objects referenced in the query that don't exist in the database.
• Check the Monitored servers page (Configuration > Monitored servers) and the Alert Inbox for status errors or alerts affecting servers hosting selected instances.

Once you've fixed any connection or T-SQL problems, retry the test until it completes successfully.