Waits Archives - SQLPerformance.com

Knee-Jerk Wait Statistics : PAGELATCH

Posted by Paul Randal on October 19, 2015 4 Responses »

Oct 192015

Paul Randal (@PaulRandal) adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.

Proactive SQL Server Health Checks, Part 5 : Wait Statistics

Posted by Erin Stellato on October 1, 2015 1 Response »

Oct 012015

Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.

More on CXPACKET Waits: Skewed Parallelism

Posted by Paul Randal on August 26, 2015 2 Responses »

Aug 262015

Paul Randal (@PaulRandal) explains how to tell when CXPACKET waits are actually a problem (because, usually, they are just an indication of parallelism).

Knee-Jerk Wait Statistics : CXPACKET

Posted by Paul Randal on June 23, 2015 8 Responses »

Jun 232015

With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.

Monitoring Read/Write Latency

Posted by Tim Radney on March 5, 2015 No Responses »

Mar 052015

Tim Radney (@tradney) of SQLskills.com shows us how we can be proactive in monitoring our I/O subsystems for read/write latency that can affect SQL Server performance.

Knee-Jerk Wait Statistics : PAGEIOLATCH_SH

Posted by Paul Randal on June 25, 2014 7 Responses »

Jun 252014

Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskills adds another chapter, this time focusing on PAGEIOLATCH_SH.