February 17, 2010 at 1:15 pm
Hi,
I have noticed the below from Spot light and I'm wondering that is there any issue with the query (because its says that it has been suspended)
spid SQL User Status Blocked By Last Command DBName CPU IO Mem Current Wait Time (ms) Program Last Wait Type Last Wait Resource Login Time Last Batch Time Time Since Last Batch Tran Count Host Name Host Process Net Address Net Library System
94 abc\mssqlsrv suspended WAITFOR BizTalkMsgBoxDb 15 0 2 1,437 SQLAgent - TSQL JobStep (Job 0x7214EF1F475B174B8296440045882E2E : Step 1) WAITFOR 02/11/2010 12:22:00 PM 02/11/2010 12:22:00 PM 6 days 0 SQLBWVS1 5992 0017A4770010 TCP/IP Y
thanks
February 17, 2010 at 2:08 pm
Suspended means it's waiting for something, a lock, a latch, a memory grant, etc. The query needs something to continue executing and it can't currently get it.
The wait type shows what it's waiting for. In this case, that appears to be "WAITFOR" This means that the query contains the WAITFOR DELAY or WAITFOR TIME statement. Hence it's waiting because whoever wrote the query told it to wait.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2010 at 2:09 pm
The last command and wait type is WAITFOR
which means the process is using the WAITFOR command and waiting for a specific period of time before it performs its next command.
No issue.
Craig Outcalt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply