---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# MSSQL default checks and policies

# MSSQL default checks and policies {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

The Agent Client Collector provides the following default checks and policies for MSSQL Metrics monitoring.
{#ms-sql-default-checks-and-policies__table_rgw_psy_vrb__entry__5}

| 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. |
[Table 1. MSSQL Metrics]

{#ms-sql-default-checks-and-policies__table_rgw_psy_vrb}