title: SQL Server 2008 r2 high cpu usage
body: <p>We running a photo sharing website in Windows Server 2008 r2 ent edition &amp; SQL Server 2008 r2 ent edition. Server configuration is xeon 5620 with 48GB RAM &amp; 4 x 450GB 15k Scsi Hdd's. </p>
  
  <p>we have about minimum 50 and max 500 active connections on DB as per last month average. Now also the average is same. 1 Month back our sql server cpu usage is less then 1% but now it's using minimum 25% and upto 100% always. This problem we are facing from last 8 days. From this last 8 days anwards our CPU usage is increasing always when we start SQL Service &amp; when we stop it's normal only. I request you can any one tell me how to solve this problem.</p>