SentryOne Team Blog (blogs.sentryone.com)

Category : Performance

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

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

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 […]

Glenn Berry : SQL Server Data Platform Upgrade in 2015

Glenn Berry (@GlennAlanBerry) of SQLskills.com encourages us to start looking at benefits we'll see from upcoming changes to Intel processors, Windows 10, and SQL Server vNext.

Aaron Bertrand : Bad habits : Focusing only on disk space when choosing keys

Aaron Bertrand (@AaronBertrand) examines various impacts on SQL Server – not just disk space – when choosing a GUID as a clustering key.

Glenn Berry : Sequential Throughput Speeds and Feeds

Glenn Berry (@GlennAlanBerry) of SQLskills.com runs down why sequential I/O throughput is critical for many SQL Server tasks, and explains how to avoid artificial bottlenecks by choosing hardware components wisely.

Paul Randal : Knee-Jerk PerfMon Counters : Page Life Expectancy

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.

Bad habits : Putting NOLOCK everywhere

Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.

Aaron Bertrand : Stop making SQL Server do your dirty work

Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.

Glenn Berry : Using Geekbench 3.2 To Test Large Database Servers

Glenn Berry (@GlennAlanBerry) of SQLskills walks us through using Geekbench 3.2 from Primate Labs to test and compare CPU and memory performance on Windows database servers.

Bad habits : Looking for optimizations in all the wrong places

Aaron Bertrand (@AaronBertrand) continues his "bad habits" series; in this installment, he discusses ten common cases of misplaced optimization.

Glenn Berry : Database Server Hardware Trends

Glenn Berry (@GlennAlanBerry) of SQLskills continues on database server hardware trends; today he previews some new processors that may save you some money on SQL Server 2014.

Paul White : The SNAPSHOT Isolation Level

Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with SNAPSHOT.

My Perspective: The Top 5 Most Common SQL Server Performance Problems

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…