Truth, Art, and the Zen of SQL Server Performance Tuning
SQL ServerTruth, Art, and the Zen of SQL Server Performance TuningTruth, Art, and the Zen of SQL Server Performance Tuning
Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance. Whether you’re a DBA/IT focused person or a developer, to properly provide your end users with the performance the business requires, you must ensure that not only do you pay attention to the application and things like queries and indexes, but also things like hardware, the OS, and basic configuration.
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.