24 Hours of PASS: Last Season’s Performance Tuning Techniques

Brent, last season (and I have so many good bad photos to share)

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:

Last Season’s
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.

Erik, last season (his parents made him cover up the tattoos during the holidays)

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.

Register for the free 24 Hours of PASS, then talk to your boss about getting to the Summit. Let’s get you dressed for 2017.

Previous Post
Builder Day: Cloudbuilding Episode 1 – The Road to HANA
Next Post
Trainable SQL Servers

6 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.