SQL Server User Experience Monitor

This SAM component monitor uses synthetic transactions to test the abilities of a Microsoft SQL Server database. The component monitor connects to the database, performs a query, and then retrieves the data. It can capture message text in the first row, second column of SQL query results. This string value is shown in the Messages field of the component monitor.

The SQL statement used in the query must return a numerical value, not a varchar.

Statistic

The statistic for this component monitor is the first row and column of the data retrieved by the query. It must be a numerical value.

Message

Optional, value of the second column first cell of the query result.

Field descriptions

Description

A default description of the monitor. To override the default description, add to or replace existing text. Changes are automatically saved. The variable to access this field is ${UserDescription}.

Customize descriptions to specify what will be monitored so related alerts and notifications are more meaningful later.

Enable Component

Determines whether the component is enabled. Disabling the component leaves it in the application in a deactivated state not influencing either SolarWinds SAM application availability or status.

Port Number

Select the Default Port or a Static Port from the drop down menu. If a static port is chosen, only values between 1 and 65535 are acceptable. Typically, port 1433 is used for this monitor.

Credential for Monitoring

Select a Windows credential or SQL Server credential that can access the database. Click a credential in the list, or use the <Inherit credential from node> option. If the credential you need is not in the credentials list, add it in the SAM Credentials Library.

SQL Query

Specify the SQL query used to test the database. The retrieved data is then used as the component monitor statistic. You may enter up to 4000 characters.

SQL Server Instance

Specify the SQL Server instance required to access the SQL Server database. Enter only the instance name. Do not prefix the instance name with the server name. To access the default instance, leave this field blank.

Initial Catalog

Specify the initial database (catalog) for the connection.

Use Windows Authentication first, then SQL authentication

Select this check box to access a SQL Server that supports or requires Windows Authentication, and specifies that the credential is a Windows credential instead of a SQL Server credential.

Query Timeout

Specify when this query should timeout in seconds. The default timeout period is 30 seconds.

Count Statistic as Difference

Changes the statistic to be the difference in query values between polling cycles.

Convert Value

Select the "Yes, convert returned value" option to display fields where you can select a common function or enter a custom formula. The Custom Conversion option provides basic arithmetic operators (+, -, *, /), plus built-in mathematical functions for more advanced conversions. See Convert values in data transformations for SAM component monitors.

Response Time Warning Threshold

Set the warning threshold conditions based on the response time. The response time is the time in milliseconds it takes SolarWinds SAM to determine that a component is not Down and to retrieve any statistical data.

Response Time Critical Threshold

Set critical threshold conditions based on the response time. The response time is the time in milliseconds it takes SolarWinds SAM to determine that a component is not Down and to retrieve any statistical data.

Statistic Threshold

Specify when a threshold that indicates a warning or critical level has been breached. Logical operators are in the drop down followed by a blank field for you to enter the value of this threshold. For example: Less than 15 for warning, Less than 5 for critical.

User Notes

Add notes for easy reference. You can access this field by using the variable, ${UserNotes}.