April 15, 2016 at 4:56 am
Usually this process finishes in 6 minits. But Now it is stuck in Runnable Process.
These are some info from activity monitor:
System Process : No
Open Transaction: 0
Command INSERT
Application: APS
Wait time = 0
CPU: 2306078
Memory Usage : 2
Blocked By : 0
Blocking =0
Execution Context: 0
April 15, 2016 at 5:21 am
This is the only process stuck in Runnable state. As i Refresh the CPU is going up every second .
What does that mean and how to resolve this?
April 15, 2016 at 7:04 am
It sounds like the process may be running still. It could be blocked by some other process. Have you checked blocking? Use sys.dm_exec_requests to see what processes are actively running, and, any blocking that's occurring.
If the process is running, killing it will put it into a rollback, which will take as long, or longer, as the initial transaction took.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply