Abstract
The disks and the disk subsystem, which includes the controllers and connectors and management software, are one of the single slowest parts of any computing system. Over the years, memory has become faster and faster. The same can be said of CPUs. But disks, except for some of the radical improvements we’ve seen recently with technologies such as solid-state disks (SSDs), have not changed that much; disks are still one of the slowest parts of most systems. This means you’re going to want to be able to monitor your disks to understand their behavior. In this chapter, you’ll explore areas such as the following:
-
Using system counters to gather disk performance metrics
-
Using other mechanisms of gathering disk behavior
-
Resolving disk performance issues
-
Differences when dealing with Linux OS and disk I/O
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Grant Fritchey
About this chapter
Cite this chapter
Fritchey, G. (2018). Disk Performance Analysis. In: SQL Server 2017 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3888-2_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3888-2_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3887-5
Online ISBN: 978-1-4842-3888-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)