SQL Diagnostic Manager Virtual Tour: Detect, Diagnose & Fix SQL Server Performance Issues
See how SQL Diagnostic Manager helps DBAs detect, diagnose, and fix SQL Server performance issues using an end-to-end performance monitoring workflow. In this SQL Diagnostic Manager virtual tour, Mark Slavens walks through how DBAs and SQL Server teams can spot abnormal trends, identify query performance bottlenecks, understand what is driving performance issues, and move toward a faster resolution. The session focuses on the full SQL Server performance workflow, from early warning signs and performance alerts through investigation, diagnosis, and root cause analysis. SQL Diagnostic Manager helps database administrators monitor SQL Server performance, identify health and availability issues, analyze query behavior, and troubleshoot performance problems from a centralized view. This video shows how SQL DM features can help teams narrow in on the root cause when SQL Server environments start slowing down. Topics covered include: How SQL Diagnostic Manager helps detect SQL Server performance issues How to identify abnormal trends and early warning signs How DBAs can investigate SQL Server query performance bottlenecks How to move from alert detection to diagnosis and resolution Root cause analysis workflows for SQL Server performance problems Using SQL DM features to understand what is driving slowdowns Practical monitoring workflows for DBAs and SQL Server teams How to reduce time spent troubleshooting SQL Server performance issues ----------------------------------- CHAPTERS: 0:00 Introduction and session overview 1:05 SQL Diagnostic Manager architecture 2:49 Agentless monitoring and data collection 4:43 Desktop and web access, cloud support, and licensing 7:14 Monitor SQL Server health across the enterprise 9:30 Organize and secure instances with tags 11:19 Detect blocking and performance problems 12:50 Add custom performance counters 14:16 Configure alert thresholds and templates 16:31 Automate alert responses 19:25 Get prescriptive recommendations and fix-it scripts 23:39 Investigate blocking chains and deadlocks 24:54 Replay past incidents with History Browser 28:19 Analyze historical session activity 30:50 Trace or kill a blocking session 32:51 Analyze query performance 34:18 Diagnose queries and review execution plans 36:56 Compare statements, signatures, and query history 39:24 Drill into query waits and workload spikes 43:17 Analyze CPU, memory, disk, and file activity 46:30 Monitor database and transaction log space 48:03 Monitor Availability Group health 48:20 Investigate TempDB usage and contention 49:09 Review backup and restore history 50:56 Find fragmentation and rebuild indexes 52:42 Monitor SQL Agent jobs 54:31 Build performance, trend, and forecasting reports 58:26 Use the SQL Diagnostic Manager web console 1:00:56 Trial information and closing -------------------------------------- This video is ideal for SQL Server DBAs, database administrators, SQL developers, database engineers, IT managers, and teams responsible for SQL Server monitoring, database performance, and uptime. Watch this virtual tour to learn how SQL Diagnostic Manager supports a complete detect, diagnose, and fix workflow for SQL Server performance management. Learn more about SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/ Start a free trial of SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/free-trial/ Explore SQL Server performance monitoring with SQL Diagnostic Manager: https://www.idera.com/products/sql-diagnostic-manager/use-case/sql-server-performance-monitoring/ Watch an overview of SQL Diagnostic Manager: https://www.idera.com/resource-center/videos/an-overview-of-sql-diagnostic-manager/ Learn how to set up SQL Diagnostic Manager: https://www.idera.com/lp/gettingstartedguides/sql-diagnostic-manager/ Explore IDERA database monitoring solutions: https://www.idera.com/database-monitoring-solutions/ Explore IDERA SQL Server tools: https://www.idera.com/ #SQLServer #SQLDiagnosticManager #SQLServerMonitoring #SQLServerPerformance #DatabaseMonitoring #DatabaseAdministration #DBA #QueryPerformance #RootCauseAnalysis #IDERA