Beyond CXPACKET: Understanding Wait Statistics
'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.
About Jes:Jes Borland is a Senior SQL Engineer at Concurrency and a Microsoft Data Platform MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is a user group founder, a blogger, and a frequent speaker. In her free time, she runs, cycles, and cooks.