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 |
|
MikeZ
Starting Member
6 Posts |
 Posted - 2014-06-25 : 01:01:33
|
| Hi SQL Master,I would like to ask you about Service Broker. It is Urgent.My production database suffers from Large message queue which is around 2 million ... I would like to decrease it as small as possible I have done dbcc dbreindex('sys.queue_messages_245575913') using DAC connection..but when I check again into the Queue properties ..the queue number remain the same..Please kindly advice ....thank youMimi |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-25 : 02:19:55
|
Uhm... You should check the Wait Statistics to see what is going on and why the server cannot process the queue in a timely fashion.Something seem to block the queue.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
MikeZ
Starting Member
6 Posts |
Posted - 2014-06-25 : 02:28:13
|
Hi Thank you for your response. I appreciate it how do I check the wait statistics ?Rgds,Mequote:
Originally posted by SwePeso
Uhm... You should check the Wait Statistics to see what is going on and why the server cannot process the queue in a timely fashion.Something seem to block the queue.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
|
|
|
|
|
|
|
|
|
High Message Queue in Service Broker