Why Defragmenting Your Indexes Isn't Helping, presented by Brent Ozar

This is a past event

19 people went

Location image of event venue

Details

For years, you've heard that you're supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense - keep things in order, right? But you keep doing it, and SQL Server isn't getting any faster. You've even heard that setting fill factor will help prevent fragmentation, and you're doing that too - but your indexes still keep getting fragmented every day, and users aren't happy with performance. This advice made a lot of sense at the turn of the century, but today, things are different - and we're not just talking solid state drives. In just the first 15 minutes, you'll have a series of ah-ha moments when you realize that your daily index maintenance jobs might just be making the problem worse instead of better. Then, you'll learn what you need to do instead. This session is for people responsible for the care and feeding of production SQL Servers. You don't have to have the word "DBA" in your job title - you just have to be the one responsible. This session is for people responsible for the care and feeding of production SQL Servers. You don't have to have the word "DBA" in your job title - you just have to be the one responsible.

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master.

Be sure to let your friends and colleagues know about this one. It's going to be a great one! And as a reminder, anyone who brings a first timer (and they join the meetup), you'll be entered into a drawing for a $25 Visa gift card.

We'll see you in a couple of weeks!