SQL Server knobs and switches
Over the last month or so, I’ve been working on some SQL Server optimizations to address performance. If you are in the same boat check out Jimmy May’s blog for lots of great information on making SQL Server perform as well as possible. Also don’t forgot to start at the SQL Server Storage Engine Blog and of course MSDN & TechNet.
One thing I would like to highlight is the importance of I/O on SQL Server performance. If I had a nickel for every time SQL Server was running on poorly performing disk subsystems…fast disks=happy users.