I show you a query that produces CXPACKET waits, measure it with sp_BlitzFirst (formerly sp_AskBrent), and explain what the cryptic letters in CXPACKET stand for. Then we talk about how to fix it long term, and why you can’t make it go away with settings alone. Demo Code If you want to follow along with…
Wait Types – CXPACKET (54 minutes)
I show you a query that produces CXPACKET waits, measure it with sp_BlitzFirst (formerly sp_AskBrent), and explain what the cryptic letters in CXPACKET stand for. Then we talk about how to fix it long term, and why you can’t make it go away with settings alone. Demo Code If you want to follow along with...
To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
- 01. How to Measure and Change Your SQL Server – 3 Metrics to Gather (23 minutes)
- 02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)
- 03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes)
- Wait Types – ASYNC_NETWORK_IO (7 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 1 (39 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 2 (29 minutes)
- Wait Types – PAGEIOLATCH Part 1 – Slow Reads from Storage (7 minutes)
- Wait Types – PAGEIOLATCH Part 2 – Ways to Mitigate It (9 minutes)
- Wait Types – RESOURCE_SEMAPHORE (33m)
- Wait Types – SOS_SCHEDULER_YIELD (44m)
- Wait Types – THREADPOOL (27m)
- Wait Types – WRITELOG (12m)