SQL Query

SQL Query: This is the exact SQL Query used to test the resource. This can be as simple as "select 0" or something more complex, based upon your requirements. This can be incredibly powerful for accessing MSSQL server information, application-specific data, and more. This SQL query should return a scalar result for evaluation below.
Fail if scalar result: When checked, this resource will be set to 'failure' state when the scalar value returned by the SQL Query above is evaluated using the comparison operators and value specified. This can be useful to check a log table, for example, to see if an application is running and logging properly.
Fail if slower than: When checked, this resource will be set to 'failure' state when the query takes longer than this value to execute. This is useful to determine the general performance of your database server. Note that the value is specified in milliseconds(ms). 1000ms is one second.

See Also: