SQL Server System Configuration
You can configure the machine that SQL Server runs on, as well as the Database Engine itself, in several ways and through a variety of interfaces. We’ll first look at some operating system–level settings that can affect the behavior of SQL Server. Next, we’ll see some SQL Server options that can affect behavior that aren’t especially considered to be configuration options. Finally, we’ll examine the configuration options for controlling the behavior of SQL Server 2008, which are set primarily using a stored procedure interface called sp_configure.
Operating System Configuration
For your SQL Server to run well, it must be running on a tuned operating system, on a machine that has been properly configured to run SQL ...
Get Microsoft® SQL Server® 2008 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
