SentryOne Team Blog (blogs.sentryone.com)

Category: Performance

Tim Radney : Getting Started Tuning Performance in Azure SQL Database

Tim Radney (@tradney) of SQLskills talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.

Delayed Durability while Purging Data

Melissa Connors (@MelikaNoKaOi) investigates using SQL Server's delayed durability feature to improve performance while purging data.

Tim Radney : Tuning : A Good Place to Start

Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.

Q&A from Webinar "How to Reduce Latency and Boost I/O Performance on SQL Server"

Kevin Kline (@kekline) answers several questions from his recent webinar on I/O latency with Tegile's Sumeet Bansal.

Troubleshooting SQL Server Part 4: Correlating Wait Statistics Against Other Metrics

Kevin Kline (@kekline) continues his series on troubleshooting SQL Server; in this post, he shows how to correlate wait stats to other system metrics.

Partitioning on a Budget

Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some partitioning benefits without the Enterprise Edition price tag.

Learning all about the SQL Server Plan Cache

The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.

DBTA – StretchDB, a Cool New Feature in vNext SQL Server

Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of

ICYMI – Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

A digest of great performance tuning articles originally appearing at SQLPerformance.com. Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied

Applying Data Compression to the SQL Sentry Database : Part 5 (Follow-up)

Melissa Connors (@MelikaNoKaOi) follows up on her data compression series, providing details on wait statistics, MAXDOP settings, and Performance Advisor.

ICYMI – Recommended Intel Processors For SQL '14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

A digest of great performance tuning articles originally appearing at SQLPerformance.com. Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways to perform grouped concatenation in SQL Server. Then he follows up with a

ICYMI – Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

A digest of great performance tuning articles originally appearing at SQLPerformance.com. Dirty Secrets of the CASE Expression Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and a curling fanatic? Improbable, I know. An

DBTA – Delayed Durability—The SQL Server 2014 Transaction Log Hack!

Originally appearing in my monthly column at Database Trends & Applications magazine. Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging. Why turn off the transaction log? It is the main guarantor of transactional consistency

ICYMI – Read Committed Snapshot Isolation, How Automatic Updates to Statistics Can Affect Query Performance, #temp table

A digest of great performance tuning articles originally appearing at SQLPerformance.com. Read Committed Snapshot Isolation Paul White ( b | t ) has been doing a phenomenal series on SQL Server behavior under each of the major isolation levels. This particular post details the inner workings of READ COMMITTED SNAPSHOT, but there are more articles on this specific isolation level

ICYMI – Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

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