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-di...
Start a free trial of SQL Diagnostic Manager:
https://www.idera.com/products/sql-di...
Explore SQL Server performance monitoring with SQL Diagnostic Manager:
https://www.idera.com/products/sql-di...
Watch an overview of SQL Diagnostic Manager:
https://www.idera.com/resource-center...
Learn how to set up SQL Diagnostic Manager:
https://www.idera.com/lp/gettingstart...
Explore IDERA database monitoring solutions:
https://www.idera.com/database-monito...
Explore IDERA SQL Server tools:
https://www.idera.com/
#SQLServer #SQLDiagnosticManager #SQLServerMonitoring #SQLServerPerformance #DatabaseMonitoring #DatabaseAdministration #DBA #QueryPerformance #RootCauseAnalysis #IDERA
On this page of the site you can watch the video online SQL Diagnostic Manager Virtual Tour: Detect, Diagnose & Fix SQL Server Performance Issues with a duration of hours minute second in good quality, which was uploaded by the user IDERA Data Tools 22 June 2026, share the link with friends and acquaintances, this video has already been watched 21 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
