CPU usage by Login id

• Low Rider

  SSCommitted

  Points: 1502

  More actions

  September 23, 2014 at 9:08 pm

  #311761

  Guys

  How it possible to find the top 10 CPU utilization by the login/user in SQL 2008 r2 and above ?

  Thanks

• Cláudio Silva

  Ten Centuries

  Points: 1006

  More actions

  September 24, 2014 at 5:33 am

  #1747793

  Hi Low Rider,

  See if this helps (http://msdn.microsoft.com/en-us/library/ms176013(v=sql.105).aspx):

  SELECT TOP 10 login_name, SUM(cpu_time)

  FROM sys.dm_exec_sessions

  WHERE session_id > 50

  GROUP BY login_name

  ORDER BY SUM(cpu_time) DESC

  Basically will give you the logins with most CPU time usage, but only for the current sessions.