SQL cluster lost connection to iSCSI LUN intermittently
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.
-