How fast is your SQL Server going, how hard is it working, and how large is it? Learn the 3 Perfmon counters that tell you what’s going on inside the SQL Server. You’ll want to memorize these numbers for your busiest SQL Servers so you can know when they’re outside of normal range, and also…
01. How to Measure and Change Your SQL Server – 3 Metrics to Gather (23 minutes)
How fast is your SQL Server going, how hard is it working, and how large is it? Learn the 3 Perfmon counters that tell you what’s going on inside the SQL Server. You’ll want to memorize these numbers for your busiest SQL Servers so you can know when they’re outside of normal range, and also...
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.
- 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 – 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)