The next stop in my SQL Server Monitoring Week is SQL Plan Warnings. I take a brief look at the warnings hidden in query plans and why they are worth watching.
Memory-Optimized tempdb Metadata: Turning It On and Checking It
Diagnose memory-optimized tempdb metadata candidates, plan the required restart, verify activation, and monitor contention and memory.
The Handful of Counters That Actually Matter
Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.
SQL Server Monitoring Week – SQL Diagnostic Manager
SQL Server Monitoring Week continues. Many clients struggle to monitor SQL Server health, so today I take a brief look at SQL Diagnostic Manager (SQLDM).
Many-to-Many Merge Join and the Worktable in STATISTICS IO
Diagnose a many-to-many merge join and its worktable, verify true uniqueness, and compare join choices without changing legitimate matches.
Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE
My SQL Server Performance Tuning Practical Workshop for EVERYONE is very interactive, and we use Slack for that part. Here is how to connect before the class.
14 Days to #SQL Server Performance Tuning Practical Workshop for EVERYONE
Only 14 days left to my SQL Server Performance Tuning Practical Workshop for EVERYONE. Due to high demand, I just opened 5 more seats to learn my business secrets.