Brent Ozar

Brent Ozar

Brent Ozar uwielbia sprawiać, alby SQL Server działał szybko i niezawodnie.  Stworzył sp_Blitz® i sp_AskBrent® i bardzo lubi dzielić się wiedzą na swoim blogu BrentOzar.com. Posiada sporo certyfikatów i nagród włączając Microsoft MVP.

Identifying and Fixing Parameter Sniffing

Audytorium

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
WIĘCEJ

Blocking: How to Find and Fight LCK* Waits

Audytorium

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
WIĘCEJ

Watch Brent Tune Queries

Audytorium

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
WIĘCEJ

Performance Tuning When You Can’t Fix the Queries

Sala 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
WIĘCEJ