question

humanko avatar image
humanko asked

Activity monitor

Hello. I'm currently employed as a DBA. Recently I faced a problem of poor activity monitor perception. We have tasks in the running state, some of them have resource waits. So if a task is not waiting for anything, why is it even taking time to execute? No cpu wait, no disk wait, why isn't it run instantaneously? Also, the resource wait column - does it display the last waiting resource? Because if a task is waiting, it is supposed to be in the suspended state. Additionally, sys.sysprocesses shows tasks in the running/runnable state, why doesn't activity monitor separate these two? Thanks!
activity-monitor
3 comments
10 |1200

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

It might help your question, if you could post some screenshots of what you are seeing in Activity Monitor and some example output from queries on sys.sysprocesses. Also what version of SQL Server are you running? If it's greater than 2000, you should be using DMVs instead of sys.sysprocesses
0 Likes 0 ·
its 2008 R2. well with activity monitor you can see the changes dynamically instead of rerunning the query, so I find it quite useful
0 Likes 0 ·
Just so you know, the "dynamic" changes you see with Activity Monitor are just the software rerunning the query in the background. If you prefer the detailed results of sys.sysprocesses query (there are a lot of little things about activity monitor that people don't like), you can get it to refresh "dynamically" by putting it in a loop with a `waitfor delay` statement
0 Likes 0 ·

0 Answers

·

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.