SQL Server Performance Tuning Hints and Tricks
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.
Wednesday, January 29, 2020
1:00:00 PM EST | 6:00:00 PM UTC
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
, and is occasionally on Twitter as @SQLAndy.
Register for this webinar:
Copyright (c) 2006-2020 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.