SQL Server Storage

  • Benjamin Nevarez
Chapter

Abstract

This chapter covers storage from the SQL Server point of view and, although other factors such as availability and recoverability play a very important role in selecting and configuring storage, we focus mostly on performance. Disk is traditionally the slowest component in a database system, so tuning storage for performance is essential and usually comes in two high level areas: directly tuning the storage and tuning the components to make efficient use of the storage. The first area refers to tuning and configuring the storage hardware itself, while the second one relates to tuning the other components of the system to make optimal use of the storage and includes items such as proper SQL Server configuration and creating the right indexes.

Keywords

Server Storage Query Optimizer Query Processor Storage Usage Query Processing Algorithm 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Benjamin Nevarez 2016

Authors and Affiliations

  • Benjamin Nevarez
    • 1
  1. 1.Santa ClaritaUSA

Personalised recommendations