SQL Server component fields

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.