Issue Cluster AlwaysON SQL 2014 SP1

• ERIC CRUDELI

  SSCommitted

  Points: 1786

  More actions

  December 1, 2015 at 1:01 am

  #1843092

  Hi,

  I have nothing on error log.

  I think if I can restart SQL Engine on secondary node, it could be fix some issues. I tried to stop it but actually the statut is STOP PENDING for (SQL ENGINE SERVICE).

  I can't stop properly because we have some sleeping transactions (see *.xls). I tried to Kill Spid 242 (sleeping transaction locking another transaction but nothing happen). Except to unplug the server I have no other option.

  If we have a solution to kill these transactions it will be my christmas gift :w00t:

  Thanks guys for your helps

  Eric

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 1, 2015 at 4:12 am

  #1843128

  Perry Whittle (11/27/2015)

  ---

  Run a cluster validation and check the report

  ????????

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

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