Database Query (Microsoft SQL Server)

The Microsoft SQL Server Query Check component provides you with real-time information about the state and health of a Microsoft® SQL Server application on a specific device. You may add a SQL Server Query component to either an application profile or an application instance.

Configure the following for database components:

• Name. Enter a unique name for the component.
• Description. 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.
• Port. Enter the database server port number if other than the standard database port number.
• Connection 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.