References > Component Monitor Types > SQL Server User Experience Monitor

SQL Server User Experience monitor

This 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.

The SQL statement you use for this query must return a numerical value, not a varchar.

This monitor has the ability to 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.

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

This field provides a default description of the monitor. You have the ability to override the default description by adding to or replacing the text, which is automatically saved. The variable to access this field is ${UserDescription}.

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. If the credential you need is not already present in the credentials list, use the Quick Credentials section to add a new credential.

SQL Query

This field allows you to 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

This field allows you to 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

This field allows you to 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

Allows you to 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

Checking the Convert Value check box opens the Formula box. From here, you have the ability to manipulate the returned value with a variety of mathematical possibilities. You can choose common functions from the drop down lists to manipulate the returned value, or you can select the Custom Conversion option. See setting Conversion value for more information.

Response Time Warning Threshold

This field allows you to 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

This field allows you to 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

This field allows you to 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

This field allows you to add notes for easy reference. You can access this field by using the variable, ${UserNotes}.