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 ...
© Benjamin Nevarez 2016
Benjamin Nevarez, High Performance SQL Server, 10.1007/978-1-4842-2271-3_9
9. SQL Server Storage
Benjamin Nevarez1
(1)Santa Clarita, California, USA
Get High Performance SQL Server: The Go Faster Book 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.
