Get metrics from sqlserver service in real time to:
- Visualize and monitor sqlserver states
- Be notified about sqlserver failovers and events.
Install the dd-check-sqlserver package manually or with your favorite configuration manager
Edit the sqlserver.yaml file to point to your server and port, set the masters to monitor
When you run datadog-agent info you should see something like the following:
Checks
======
sqlserver
-----------
- instance #0 [OK]
- Collected 39 metrics, 0 events & 7 service checks
The sqlserver check is compatible with all major platforms