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.
Rarely Run Queries in SQL Server: What the First Run Pays
Rarely run queries start with a plan that has left the cache. This test compiles a five table report procedure and measures the compile CPU on the first run, the second run, and a run after the cache was cleared. It also shows how to check whether a plan is still cached.
Performance Statistic Collection: Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains performance statistic collection and how DBAs should gather server data.
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.