Performance optimization on SQL Server can be challenging. A vast array of information is available on how to address performance problems in general. However, there is not much detailed information on specific issues and even less information on how to apply that specific knowledge to your own environment.

This paper offers 10 tips for optimizing SQL Server performance, with SQL Server 2008 and 2012 in mind. There are no definitive lists of the most important tips, but you won’t go wrong by starting here.

As a DBA, you undoubtedly have your own perspective and will your own favorite optimization tips, tricks and scripts. Why not join the discussion on SQLServerPedia?