December 6, 2012 at 12:00 am
Hello gents
I have right now a suspended spid 53 at msdb which is in suspended status for over 2 hours. Seen from sp_who2, the 'cmd' it is doing is 'delete' and the login behind this process is "NT AUTHORITY\SYSTEM" from program name "Microsoft Windows Operating System".
In addition, lastwaittype is BROKER_RECEIVE_WAITFOR and I ran dbcc opentran in msdb and it returns:
Oldest active transaction:
spid: 53
UID: -1
Name: receiving msg
Start time: <the time i ran "dbcc opentran">
Any ideas where else I should look at?
Thanks in advance!
Bazinga!
December 6, 2012 at 12:12 am
you have Database Mail configured?
if yes,then might be automatic cleanup proccess going for DB Mail is going on
run dbcc inputbuffer (spid)
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 1:29 am
yes, this instance has email profile configured.
And this is the output of DBCC inputbuffer
EventTypeParametersEventInfo
Language Event0WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000
Bazinga!
April 2, 2013 at 12:23 am
Although this is an old thread, but I am encountering the same problem again today.
Eventinfo "WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000" from spid 51 in msdb dabase is executing 'DELETE' cmd in a 'suspended' status.
Plus, all logshipping restore jobs on this box are delayed.
Bazinga!
May 23, 2013 at 8:48 pm
Were you able to find the source of this issue? I am seeing the same exact scenario on a few of my servers. No performance issues that I can tell though, just want to know where that suspended process is coming from.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy