What to Do When SQL Server is Unusually Slow

Target Audience:

You use Activity Monitor to figure out what’s going on, and you feel like you might be missing something.

Abstract:

“Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it responds, but you can tell it’s a little slow. You open up Activity Monitor, look at recent expensive queries, and maybe open up the Windows event logs to see if anything’s happened recently.

There’s gotta be a better way, right?

Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.

Why I Want to Present This Session:

I want to bring more disciplined troubleshooting processes to our industry.

Additional Resources:

The following two tabs change content below.

Brent Ozar

Managing Director at Brent Ozar Unlimited
I make Microsoft SQL Server faster and more reliable. I'm the guy behind BrentOzar.com, Ozar.me, DBAreactions.com, SQLServerUpdates.com, and GroupBy.org.
Previous Post
Getting Better Query Plans by Improving SQL’s Estimates
Next Post
Upgrading your database to vNext

11 Comments. Leave new

I would go to this session.

Reply

I’d love to see this session come up. Make it so!

Also, I’m pretty sure, knowing your sense of humour, your ‘Target Audience’ line is deliberately cut off, but in case it’s not….it’s cut off.

Reply
Ray Herring
March 6, 2018 2:21 pm

I would attend this session.

Reply

This would be a great session to attend. I already use sp_WhoIsActive and it helps out tremendously, I would like to learn to use the others.

Reply
Rick Kohler
March 6, 2018 4:01 pm

Real interesting abstract, I can’t imagine anyone passing this up.

Reply

I would attend this session.

Reply
Scott Buchholz
March 7, 2018 10:55 am

I could smell a Brent session before I opened it up. I hope to attend.

Reply

Would love

Reply

Will you blame the SAN Admin, too? I’m pretty sure that’s a critical step when the server is slow.

Reply

Would love to watch this session!

Reply

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.

Menu