Optimize Microsoft SQL Server with Datadog's database monitoring

on YouTube ↗11m

" summary

Datadog’s DBM shows slow SQL Server and Azure SQL queries by capturing execution plans, memory grant metrics and traces, letting teams compare historical plans to spot plan regressions and reduce latency. The platform surfaces query-level memory overcommit and recommends enabling memory grant feedback, raises anomaly monitors for long-running queries, and links into a prebuilt dashboard and 500 prebuilt integrations. One-click provisioning via the one-click Datadog in Azure portal accelerates deployment and end-to-end correlation.

AI-written summary · about

" chapters (6)

1. 0:00Datadog observability platform
2. 3:24Datadog for Windows and Azure
3. 5:11Datadog for SQL Server
4. 6:12SQL Server execution plans
5. 7:14Query performance metrics
6. 8:38SQL Server dashboards

" related talks

• 11mMonitor Microsoft Azure SQL with Datadog's Database MonitoringJenna Kozlowski, Arielle Russo · Microsoft Build 2023
• 49mPerformance Features in SQL Server and Azure SQLJavier Villegas · SQL Server Virtual Conference 2021
• 51mPerformance Tuning Azure SQL DatabaseMonica Rathbun · SQLBits 2023
• 50mYes, You Should Monitor Azure SQL DatabaseGrant Fritchey · SQLBits 2020
• 49mCome see your SQL Perfmon in the cloudBob Ward, Dimitri Furman · SQLBits 2024
• 01h 01mLatest Innovations for SQL and Operational Databases for DevelopersPeter Carlin · Visual Studio Live! Microsoft HQ 2022
• 53mOptimizing your Azure SQL Database workloadsSanjay Mishra, Denzil Ribeiro, Dimitri Furman · SQLBits 2020
• 44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud ProvidersLior Asta · SQLBits 2022