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.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
