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