Time and tide wait for no man’, but SQL Server must wait for resources when executing a query. The lifecycle of a query is full of waiting, and SQL Server records when it’s waiting, why, and for how long. By learning how each query is executed, and observing how waits can accumulate along the way, you can unlock the secrets to what resources or code changes are needed to improve your query and server performance.
Jes Schultz Borland is a senior SQL engineer at Concurrency and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturday, and other community events.