MSQL_XP wait stats measure the time a query waits while an extended stored procedure such as xp_cmdshell or xp_dirtree runs. On Night 20 at the Clipboard Diner, an outside caterer takes over one station behind a curtain. Then two queries show you which session is waiting and which procedure it called, and the fixes move that work outside SQL Server.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
PREEMPTIVE Wait Stats: Calls Outside SQL Server
PREEMPTIVE wait stats record the time a task spends in code outside SQL Server, such as a call into Windows. On Night 19 at the Clipboard Diner, Kit picks up the wall phone to town hall and steps off the kitchen’s schedule. Then two queries find the preemptive waits that matter on your server.
LOGBUFFER Wait Stats: When the Log Buffer Fills
LOGBUFFER wait stats mean a task is waiting for free space in the log buffer before it can write a log record. On Night 18 at the Clipboard Diner, Pat’s notepad fills up faster than Pat can copy it into the order book. Then two queries show whether your log can keep up, and the fixes in order.
EXISTS: A Row Containing NULL Still Exists
EXISTS answers whether qualifying rows exist. Keep missing values separate from missing rows and preserve the intended correlation.
WRITELOG Wait Stats: Transaction Log Flush Waits
WRITELOG wait stats measure the time a commit waits for its log records to reach the disk. On Night 17 at the Clipboard Diner, Pat’s pen slows down and plates pile up at the pass. Then two queries show your log write latency, and a short script shows why many tiny commits hurt.
THREADPOOL Wait Stats: When Worker Threads Run Out
THREADPOOL wait stats mean a task is waiting for a worker thread because every worker is already busy. On Night 16 at the Clipboard Diner, every cook holds a ticket that can’t move, and nobody is free to take a new order. Then two queries show how close your server is to its worker limit, and how to get in when nobody else can.
LCK_M Wait Stats: Lock Waits and Blocking
LCK_M wait stats show how long queries wait for a lock that another session holds. On Night 15 at the Clipboard Diner, a party in booth 7 pays and then won’t leave, and three parties wait behind it. Then two queries find the blocking chain and its head blocker on your own server.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.