I presented four sessions at the Great Indian Developers Summit 2014 in Bangalore, and the rooms were standing room only. This post has my photographs from the event and the abstract of each session.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.
Learning SQL Wait Stats: The Complete Series Guide
Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.
Exponential Backoff: How SQL Server Estimates Several Filters
The plan guessed 89 rows and 500 came back. Here is the rule behind that guess, and what to do about it.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
Query Store Capture Modes: ALL, AUTO and CUSTOM
Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.
Investigating a Past Slowdown With the system_health Session
Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.