title: sqlserver.exe takes high CPU usage, that is more than 90%. In which scenario's sql server takes so much CPU usage?
body: <p>I have SQL Server 2008 R2 on server, my issue is its CPU usage reaches more than 90%. I just need to know that, </p>
  
  <p>In which cases or scenario's, the sql server's cpu memory usage goes so high?</p>