Applies to
Operating System
Description
Displays the average size in bytes of read operations on the volume.
This counter can be used in conjunction with Avg. Disk Sec/Read to determine the average read throughput of the volume. This counter can be used to form a baseline of storage usage.
There is no rule of thumb for this counter as acceptable throughput is determined by workload and the level of storage available. If storage is utilized too frequently you can use the Suggested Solutions below to reduce it.
Resolved by
DBAs
Suggested solutions
- Add additional memory
- Increase the max memory allocation
- Upgrade storage
- Make sure partitions are aligned correctly
- Indexing, look for high IO queries
- Data page compression if CPU usage doesn’t suffer
Additional research
How To: Troubleshooting SQL Server I/O bottlenecks
SQL Server I/O Performance