"My only choice for SQL Server Performance Analysis"

Source: TrustRadius. The number one B2B software review site.

Get SentryOne eBooks

High Performance Techniques for SQL Server

In these books, you will find useful, hand-picked articles that will help give insight into some of your most vexing performance problems. These articles were written by several of the SQL Server industry's leading experts, including Aaron Bertrand, Paul White, Paul Randal, Jonathan Kehayias, Erin Stellato, Glenn Berry, and Joe Sack.

High Performance Techniques for Microsoft SQL Server Thumbnail Book 11

Volume One | August 2013

Volume One contains information about database design, T-SQL, execution plans, performance monitoring, and troubleshooting as well as system architecture and maintenance. Learn about the benefits of indexing foreign keys, the best approach for running totals, ten common threats to execution plan quality, and more.

Download PDF
High Performance Techniques for Microsoft SQL Server Thumbnail Book 2

Volume Two | August 2013

In Volume Two, learn about administration and system configuration, ACID and isolation levels, statistics and cardinality, as well as measuring and performance tuning, SQL Server 2014. From making the case for regular SQL Server servicing to interesting things about INSTEAD OF triggers, this eBook is packed with useful information.

Download PDF
High Performance Techniques for Microsoft SQL Server Thumbnail Book 3

Volume Three | February 2015

Volume Three includes valuable information about indexes and query optimization, high availability and disaster recovery, and performance tuning and troubleshooting. Learn more about performance tuning the whole query plan, readable secondaries on a budget, and much more.

Download PDF
High Performance Techniques for Microsoft SQL Server Thumbnail Book 4

Volume Four | July 2015

In Volume Four of our eBook, topics covered include database design and structure, query tuning and troubleshooting, and Azure and virtualization. Read about comparing Windows Azure virtual machine performance and risk when using dynamic memory within Hyper-V, as well as many other interesting topics.

Download PDF
High Performance Techniques for Microsoft SQL Server Thumbnail Book 5

Volume Five | February 2016

Volume Five offers even more insightful tips with chapters on statistics and table structure, SQL Server 2016, system configuration, and monitoring. Learn more about monitoring for suspect pages, using Microsoft DiskSpd to test your storage subsystem, and hash joins on nullable columns, just to name a few.

Download PDF

Volumes 1-5

Download all of the volumes of High Performance Techniques for SQL Server in one archive.

Download .zip archive