跳转到主内容

FC LUN 上托管的 SQL server 遇到延迟问题

Views:
21
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
san
Last Updated:

适用于

  • ONTAP 9.x
  • SQL 主机
  • ESXi

问题

  • 托管在 FC LUN 上的 SQL server 实例遇到性能问题导致应用层延迟。
  • 或者 ESXi 主机遇到延迟,并且由于性能问题而持续重新启动。
  • 当首次观察到性能问题时,单个端口上 Ext_Status 0x1d  的 WQE 事件开始在相应的 EMS 日志中出现。

Tue Apr 29 08:42:01 -0400 [Netapp1-02: fct_tpd_work_thread_0: fcp.io.status:debug]: STIO Adapter:3d IO WQE failure, Handle 0xb, Type 8, S_ID: 22F00, VPI: 276, OX_ID: 2243, Status 0x3 Ext_Status 0x1d  

  • 在查看 fcp adapter show -node <node name> -adapter <adapter number> 的输出后,确认交换机端口发出低 RX 光电平:

netapp1::> fcp adapter show -node Netapp1-02 -adapter 3d
  (network fcp adapter show)
              Node: Netapp1-02
            Adapter: 3d
          [....]
    Received Optical Power: 205.1 (uWatts)
   Is Received Power In Range: true
SFP Transmitted Optical Power: 876.4 (uWatts)
   [....]

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.