Home Forums SQL Server 2012 SQL 2012 - General Issue with NUMA, Buffer Cache, and Connection pooling on 4S Westmere RE: Issue with NUMA, Buffer Cache, and Connection pooling on 4S Westmere

  • Don't have time to dig into it right now, but over the years and versions there have been any number of buffer-flushing bugs hit SQL Server. Some of them are internal and some from Windows or even firmware/drivers (HP iLO comes to mind here from way back).

    Do some web searching for such things. Also review all CU/SP after your current build for issues like you are seeing that may have been patched. There was a huge thread here on a 2012 bug that flushed randomly IIRC.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service