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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply