Microsoft SQL Server

Microsoft SQL Server is a relational database management system. For more information, see the SQL Server documentation.

Configure the Ops Agent for SQL Server

When using the Ops Agent on a Microsoft Windows VM, the agent automatically collects SQL Server metrics. No additional configuration is required.

What is monitored

The following table lists of metrics that the Ops Agent collects from SQL Server.

The "metric type" strings in this table must be prefixed with agent.googleapis.com/mssql/. That prefix has been omitted from the entries in the table.

Metric type Launch stage
Display name
Kind, Type, Unit
Monitored resources
Description
Labels
connections/user GA
SQL Server open connections
GAUGEDOUBLE1
aws_ec2_instance, gce_instance
Currently open connections to SQL server. Sampled every 60 seconds.
transaction_rate GA
SQL Server transaction rate
GAUGEDOUBLE1/s
aws_ec2_instance, gce_instance
SQL server total transactions per second. Sampled every 60 seconds.
write_transaction_rate GA
SQL Server write transaction rate
GAUGEDOUBLE1/s
aws_ec2_instance, gce_instance
SQL server write transactions per second. Sampled every 60 seconds.

Table generated at 2021-12-02 23:47:27 UTC.