Database Administrators are often overwhelmed by the volume of performance data, frequently finding the “what” of a bottleneck but spending hours or days on the “how” of the resolution.
This session explores the evolution of SQL Diagnostic Manager from a deep observability platform to an intelligent optimization engine.
You’ll see how Query Monitor and Wait Statistics can be used to isolate high-impact performance issues, along with the new AI-powered capabilities in version 14.0 that help bridge the gap between identifying a slow query and implementing a verified fix.
Key Discussion Topics:
- Query Monitoring Mastery: How to utilize Signature and Statement modes to group problematic workloads and identify recurring performance offenders.
- Decoding Wait Statistics: Moving beyond resource metrics to understand the “why” behind query delays using wait-type analysis.
- AI-Powered Query & Index Optimization: A deep dive into the new 14.0 features that provide automated, workload-aware recommendations for single queries and complex schema structures.
- Maintaining DBA Control: Exploring the AI Optimization History and the importance of a “recommendation-first” approach that ensures all changes are audited and manually approved.
- Reducing MTTR: Practical workflows for turning a performance alert into a tuned index in minutes rather than hours.
Who Should Attend:
This webinar is designed for Database Administrators, SQL Developers, and IT Managers who need to scale their performance tuning efforts across large, complex SQL Server environments without increasing manual overhead.