webcast signup header

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.

Webcast Date

Wednesday, January 29, 2020
1:00:00 PM EST | 6:00:00 PM UTC

Speaker(s)

presenter 1
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.

Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
Clustering SQL Server - What you need to know before getting started
Thursday, January 23, 2020 - 1:00:00 PM EST
Speaker(s): Dave Bermingham - Sponsor: SIOS

 
Database Performance Tuning for Virtualized Database Instances
Tuesday, February 11, 2020 - 11:00:00 AM EST
Speaker(s): John Maxwell - Sponsor: SolarWinds

Signup for our newsletter

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.


 

 


Copyright (c) 2006-2020 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.