BI performance counter: Avg. Disk sec/Write

Applies to

Operating System

Description

Displays the average time / latency in seconds to perform volume disk write operations. Note 1 sec = 1,000 milliseconds. Microsoft recommends, for good performance, that I/O latency should not exceed 25 milliseconds.

Resolved by

DBAs

Suggested solutions

  1. Add additional memory
  2. Increase the max memory allocation
  3. Upgrade storage
  4. Make sure partitions are aligned correctly
  5. Indexing, look for high IO queries
  6. Data page compression if CPU usage doesn’t suffer
  7. Spread database files over other (less busy) volumes

Additional research

How to examine IO subsystem latencies from within SQL Server
Technet: SQL Server I/O Best Practices
How To: Troubleshooting SQL Server I/O bottlenecks
SQL Server I/O Performance

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index