跳转到主内容

Microsoft SQL磁盘不堪重负的响应时间较长

  1. 最后更新
  2. 另存为PDF
Views:
2
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
perf<a>perf</a><a>SQL</a><a>2008618455</a><a>用于</a><a>转换</a><a>的平均队列长度 </a>
Last Updated:

适用场景

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.

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.