February 25, 2016 at 1:31 pm
Hi,
We are importing data to the database.
I ran the below query to find
select session_id, start_time, status, command, user_id, blocking_session_id, wait_type, wait_time, last_wait_type,wait_resource,lock_timeout,cpu_time, reads, writes,logical_reads
,percent_complete, estimated_completion_time, total_elapsed_time row_count, prev_error from sys.dm_exec_requests
where session_id>50
and user_id =10 option(recompile)
session_idstart_timestatuscommanduser_idblocking_session_idwait_typewait_timelast_wait_typewait_resourcelock_timeoutcpu_timereadswriteslogical_readspercent_completeestimated_completion_timerow_countprev_error
1302016-02-25 11:11:34.653suspendedINSERT100CXPACKET10688970CXPACKET-13567336775503753304393000117892260
I didn't see any changes in the writes and reads. The status is suspended and wait_type=CXPACKET
Does it means it is waiting for CPU?
February 25, 2016 at 2:14 pm
A CXPACKET wait is basically waiting on a parallel thread(s) to finish. In of itself it isn't that concerning.
Try this...
SELECT * FROM sys.dm_exec_requests WHERE session_id = your spid here
One of those threads should be active.
February 26, 2016 at 12:39 pm
So if we can see the spid from sys.dm_execute_requests. i.e. it is active. But I didn't see the diskIO is changing from sp_who2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply