Viewing 15 posts - 1 through 15 (of 44 total)
No dice, a full server restore did not fix the issue, I still have the same behavior.
I think that the service broker might be "misconfigured", but I am not...
October 12, 2011 at 7:40 am
Thanks, I will try that.
October 7, 2011 at 8:19 am
anyone know where to check for issues with service broker? It is active, but I can't see what to check on for my current problem?
October 6, 2011 at 11:48 am
the issue is most likely related with the service broker not processing mail; whether it's blocked, not running or something is where you need to look.
...This seems likely, where do...
October 4, 2011 at 7:06 am
I've already been through that, but it doesn't explain my current situation.
October 3, 2011 at 8:47 am
Also, for more informaton.
When I run "sysmail_help_queue_sp @queue_type = 'Mail' ;", I see the following output when it is stuck.
mail0INACTIVE2011-09-30 19:37:57.5002011-09-30 19:37:57.500
September 30, 2011 at 1:59 pm
No way to estimate that without knowing more....could be single character rows to full rows...drastic difference in size.
September 15, 2011 at 11:41 am
In hindsight, I would say that our workload is so varied that in some cases (our smaller DBs) it is a great choice, but in other cases(our very large clients,...
September 9, 2011 at 6:44 am
The gain was pretty good, it brought it back down to about 10% lower than previous baselines, but that might have more to do with the optimization made prior the...
September 9, 2011 at 6:25 am
Just wanted to swing back and close the books on this issue. We determined that there was a default BIOS setting that was causing the performance issues.
Supposedly, these new...
September 8, 2011 at 2:25 pm
To all those who helped, we did lick this one for our affected DB, but with results that we are not super happy about.
We finally moved the DB back...
August 1, 2011 at 7:44 am
Any progress on the wait stats? My query will show the stats since the last reboot of the instance.
July 26, 2011 at 10:49 am
I use this query to show the current wait stats:
WITH Waits AS
(SELECT wait_type, wait_time_ms / 1000. AS wait_time_s,
100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,
ROW_NUMBER() OVER(ORDER BY wait_time_ms DESC) AS...
July 26, 2011 at 9:04 am
When you are seeing issues on the new server, what is the highest wait type, I want to try to compare your issue with ours to see if there...
July 26, 2011 at 7:56 am
I will echo the thanks, I think this is not our issue, as the box is totally responsive the whole time.
July 25, 2011 at 1:38 pm