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.

  • cover of eBook 'High Performance Techniques for Microsoft SQL Server, vol. 1'
    High Performance Techniques for SQL Server 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
  • cover of eBook 'High Performance Techniques for Microsoft SQL Server, vol. 2'
    High Performance Techniques for SQL Server 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
  • cover of eBook 'High Performance Techniques for Microsoft SQL Server, vol. 3'
    High Performance Techniques for SQL Server 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
  • cover of eBook 'High Performance Techniques for Microsoft SQL Server, vol. 4'
    High Performance Techniques for SQL Server 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
  • cover of eBook 'High Performance Techniques for Microsoft SQL Server, vol. 5'
    High Performance Techniques for SQL Server 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
  • High Performance Techniques for SQL Server Volumes 1-5

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

    Download .zip archive

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again