[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Required Drive Performance on a Database Server



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017

Required Drive Performance on a Database Server

Applies to: Microsoft SQL Server all versions.

The average read or write response time of a drive should be at least 10 milliseconds (ms) or less. A storage subsystem with a response time over 10 ms could degrade performance.

Use tools like Iometer to measure the performance of a storage subsystem on a database server.

The following image shows the result of an analysis performed by Iometer on my laptop. Take a look at the results for the "Average I/O Response Time (ms)" section.



Microsoft SQL Server Risk Assessment Program.



.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.