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

Thanks, I will try that.

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?

...This seems likely, where do...

Kumar,

I've already been through that, but it doesn't explain my current situation.

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

No way to estimate that without knowing more....could be single character rows to full rows...drastic difference in size.

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

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

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

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

Alex,

Any progress on the wait stats? My query will show the stats since the last reboot of the instance.

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

Alex,

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

I will echo the thanks, I think this is not our issue, as the box is totally responsive the whole time.