|
Hi Guys, I am using SQL server 2008R2 instance which is monitored by red-gate SQL monitor. Database mail process is taking more than 5 minutes to execute. It always come up in my long running query list. Below is the sql fragment. I have no idea how to make it execute faster and where to tune it. Any direction will be much appreciated.
(comments are locked)
|
|
@NaveenK - Have you checked how many entries are in the You can use the stored procedure You run it like this: Hi William, Thanks for the quick response there are 8797 entries in msdb.dbo.sysmail_mailitems. I will clean the old entries. But 9 K entries are not much.
Oct 05 '11 at 01:02 PM
NaveenK
"But 9K entries are not much" - not normally, no, but it depends on how those entries are being processed.
Oct 05 '11 at 01:52 PM
ThomasRushton ♦
(comments are locked)
|

