Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ServiceBroker Issue

Author  Topic 

jimoomba
Yak Posting Veteran

90 Posts

Posted - 2011-11-24 : 12:15:32
Hi All,
Hi All,

We are using a serviceBroker queue for updating the message status updates into the database. And for some reason after every 2 months the servicebroker queue is getting overloaded and the updates are not happening. when i checked the rows in SBqueue there are almost 2 lakh records. and after i deleted all those rows it started working. Iam not able to get the root cause for the issue.Kindly help me on the same. I want to know the scenarious what might cause for such type of issue.It could be a gr8 help.

Thanks,
Ram

rams
   

- Advertisement -