I’m excited to announce that Erik and I are presenting the opening session at this year’s free online 24 Hours of PASS webcasts! Here’s our session:
Performance Tuning Techniques
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.
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.
Come for the bad fashion.
Stay for the SQL training.
We have a dangerous combination: a box full of old family photos, and no sense of shame.
You’ll see bad hairdos, fashion choices, and SQL Server tuning techniques. You’ll probably recognize some of your own bad decisions in there.
We won’t be able to bring your skills entirely up to date within an hour, but at least we’ll be able to show you why we’re teaching a Summit pre-con, Expert Performance Tuning for SQL Server 2016 & 2017. We see so many DBAs with years of experience, but they haven’t bothered to update their skills – or their wardrobe. Let’s get you fixed up.