开发者

Deletion of SQL Service Broker queue is slow

开发者 https://www.devze.com 2023-03-25 13:15 出处:网络
We have a system using SQL server service broker inside a single database. This database is mirrored using high-safety mode and a witness.

We have a system using SQL server service broker inside a single database. This database is mirrored using high-safety mode and a witness.

We have a routing application that receives messages from a queue and forward those messages to a node's queue. On every 8 nodes we have another application that receives that message, process it and send back the status to the routing queue.

For some unknown reason, that application did not see that her queue was already present开发者_JAVA技巧 in the system and re-created that queue again and again. Now I have 20000 queues and 20000 associated service in the system instead of 8.

I started to delete them but it is really slow (+/- 3 minutes to delete 50 queues). Is this normally so slow ? Does the mirroring interfere with SSB ? Is there another method to delete all those queues ?

Thanks

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号