Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Question

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2011-11-19 : 17:05:43
Does the below query provide the users cpu usage at given point of time

select loginame,cpu,login_time,memusage from master..sysprocesses
where cpu > 0

I am looking for a query which list out the users (Query) which is using maximum CPU usage.

Thanks for your help in advance

   

- Advertisement -