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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Benjamin Nevarez
About this chapter
Cite this chapter
Nevarez, B. (2016). SQL Server Storage. In: High Performance SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2271-3_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2271-3_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2270-6
Online ISBN: 978-1-4842-2271-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books