24 Hours of PASS: Summit 2017 Preview

Last Season's Performance Tuning Techniques

Speakers: 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 Material

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.

Brent Ozar
Microsoft Certified Master of SQL Server, Brent Ozar Unlimited

Erik Darling
Consultant, Brent Ozar Unlimited

Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's been a developer at a market research company and a DBA for an eDiscovery shop. He enjoys arguing with... View More

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids