Optimized locking wait stats are the new lock waits SQL Server 2025 records when optimized locking is on. On Night 24 at the Clipboard Diner, a new state code swaps booth cards for wristbands. Then I show what LCK_M_S_XACT_MODIFY and LCK_M_S_XACT_READ mean, how to check the setting, and why a long transaction still hurts.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
OLEDB Wait Stats: Linked Servers and Remote Calls
OLEDB wait stats measure the time SQL Server spends in calls to an OLE DB provider, and that usually means a linked server. On Night 23 at the Clipboard Diner, the pie case is empty and Jules crosses the street for every slice. Learn how to find the waiting session, how OPENQUERY filters on the remote side, and when to keep a local copy instead.
HADR_SYNC_COMMIT Wait Stats: Availability Group Commits
HADR_SYNC_COMMIT wait stats measure how long a commit waits for a synchronous secondary replica to harden the log. On Night 22 at the Clipboard Diner, every sale is phoned to a sister diner before the plate can leave. Learn what the wait includes, how to read the send and redo queues, and the fixes from the secondary’s log disk to asynchronous commit.
ASYNC_NETWORK_IO Wait Stats: When the Application Is Slow
ASYNC_NETWORK_IO wait stats mean SQL Server has results ready and is waiting for the application to read them. On Night 21 at the Clipboard Diner, hot plates pile up at the pass while Quinn tells a long story at table 4. Learn the causes in the order I find them, two queries that name the slow program, and why the fixes live in the application.
MSQL_XP Wait Stats: Extended Procedures and External Code
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.
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.
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.