Suspended process in msdb database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Suspended process in msdb database

Suspended process in msdb database

Rate Topic

Display Mode

Topic Options

Author

Message

sqlnickxu

Posted Thursday, December 06, 2012 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:24 PM
Points: 194, Visits: 901

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!

Post #1393339

sanket kokane

Posted Thursday, December 06, 2012 12:12 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:12 PM
Points: 323, Visits: 973

you have Database Mail configured?
if yes,then might be automatic cleanup proccess going for DB Mail is going on

run dbcc inputbuffer (spid)

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1393342

sqlnickxu

Posted Thursday, December 06, 2012 1:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:24 PM
Points: 194, Visits: 901

yes, this instance has email profile configured.

And this is the output of DBCC inputbuffer

EventType Parameters EventInfo
Language Event 0 WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000

Bazinga!

Post #1393365

sqlnickxu

Posted Tuesday, April 02, 2013 12:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:24 PM
Points: 194, Visits: 901

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!

Post #1437713

joshuabauman921

Posted Thursday, May 23, 2013 8:48 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 6:22 AM
Points: 1, Visits: 4

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.

Post #1456277

« Prev Topic | Next Topic »

Permissions