SQL Server Performance Tuning Hints and Tricks

Quest sponsored on-demand webinar

Download slides and scripts!

Webcast Abstract

Need to fix slow queries, blocking, or deadlocks? Or a slow server? If you don't have a lot of experience tuning it can be a very frustrating experience because there is so much to consider; locking, disk IO, statistics, caching, query plans, indexes, and more. Yet you don't have to know everything to make a query go faster!

The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common performance issues you'll encounter.

We'll discuss figuring out where to start, deciding what is worth more effort and what isn't, some common patterns and anti-patterns, what to measure, and a few advanced strategies that go beyond pure tuning such as offloading queries to a replica and getting the developers to cache more.

Speaker - Andy Warren

Learn more about SQL Server tools