• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Configuring, Maintaining, an... > SQL Server Configuration and Tuning

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint