• SQLRNNR (3/7/2013)


    Hardware reserved, is that in MB or GB that you are showing?

    NUMA - did you make any changes to CPU affinity or is the default setting still active (SQL Server managing)?

    HowardW asked a question concerning Buffer Node v Buffer Manager in regards to which PLE you are monitoring. Which one is reporting the erratic stats?

    Sorry, hardware reserved is 64 MB.

    NUMA is default.

    Pefmon node breakdowns hows PLE on node "000" as 38, node "003" as 43 right now (ie, seems both are equally low)

    Gail:

    Index rebuilds are set for Sunday nights only (and don't appear in sp_whoisactive when I see PLE plummit). CheckDB is not run against this system, I run it on the DR site.