July 13, 2015 at 12:51 pm
I am having a process that has a last_wait_type as SOS_Scheduler_Wait and is inserting 100 records to a table. This process has been with this wait type forever with low CPU utilization %.
There are other process executing the same query simultaneously without this wait type and executing in minutes. What could be the reason for this process. It has been in runnable state with Last_wait_type as SOS_Scheduler_Wait for that long
July 20, 2015 at 10:58 pm
You will get a better understanding of what this process waits on using sys.dm_os_waiting_tasks.
Is it showing another wait type there?
July 21, 2015 at 3:07 am
this should get you started
July 22, 2015 at 8:02 am
what are the other queries doing at this point in time? runnable means its ready to go.. but something else might be holding it back, that is not related to that specific process?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply