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 […]
COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality […]
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.
Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
Aaron Bertrand (@AaronBertrand) continues his "bad habits" series; in this installment, he discusses ten common cases of misplaced optimization.
After joining our team, one of the first things Kevin Kline asked of me was to list the top 5 technical issues we see while providing customer service for SQL Sentry. I thought that filling Kevin's request for a "Top 5" would make for an interesting blog post…