Lock Pages

SQL Server 2008 R2 Post Configuration Changes/Optimization

In this post I will be looking at some useful tools and configuration changes that can be implemented to ensure that you get the best out of SQL: – Run the Microsoft SQL Server 2008 R2 Best Practices Analyzer (Click Here) – Split SQL TempDB per number of Processor Core (Click Here) – Lock Pages in Memory – Set SQL max memory limit – Enable paging file – Prevent Cluster Failover if SQL Server Agent resource fails