SQL Server component boxes

You may configure the following boxes for the SQL Server component:

Name. Enter a unique name for the component.
Description. (Optional) Enter additional information about the component.
Critical. Click to select this check box if the component is critical.
Note: Components specified as critical cause the application to go into a down state when the component is out of threshold. Non-critical components cause the application to go into a warning state. For more information on application states, see Working with application states.
Polling frequency. Select a time (in minutes or hours) you want APM to wait between polls.
Server Address. Enter in ServerName\Instance format (for example, WUGServer\SQLEXPRESS).
Port Number. Enter the database server port number if other than the standard database port number.
Polling timeout. Enter the length of time APM attempts to connect to the selected device. When the time you enter is exceeded without connecting, a timeout occurs and APM stops trying to connect to the device. This is considered a failed connection.
Query to Run. Enter a query you want to run against a database to monitor and check for certain database conditions. Only SQL SELECT queries are allowed.
Important: Make sure that you include the full database name in your query.
Warning threshold. Enter the component thresholds for the warning state. For example, if the component value is greater than 90 for 5 minutes, put the component in the warning state.
Down threshold. Enter the component thresholds for the down state. For example, if the component value is greater than 95 for 5 minutes, put the component in the down state.