Microsoft SQL磁盘不堪重负的响应时间较长
Knowledge Base guidance
This article may include metadata, visibility, validation state, and related support guidance.
适用场景
Microsoft SQL
任何版本的 ONTAP 或 Data ONTAP
问题描述
- 运行SQL性能指标
Avg Disk Queue Length超过1 - 正在运行的SQL日志可能会报告错误：
Disk overwhelmed: Avg Disk Queue Length is greater than 1 and response times are greater than 25 ms for IO sizes of 64 KB or smaller or 35 ms for IO sizes greater than 64 KB.