Some Suggested SQL Server 2008 R2 Instance Configuration Settings

5 views
Skip to first unread message

Henrry Pires

unread,
Mar 26, 2014, 5:02:03 PM3/26/14
to NetPonto News
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 backup compression, max degree of parallelism, and the number of TempDB data files for the SQL Server instance.
...
http://www.sqlservercentral.com/blogs/glennberry/2011/02/25/some-suggested-sql-server-2008-r2-instance-configuration-settings/
Reply all
Reply to author
Forward
0 new messages