SQL Server Performance Tuning Hints and Tricks
Quest sponsored on-demand webinar
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.