title: How do I find out what is hammering my SQL Server?
body: <p>My SQL Server CPU has been at around 90% for the most part of today.</p>
  
  <p>I am not in a position to be able to restart it due to it being in constant use.</p>
  
  <p>Is it possible to find out what within SQL is causing such a CPU overload?</p>
  
  <p>I have run SQL Profiler but so much is going on it's difficult to tell if anything in particular is causing it.</p>
  
  <p>I have run sp_who2 but am not sure what everything means exactly and if it is possible to identify possible problems in here.</p>
  
  <p>To pre-empt any "it's probably just being used a lot" responses, this has only kicked in today from perfectly normal activitly levels.</p>
  
  <p>I'm after any way of finding what is causing CPU grief within SQL.</p>