Paul Randal (@PaulRandal) adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.
Continue Reading »Oct 192015
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).
Continue Reading »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.
Continue Reading »Apr 202015
Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.
Continue Reading »Mar 182015
Paul Randal (@PaulRandal) of SQLskills describes several ways clustered index fragmentation can sneak up on us, and how it can impact your workload.
Continue Reading »Nov 262014
Continuing his knee-jerk series, this time Paul Randal (@PaulRandal) of SQLskills talks about SSDs, and some of the false impressions people get about them.
Continue Reading »Oct 202014
Paul Randal (@PaulRandal talks about Page Life Expectancy – what it is, why fixed thresholds are meaningless, when it matters, and what you can do about it – in this latest installment of his "knee-jerk troubleshooting" series.
Continue Reading »