Database Training Days 101: SQL Server Performance Tuning Hints & Tricks with Andy Warren

Do you need to fix slow queries, blocking, or deadlocks? Are you dealing with a slow server? When you don’t have a lot of experience in Microsoft SQL Server query tuning, it can be extremely frustrating. There’s so much to consider: locking, disk IO, statistics, caching, query plans, indexes, and more. But you don't have to know everything to make a query go faster! In this on-demand query tuning webcast, you’ll learn a set of steps to detect and fix the most common Microsoft SQL Server performance issues. We'll discuss how to figure out where to start, what is worth more effort and what isn't, common patterns and anti-patterns, and what to measure. You’ll also learn a few advanced strategies that go beyond pure query tuning, such as offloading queries to a replica and encouraging developers to cache more. With these expert tips, you’ll simplify your work—and take SQL Server performance to the next level.

Topics that will be discussed include:

• Step-by-step process for detecting and fixing common SQL Server performance issues
• Identifying and addressing locking, disk IO, and query plan problems
• Deciding which issues are worth your time and which aren't
• Exploring advanced strategies, including offloading queries and caching
• Practical examples of common patterns and anti-patterns in query tuning

Speaker:

• Andy Warren, SQL Server Consultant and MVP at SQLServerCentral.com