i have prod server sql server version: microsoft sql server 2005 - 9.00.5000.00 (x64) enterprise edition on windows nt 6.1 (build 7601: service pack 1).
i experience problem service broker background processes "brkr task" 2 (2) processes (spid 23 , 24) blocking other "brkr task" processes , these processes have wait type latch_sh on resources service_broker_transmitter (0000000080451900) , service_broker_transmitter (0000000080451b10).
the strange thing 2 blocking "brkr task" processes on spids 23 , 24 changing last_wait_type between cmemthread , pagelatch_ex on resource 0:0:0 (once caught resource 2:5:32, once) , wait_type null , wait_time 0. clarity please take on screenshots: blocked spids , blocking spids
when try select sys.transmission_queue session gets blocked on latch_sh on service_broker_transmitter (0000000080451900). messages not reaching target queue functionality of service broker corrupted.
the question straightforward - problem here , done solve it?
thank can provide.
Comments
Post a Comment