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.
| 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,Ramrams |
|
|
|
|
|