June 17, 2014 at 3:28 pm
Hi all,
I am looking for scripts to find "currently running" resource hogs. I have scripts for overall/accumulated CPU, RAM, I/O hogs, but I cannot find any scripts on the net that show the top 10 queries that are currently running and are using, let's say the most RAM. If you have these scripts in your arsenal, please share! Thanks in advance.
June 17, 2014 at 3:57 pm
Most queries don't use much memory, the buffer pool is shared. Only workspace memory grants are per query.
For overall CPU, reads, duration, take a look at this (aging) article:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply