Brent Ozar - SQL Server DBA Rotating Header Image

Posts Tagged ‘performancetuning’

How To Write a SQL Server Performance Review

Sometimes I think the difference between consultants and employees boils down to one thing: documentation.
Us DBAs know exactly what we think is wrong with an application, and we’ll tell anybody who’ll listen, but what does management do?  They hire some expensive consultants to come in, ask a lot of questions, and tell us what we [...]

SQL Performance Tuning: Estimating Percentage Improvements

When I’m doing performance tuning on an application in the early stages of its lifecycle (or any app that’s never had DBA attention before), I end up with a ton of recommendations within the first day of performance tuning.  The resulting to-do list can seem overwhelming to project managers and developers, so I include one [...]