Categories
DBA

SQL Server Configuration Settings

Introduction:
This article brings you the allowable configuration options in SQL Server which includes options that are new to SQL Server 2008 also. The options can be used to tune, optimize and maximize the performance of the system in variety of ways. But careful planning and examination should be done before you implement the change. By default Microsoft has optimized it with default values. Some of those options does not require a service restart and some does. Those are called advanced options which you will come to know as we discuss.