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.
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.
Optional, value of the second column first cell of the query result.
A default description of the monitor. You can override the default description by adding to or replacing the text, which is automatically saved. The variable to access this field is
Changing the default description to specify what will be monitored can be helpful when receiving alerts and notifications later.
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.
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 Credentials Library. See Understand the Credentials Library for details.
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.
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.
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.
Select the Convert Value check box to open the Formula box where you can 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 Convert values in data transformations for SAM component monitors for more information.
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.
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.
Add notes for easy reference. You can access this field by using the variable,