System Configuration
You can configure the SQL Server engine in several ways and through a variety of interfaces. One approach involves using a system-stored procedure called sp_configure and supplying a value for a particular configuration option. Some configuration options can be set at the operating system level, and most of these can be controlled using the Surface Area Configuration Tool (discussed in Chapter 1). In addition, some server behaviors can be controlled using operating system control interfaces; others, such as trace flags, can be set as startup parameters of the SQL Server engine executable, Sqlservr.exe.
Next we’ll look at most of the configuration options for controlling the behavior of SQL Server 2005.
Task Management
As you ...
Get Inside Microsoft® SQL Server™ 2005, Fourth Edition 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.
