Skip to content
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

MSSQL default checks and policies

The Agent Client Collector provides the following default checks and policies for MSSQL Metrics monitoring.

TypeCheckDescriptionUsage and Usage ExampleOutput
Metricapp.metrics-mssql-queryGeneric MSSQL query class which accepts a query and dumps metrics.

winchecks metrics-mssql-query (options)-d, --database DATABASE Database schema to connect to (required)

-q ,--query The query to execute, should return a list metric name and value, for example SELECT METRIC_NAME, VALUE FROM GV$SYSMETRIC

-h, --host HOST Host name to connect to, defaults to localhost

-r, --port PORT Port to connect to, defaults to 1433

-s, --scheme SCHEME Metric naming scheme, text to prepend to .$parent.$child,

Usage Example

.winchecks metrics-mssql-query -d master -H localhost -p 1437 -q "select name,size from sys.database_files"

Custom metrics defined in the parameters, which also contain value and timestamp.

Parent Topic:Agent Client Collector Monitoring default checks and policies