Brent Ozar

Brent Ozar

Brent Ozar loves to make SQL Server faster and more reliable.  He created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the Microsoft MVP award.

Identifying and Fixing Parameter Sniffing

Auditorium

You swear nothing changed – but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the problem goes away – but what really happened, and how do you fix it faster and more permanently?

400 Dev EN
READ MORE

Blocking: How to Find and Fight LCK* Waits

Auditorium

When you’re facing lock waits and blocked queries, it’s tempting to just slather NOLOCK all over the queries. Thing is, this won’t necessarily fix it, and there are much better ways to track, diagnose, and cure blocking issues. You’ll learn them here.

200 Admin EN
READ MORE

Watch Brent Tune Queries

Auditorium

Ever wonder how somebody else does it? Watch over the virtual shoulder of Microsoft Certified Master Brent Ozar as he walks you through the Stack Overflow public database export, shows you two queries, and then tunes them to make them dramatically faster. Along the way, you’ll see several free tools in action that help make […]

200 Dev EN
READ MORE

Performance Tuning When You Can’t Fix the Queries

Room A

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there’s still hope. Brent Ozar does this every week, and he’ll share his proven methodologies to performance […]

EN Workshop
READ MORE