Query Specific Wait Statistics helped explain a sudden customer-query slowdown. The remaining workload ran normally, and recompilation had not helped.
PARALLEL_BACKUP_QUEUE Wait on a Slow RESTORE FILELISTONLY
A reader asked me what the PARALLEL_BACKUP_QUEUE wait means. Their RESTORE FILELISTONLY ran for a long time on a backup of about 1.5 TB and ended with a media error. I believe a problem with the backup media makes the command run long and shows this wait.
PAGELATCH_UP Waits and Suspended Sessions: Find the Hot Page
PAGELATCH_UP waits mean that sessions queue for the same page in memory, and that page can be named. This post reads the waiting sessions, turns the resource into a database, a file and a page, and tells an allocation page from an ordinary one. It then lists the fixes for tempdb and for a user database.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.
Consulting 102 – What Do I Promise in Every Engagement?
Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.
WRITELOG Waits: Finding What Slows Transaction Log Writes
Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.