/plushcap/analysis/datadog/sql-server-metrics

Custom SQL Server metrics for detailed monitoring

What's this blog post about?

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


By Matt Makai. 2021-2024.