Custom SQL Server metrics for detailed monitoring
This text discusses how to monitor custom SQL Server metrics using Datadog. It explains two methods of collecting and monitoring these metrics: specifying performance counters beyond those the SQL Server integration queries by default, and using Windows Management Instrumentation (WMI) integration. The first method involves editing the SQL Server configuration file to collect metrics automatically from specific performance counters. The second method requires configuring the Agent's WMI integration's configuration file to gather metrics from WMI classes. By monitoring custom metrics, users can gain a deeper understanding of their SQL Server databases and optimize their performance.
Company
Datadog
Date published
Nov. 17, 2022
Author(s)
Rishabh Moudgil, Paul Gottschling
Word count
1014
Hacker News points
None found.
Language
English