SQL Server 2008 Configuration

In the second part of this chapter, we’ll look at the options for controlling how SQL Server 2008 behaves. One main method of controlling the behavior of the Database Engine is to adjust configuration option settings, but you can configure behavior in a few other ways as well. We’ll first look at using SQL Server Configuration Manager to control network protocols and SQL Server–related services. We’ll then look at other machine settings that can affect the behavior of SQL Server. Finally, we’ll examine some specific configuration options for controlling server-wide settings in SQL Server.

Using SQL Server Configuration Manager

Configuration Manager is a tool for managing the services associated with SQL Server, configuring ...

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.