See who is connected, what is running, and what is blocking what; live, instead of reconstructing it from logs afterward. If you use SQL Diagnostic...
SQL Diagnostic Manager for SQL Server
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Capacity Planning & Forecasting: A Practical Guide and Workflow Walkthrough
Why Forecasting & Capacity Planning Matters If you use SQL Diagnostic Manager every day to monitor performance, keep an eye on alerts, and...
SQL Server History Browser Turns Incident Review Into an Investigation, Not a Guessing Game
"Users noticed slowness yesterday afternoon. What happened?" Every DBA team has fielded some version of that question, usually a day or two after...
A Slow Query Is Not Always a SQL Problem (Especially When SQL Server Is Virtualized)
A query that used to run in two seconds now takes twenty. The execution plan has not changed. The indexes are the same. CPU and memory inside the...
SQL Server Index Fragmentation: Detection to Fix
SQL Server index fragmentation is a page-ordering mismatch. The physical order of pages on disk stops matching the logical key order of the index,...
SQL Server Capacity Planning: A DBA’s Guide
Capacity problems in SQL Server rarely arrive without warning. A volume that fills up this month was trending that way for weeks, and the data to...
SQL Server Deadlocks Are Nearly Impossible to Catch in the Act: Here’s How to Stop Losing Hours to Them
Ask any DBA what their process looks like the moment a deadlock is reported, and you will usually hear some version of the same story: check the...
Alert Actions & Automated Responses: A Practical Setup Guide and Workflow Walkthrough
Why This Feature Exists — and Why You Should Be Using It You've already got SQL DM watching your servers and firing alerts when thresholds break....
How to Perform a SQL Server Health Check
Most DBAs handle SQL Server health one of two ways. Some work through a structured review on a schedule. The rest wait for a performance complaint...
Beyond the Health Check: How to Break Down SQL Server Wait Statistics by Database, User, and Application
Ask most DBA teams what their wait statistics are telling them, and the answer is usually an instance-level summary: “we’re seeing a lot of CXPACKET...
Stop Piecing It Together From Logs: How Live Session Monitoring Helps You Catch SQL Server Problems in the Moment
When something is clearly wrong with SQL Server performance but you can't immediately tell who or what is causing it, what does your team's first...
Baselines & Dynamic Thresholds: A Practical Setup Guide and Workflow Walkthrough
Why this matters Right now, most alert thresholds in SQL DM are static — one fixed number, all day, every day. The problem: "normal" doesn't look...