Introduction

SQL Server provides one system stored procedure, named SP_Configure, which helps you to manage the SQL Server instance-level configuration. A configuration comes with a default value, but based on the server, load on the server, and your own usage, you can change its default value to something else that can give you benefits from the performance point of view. Apart from the settings given in the SP_Configure stored procedure, the type of instance (32 bit/64 bit) also affects a bit.

It has been often observed that people use a SQL Server machine along with IIS, as a file server, or as a domain controller. Performance will be affected if you are using the same server for SQL Server Services along with other services, such as, IIS, domain controller, and so on.