title: SQL Server 2008 High CPU usage
body: <p>We have a Windows 2008 R2 Server with a SQL Server 2008 in it. That server has multiple .net sites that have SQL server databases on it. </p>
  
  <p>We are currently experiencing an average CPU usage of 95%, and SQL Server is responsible for most of that usage. </p>
  
  <p>I would like to identify which site is responsible for this so we can either optmize it or move it to another server. But I didnt find any direct way of looking this.</p>
  
  <p>I've been looking if I could find:</p>
  
  <ul>
  <li>The database that is getting the most CPU intensive queries</li>
  <li>The process that is responsible for CPU intensive queries</li>
  </ul>
  
  <p>One thing that also complicates the things is that we have multiple sites and "crons" using the same database. So once I identify the database I would also need to get some hints of which site/cron is responsible for it.</p>
  
  <p>I would really appreciate any help on this as this issue is making our sites really slow... </p>
  
  <p>Thanks</p>