🚀 Azure SQL Performance Monitoring & Diagnostic Queries

Production-ready Azure SQL performance tuning and monitoring scripts using Dynamic Management Views (DMVs).
Designed for DBAs, Developers, and DevOps engineers managing Azure SQL Database (PaaS).

📌 Repository Purpose

This repository helps identify:

• 🔎 Slow and high-CPU queries
• 📊 Excessive logical and physical reads
• ⚠️ Deadlocks and engine-level errors
• 🔐 Azure SQL system events
• 📈 Query performance bottlenecks

---

📂 Files Included

---

File Description

---

Running_SQL_Optimized.sql Advanced performance monitoring query

ErrorLogQuery_Optimized.sql Azure SQL event & error log monitoring query

---

🧠 Features

✔ Parameterized execution
✔ Query text extraction
✔ Average performance metrics
✔ Time-window filtering
✔ Production-ready filtering

---

🛠 Requirements

• Azure SQL Database
• VIEW DATABASE STATE permission
• SSMS or Azure Data Studio

---

🔍 Keywords

Azure SQL performance tuning, Azure SQL monitoring scripts,
sys.dm_exec_query_stats example, Azure SQL error log query,
slow query detection, Azure SQL diagnostics, database troubleshooting.

---

👨‍💻 Author

Rahul Sharma
Director -- Engineering & Delivery
Azure | Cloud | DevOps | Cybersecurity

---

Generated on: 2026-02-12 10:57 UTC