SQL Cluster failover during DBCC CheckDB operation

• gary1

  SSC-Insane

  Points: 21152

  More actions

  December 21, 2015 at 11:13 am

  #399493

  Hi,

  SQL server Cluster instance failing over during DBCC CheckDB operation because high IO.

  I'm seeing below error in error log before the cluster failover.

  The database are SharePoint databases and they are very huge. We have 10 databases and each with 400 GB size (Total 4 TB).

  Do we need to alter any cluster settings so that it won't fail over? Please advise

  spid4s SQL Server has encountered 17190 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\TempDBData\SP\tempdev_1.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000560. The offset of the latest long I/O is: 0x000001dcc50000

  SQL Server has encountered 17188 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\TempDBData\SP\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000564. The offset of the latest long I/O is: 0x000001d9a20000

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 29, 2015 at 8:48 am

  #1848518

  check your storage backing the Tempdb. SQL Server is sending requests to the disk subsystem and they're not returning in a timely fashion

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉