question

cornpoppy avatar image
cornpoppy asked

The waiting tasks in activity monitor shows there are 4 tasks always in waiting states.

![alt text][1] processes box show wait time 0 but the waiting tasks in activity monitor shows 4 ![alt text][2] [1]: /storage/temp/4419-monitor.png [2]: /storage/temp/4420-wait-task.png how can i solve that ?
sqlperformancedbadba-developerwaits
monitor.png (24.7 KiB)
wait-task.png (29.7 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
Query `sys.dm_os_waiting_task` and not the wait stats DMV, the later is not going to show you currently active task running on the system.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.