Always on : Read only query locked by system process

• arr.nagaraj

  SSCertifiable

  Points: 6528

  More actions

  October 14, 2013 at 3:52 am

  #278073

  Dear all,

  I have always on secondary server which supports Read only workload. The read only queries have been smooth for several months.

  Yesterday the read only queries were blocked by a system process ( spid 44 ). on From Sysprocesses I understand that the system process command type was DBStartup. The replica state is also synchronizing ( aysnc mode ) and healthy. Any clue why such a behaviour? thanks

  Regards,
  Raj

  http://Strictlysql.blogspot.com

• SQL Severe DBA

  Hall of Fame

  Points: 3579

  More actions

  October 15, 2013 at 8:34 am

  #1658555

  That is not usual , you mentioned queries not a single query which got blocked . SPID 44 blocked multiple queries ?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  October 21, 2013 at 4:54 am

  #1660082

  Please check error logs of sql server for any unusual entries. Also, did you apply any service pack in recent past and this problem popped after it?

  Manu