ICYMI - Troubleshooting SQL Performance Issues, Missing Indexes, and DROP and TRUNCATE TABLE

Kevin Kline

Published On: June 30, 2015

Categories: Performance, SQL Server 0


Troubleshooting SQL Server CPU Performance Issues

This outstanding article from Joe Sack ( b | t ) of SQLskills.com steps you through a methodical and insightful series of DMVs and queries that can pinpoint CPU issues on your SQL Server instances.

Don’t just blindly create those "missing" indexes!
Our own Aaron Bertrand ( b | t ) discusses ways to get better and more balanced information used in decisions about creating new indexes than offered as suggestions by native SQL Server tools.

The Myth that DROP and TRUNCATE TABLE are Non-Logged
Paul Randal ( b | t ) of SQLskills.com refutes the age-old myth that TRUNCATE TABLE and DROP are not logged operations. I love the full T-SQL reproduction of the issue so that you can see the internals in action.Troubleshooting SQL Server CPU Performance Issues

Read more SQL Sentry happenings in our monthly eNews at: https://sentryone.com/community

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.