SQL Server 2012 vs 2008 R2 CPU Usage RRS feed

  • Question

  • Hi all,

    We have recently compared the CPU usage of SQL Server 2012 to 2008 R2 and found that 2012 is using considerably more CPU.

    We have used the same database definition for both cubes and then run the same workload pattern on both.  SQL Server 2012 uses many magnitudes more CPU to process the requests.

    At a low level, we run the same MDX query on both servers and look at the profiler traces.  In SQL Server 2012, the traces for "Query End" are generally like CPUTime 203 / Duration 172 whereas on SQL Server 2008 R2, they're about CPUTime 16 / Duration 140.

    I can't understand what the difference is, but it seems both take around the same time to process the query, but the entire time 2012 is using CPU, whereas 2008 R2 is using only a portion of that.

    What's going on here?  Did something major change in 2012 that degrades performance?

    Thursday, May 17, 2012 8:17 AM