Tag : waits - SentryOne Team Blog

Tag: waits

SQLskills Wait Types Library now shows SentryOne data

SQLskills Wait Types Library now shows SentryOne data

Paul Randal (@PaulRandal) explains how the SQLskills Wait Types Library uses anonymous data from SentryOne to indicate whether a wait type is commonly experienced.

Paul Randal : Knee-Jerk Wait Statistics : PAGELATCH

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

Paul Randal : Knee-Jerk Wait Statistics : CXPACKET

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.

High LCK_M_SCH_M waits

Aaron Bertrand (@AaronBertrand) describes a scenario where Common Criteria compliance was deemed the cause of high LCK_M_SCH_M waits for multiple customers.