Configuring SQL Server for Optimization - Microsoft SQL Server 2012 Performance Tuning - page 393

17

Configuring
SQL Server for
Optimization

In this chapter we will cover:

F Configuring SQL Server to use more processing power
F Configuring memory in 32 bit versus 64 bit
F Configuring "Optimize for Ad hoc Workloads"
F Optimizing SQL Server instance configuration

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.