April 18, 2011 at 7:13 am
I had a problem using SQL 2005 Service Broker where one day, the transmission_Queue and destination queue kept increasing. In addition, the transaction log grew. There was no error in the transmission_Status. The routes were definitely properly configured as it was working previously and nothing was changed. The destination queue was configured with Activation with only a single reader. My suspicion is that the activation proc took a message out of the queue to process and it was just taking a long time to complete so that nothing else in the queue could be processed, however, I don't know how I could prove this. I looked at sys.dm_broker_activated_tasks and I see the activation proc running. What I want to do is find a way to look at the message that the proc was processing. Is there a way to do this?
Thanks
April 18, 2011 at 12:21 pm
In your profiler setup event Broker:Transmission
It will show the error message when transport error occurs in the transport layer.
April 18, 2011 at 4:04 pm
select st.text,sp.* from sys.sysprocesses sp
cross apply sys.dm_exec_sql_text(sp.sql_handle)
check this query to find out the problem
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply