SQL Server Performance Tuning with AI | What’s New in SQL Diagnostic Manager 14.0

Still chasing slow queries and tuning indexes manually? This walkthrough shows what’s new in SQL Diagnostic Manager 14.0 and how to speed up SQL Server performance tuning using AI. SQL Diagnostic Manager 14.0 brings AI-powered query and index optimization directly into your monitoring workflow, so you can get from problem to recommendation faster without switching tools. Take a look at how these updates fit into your day-to-day performance tuning. Explore the new AI features: https://www.idera.com/products/sql-diagnostic-manager/ai-faq/ ----------------------------------- CHAPTERS: 0:00 — Why AI in SQL Server performance monitoring 0:41 — How to enable the AI feature 1:05 — Security model and user permissions 1:19 — Queries tab: Statement vs Signature mode 2:47 — Prescriptive analytics (still available in 14.0) 3:34 — AI-powered query optimization 5:00 — Submitting a statement for AI analysis 5:30 — Results: optimized query and index recommendations 5:59 — Rollback option 6:17 — AI-powered schema and index optimization 6:36 — Multi-select: analyze up to 5 statements 7:19 — Schema and index results walkthrough 7:57 — Update notifications 8:44 — Trial and customer portal info