Last Season's Performance Tuning Techniques

Speaker(s)Brent Ozar, Erik Darling

Duration: 60 minutes

Track: Perform

You're kinda-sorta comfortable doing performance tuning on SQL Server. You've read a few blogs, you monitor Page Life Expectancy, you rebuild your indexes, and you add an index here or there. However, you haven't been to a day-long performance tuning class yet, and you're wondering what you're missing.Thing is, in SQL Server, performance tuning changes fast. One day Perfmon counters are in, and the next day they're out. It's totally okay if you're still using SQL Server 2008 - that's not the problem. You shouldn't be wearing hammer pants, and you shouldn't be looking at PLE, monitoring Disk Queue Length, or putting your data and log files on separate drives.In this rapid-fire session, we'll show you specific examples of why performance tuning tips and tricks have fallen out of fashion, and why they're not too legit to quit.

Accompanying Materials:

No material found.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.