Microsoft SQL Server

The Microsoft SQL Server integration collects metrics from your SQL Server instances. The metrics provide transaction-rate information and also data on open connections.

For more information on SQL Server, 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.

After setting up a new SQL Server instance, you might not immediately see metrics display in Metrics Explorer. The Ops Agent begins collecting SQL Server metrics once there is database activity to report.

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 2022-05-12 12:50:53 UTC.