title: SQL Server 100% CPU Utilization - One database shows high CPU usage than others
body: <p>We have an SQL server with about 40 different (about 1-5GB each) databases. The server is  an 8 core 2.3G CPU with 32Gigs of RAM. 27Gig is pinned to SQL Server. The CPU utliziation is mostly close to 100% always and memory consumption is about 95%. The problem here is the CPU which is constantly close to 100% and trying to understand the reason.</p>
  
  <p>I have run an initial check to see which database contributes to high CPU by using - <a href="https://stackoverflow.com/questions/10319575/sql-server-2008-high-cpu-usage">this</a> script but I could not substantiate in detail on whats really consuming CPU. The top query (from all DBs) only takes about 4 seconds to complete. IO is also not a bottleneck. </p>
  
  <p>Would Memory be the culprit here? I have checked the memory split and the OBJECT CACHE occupies about 80% of memory allocated (27G) to SQL Server. I hope that is normal provided there are lot of SPs involved. Running profiler, I do see lot of recompiles, but mostly are due to "temp table changed", "deferred compile" etc and am not clear if these recompiles are a result of plans getting thrown out of cache due to memory pressure</p>
  
  <p>Appreciate any thoughts.</p>