July 26, 2010 at 12:03 am
hello experts,
i have updated all the statistics but after some time when i checked the status by Sp_who2 it is showing SUSPENDED, wanna know why is this so??
and what can i do for make this status running.
July 26, 2010 at 1:38 am
Is this a SQL Server 2005 Replication question?
Processes are put into the suspended state if they are waiting on another resource. Use the following query to find out what it is waiting on (replace the x with the session_id/SPID returned by sp_who2):
SELECT session_id, status, wait_type, wait_time, last_wait_type
FROM sys.dm_exec_requests
WHERE session_id = x
Once the reason for the wait is resolved, the process can continue to run.
July 26, 2010 at 3:26 am
the wait_type is CXPACKET
then what to do? and what it shows?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply