7.3. Server configuration
The name of this section, Server configuration, refers to a range of additional SQL Server settings that can be tuned for particular behavior. While the list is by no means exhaustive, it covers some common settings that are often changed to alter server operation.
As with CPU and memory settings, the settings we'll cover in this section can be adjusted with either sp_configure or by using SQL Server Management Studio.
7.3.1. Recovery Interval
A page is the fundamental storage unit in SQL Server, with each database divided into multiple 8K pages. When a database page is required, SQL Server reads the page from disk into memory (if it's not already there) and stores it in the data cache. Pages are modified as required ...
Get SQL Server 2008 Administration in Action 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.
