SQL Server Datadog Alert Setup

I need Datadog monitors configured for our on-prem SQL Server estate and cloud databases. The goal is to have actionable alerts in place for:

• Performance thresholds (CPU, memory, waits, long-running queries)
• Error occurrences drawn from the SQL Error Log
• Resource utilization across disks, tempdb, and buffer cache
• Agent job failures and long runtimes
• AlwaysOn AG health, including role changes and replica sync state
• Server-offline or heartbeat loss

I already have the Datadog agent running on the hosts; what I’m missing are the right queries, monitor definitions, and alert channels. Your work should include creating the monitors, testing each one to prove it fires and clears correctly, and documenting any custom queries or variables you add so we can maintain them after hand-off.

Deliverables
1. Datadog monitor definitions (JSON export or Terraform, whichever you prefer) covering all alert types listed above.
2. A short runbook that explains the metrics, thresholds, and expected responses.
3. A brief hand-over session or recording showing the monitors firing in a test scenario.

Acceptance criteria: every alert must trigger and recover cleanly in Datadog with clear titles, tagged resources, and meaningful messages.

If you have recent experience building SQL Server dashboards or monitors in Datadog, this should be straightforward. Let me know your estimated timeline and any prerequisites you’ll need from my side.