Finding resources username

• DBA_Learner

  SSCarpal Tunnel

  Points: 4228

  More actions

  February 27, 2013 at 8:43 am

  #290039

  Does anyone has any query which determins the high usage of resources from particular user or domainid. I need to setup a resource governor and need to find out which

  users trying to access hugh resources, therefore for that user I can assign a resource governor. I am able to find HIGH cpu usage but i cannot determine which user is running it.

  I know we can do through profile, but just want to cross check with you to see, if there is anyway determing which user or which application is utilizing lot of resources.

  Thanks.

• Query Shepherd

  SSCrazy

  Points: 2988

  More actions

  February 28, 2013 at 12:51 am

  #1591889

  Something like this :

  SELECT tblSysProcess.cpu as processor, *

  from master.dbo.sysprocesses tblSysProcess

  order by tblSysProcess.cpu desc

  Greetz
  Query Shepherd