ICYMI - Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

Kevin Kline

Published On: July 7, 2015

Categories: Performance, SQL Server 0

A digest of great performance tuning 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 at: https://sentryone.com/community


Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare | Google Author

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.