Skip to main content
NetApp Knowledge Base

SQL cluster lost connection to iSCSI LUN intermittently

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

Applies to

  • ONTAP 9
  • iSCSI
  • SAN

Issue

  • SQL cluster lost connection to iSCSI LUN intermittently
  • Windows server reports below events:
    •  Event ID 9001
      The database log was taken offline. Usually this signifies a catastrophic failure that requires the database to restart.

    • Event ID 17053
      Generic operating system error occurred. Not clear what the resulting state is.

    • Event ID 833
      This message indicates that SQL Server has issued a read or write request from disk, and that the request has taken longer than 15 seconds to return. This error is reported by SQL Server and indicates a problem with the I/O subsystem. You might also notice other symptoms associated with this message: high wait times for PAGEIOLATCH waits, warnings, or errors in the system event log, indications of disk latency issues in system monitor counters. Monitor sys.dm_io_virtual_file_stats and choose appropriate storage tier and IOPS for your storage throughput.

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.