2.1. Configure the Server Platform
SQL Server does not exist in a vacuum. It obviously needs hardware and operating system resources to run. The proper configuration of these resources is essential to the performance of a SQL Server enterprise environment. Since SQL Server is a substantial consumer of disk and memory resources, these should be your primary area of focus. Ensuring that SQL Server has adequate resources that are properly tuned for performance and fault tolerance will provide the foundation for a better-performing data platform.
2.1.1. Configuring System Memory
Data is stored durably in files, but generally SQL Server must read data into memory to be used by client applications. Having sufficient memory is vital to SQL Server's ...
Get SQL Server® 2008 Administration: Instant Reference 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.