[SQL 2012] Always on : Read only query locked by system process |
| Always on : Read only query locked by system process Posted: 13 Oct 2013 08:52 PM PDT 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 |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment