SQL Server Configuration and Tuning
If you do not configure the server properly, all of the hardware in the world and the best designed database mean nothing. Processor options, memory options, I/O options, and query and index options all allow you to designate the most appropriate server configuration for you. Although most of the time you will leave these options at their default values, it is useful to know what configuration options are available to you.
Processor Options
You can configure the way in which SQL Server uses your server's processors. The configuration options available include:
You can configure the relative priority of the SQL Server process.
You can determine which of the server's CPUs SQL Server will use.
You can designate ...
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.
