ICYMI – Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

Some of my favorite articles originally appearing at SQLPerformance.com.

Avoiding Knee-Jerk Performance Tuning
Paul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue.

Knee-Jerk Wait Statistics: SOS_SCHEDULER_YIELD
Paul Randal continues his series on knee-jerk performance troubleshooting. In this post, he talks about SOS_SCHEDULER_YIELD, and how to determine whether it is a wait to worry about in your scenario.

SQL Server 2014 Incremental Statistics
Benjamin Nevarez ( b | t ) takes a close look at the new incremental statistics feature in SQL Server 2014.

Read more SQL Sentry happenings in our monthly eNews.


Speak Your Mind


This site uses Akismet to reduce spam. Learn how your comment data is processed.