October 14, 2013 at 3:52 am
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
October 15, 2013 at 8:34 am
That is not usual , you mentioned queries not a single query which got blocked . SPID 44 blocked multiple queries ?
October 21, 2013 at 4:54 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy