We’ll explain how to get your 3 most important server metrics, demo a SQL Server under heavy load, and explain why monitoring software doesn’t really help the way you think it does. (Don’t get us wrong – we still love monitoring software – it’s just…)
02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)
We’ll explain how to get your 3 most important server metrics, demo a SQL Server under heavy load, and explain why monitoring software doesn’t really help the way you think it does. (Don’t get us wrong – we still love monitoring software – it’s just…)
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)
- 03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes)
- Wait Types – ASYNC_NETWORK_IO (7 minutes)
- Wait Types – CXPACKET (54 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)