Viewing 9 posts - 1 through 10 (of 10 total)
SQLRNNR (10/19/2011)
It looks to be a need to End the Conversation (service broker).Check this thread and see what they did.
That is the exactly the problem, I've got something looping through...
October 19, 2011 at 2:24 pm
I just did
SELECT * FROM [Queue Name]
For every service broker queue in the database and only found 9 messages in one queue...
I even tried:
DECLARE @msg TABLE (
message_body XML
);
WAITFOR (RECEIVE message_body...
October 19, 2011 at 1:44 pm
I think this may have helped:
sysdercv ...
October 19, 2011 at 1:19 pm
Ninja's_RGR'us (10/19/2011)
Run the code found here and post the results => http://sqlskills.com/BLOGS/PAUL/post/Survey-nonclustered-index-counts-(code-to-run).aspxWho was working during the weekend and what where they doing?
17 GB just doesn't happen overnight.
You're kidding right? I'm...
October 19, 2011 at 1:16 pm
Jeffrey Williams 3188 (10/19/2011)
October 19, 2011 at 1:12 pm
SQLRNNR (10/19/2011)
Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you mentioned)
Here's the...
October 19, 2011 at 1:08 pm
I should probably have prefaced this post with the fact that I'm developer, not a dba.
I'm not sure what you mean by heaps. Do you mean like in memory tables?...
October 19, 2011 at 10:25 am
I have a job that rebuilds indexes that are more than 20% fragmented and it runs every night, but it's been running for over a year now. There is nothing...
October 19, 2011 at 9:58 am
No blobs (text / image, etc.), and the usage of the database hasn't changed. Its a database for our ecommerce site and there wasn't anything last night that would have...
October 19, 2011 at 9:39 am
Viewing 9 posts - 1 through 10 (of 10 total)