- 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.
Copyright 2003-2012 Sensible Software, Inc. All Rights Reserved.
Network Monitoring Software