• FYI, just as a follow-up to thread I had going (NUMA and PLE on SQL Server 2012).

    CU3 for SQL Server 2012 SP1 has been released which includes the following hot fix.

    SQL Server 2012 experiences performance issues in NUMA environments

    http://support.microsoft.com/kb/2819662

    CU3 for SQL Server 2012 SP1 is available via:

    http://support.microsoft.com/kb/2812412

    There are a number of other fixes in this particular CU which address a host of performance issues. Most notably:

    FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server

    http://support.microsoft.com/kb/2813214

    FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012

    http://support.microsoft.com/kb/2819662

    FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace

    http://support.microsoft.com/kb/2803529

    FIX: Memory leak when you run queries against a temporary table in a nested stored procedure in SQL Server 2012

    http://support.microsoft.com/kb/2803065