Tag Archives: Configuration Settings

Some Suggested SQL Server 2008 R2 Instance Configuration Settings

Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level settings that you should consider changing from their default values. These include Max Server Memory, optimize for ad-hoc workloads,  default … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 28 Comments