For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL Server Performance Tuning Hints & Tricks

On Demand
  • Recorded Date:Jan. 29, 2020
  • Event:On Demand
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, this can be extremely frustrating. There’s so much you have 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 figuring out where to start, deciding what is worth more effort and what isn't, some 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 getting the developers to cache more. With these expert tips, you’ll simplify your work – and take SQL Server performance to the next level. 

Speakers

Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy and is occasionally on Twitter as @SQLAndy.