SQL Server Performance Tuning Hints and Tricks

Quest sponsored on-demand webinar

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

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

get free sql tips
agree to terms