Back To Schedule
Tuesday, May 21 • 11:30 - 12:30
SQL Server Tuning: Is It a Server Problem or a Code Problem?

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Your users are complaining that your SQL Server is slow - but is it a database problem, or not enough hardware? It's confusing because the developers always blame the sysadmins, and the sysadmins always blame the developers.

In one hour, you'll learn:

* The 3 metrics to monitor on every SQL Server: Batch Req/Sec, Data Size, and Wait Time Ratio
* Common hardware sizes for different ranges of metrics
* Whether more hardware can pay off for certain kinds of metrics
* Easy-to-read signs that there really is a code problem that hardware won't fix

The session will be relevant for SQL Server in virtualization, bare metal, cloud VMs, and even Azure SQL DB.

avatar for Brent Ozar

Brent Ozar

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master.

Tuesday May 21, 2019 11:30 - 12:30 CEST
Room 9