MSSQL default checks and policies

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

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

    Table 1. MSSQL Metrics
    Type Check Description Usage and Usage Example Output
    Metric app.metrics-mssql-query Generic 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.