Oh, and turn boost priority OFF. It's a setting that should almost never be enabled
Will do Gail, would you mind explaining this?
Not being argumentative just wanting/trying to understand
priority boost Option
Use the priority boost option to specify whether Microsoft SQL Server should run at a higher Microsoft Windows 2000 or Windows 2003 scheduling priority than other processes on the same computer. If you set this option to 1, SQL Server runs at a priority base of 13 in the Windows 2000 or Windows Server 2003 scheduler. The default is 0, which is a priority base of 7.
Raising the priority too high may drain resources from essential operating system and network functions, resulting in problems shutting down SQL Server or using other operating system tasks on the server.
The setting has no benefit on a dedicated SQL Server machine as there's nothing else to compete for CPU time other than the OS and you don't want SQL taking priority over the OS.
Four dangerous settings that should not be messed with: http://www.brentozar.com/archive/2012/12/dont-touch-that-button-four-dangerous-settings-in-sql-server-video/
From Glenn Berry (http://sqlserverperformance.wordpress.com/2010/05/11/five-things-sql-server-should-drop/
The “Boost SQL Server Priority” Instance Setting. This setting is like a shiny piece of candy that seems to attract many people. After all, who would not want to boost the priority of SQL Server and hopefully get better performance. Just like the Turbo button on ancient personal computers, right? It turns out that this setting does not help performance, and can actually destabilize the operating system, since the OS can be starved of CPU resources because of the priority given to the SQL Server process.
And, if that's not enough, a kb article (http://support.microsoft.com/kb/319942
Based on actual support experience, you do not need to use priority boost for good performance. If you do use priority boost, it can interfere with smooth server functioning under some conditions and you should not use it except under very unusual circumstances. For example, Microsoft Product Support Services might use priority boost when they investigate a performance issue.
IMPORTANT Do not use priority boost for clustered servers that are running SQL Server 7.0 and later.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass