SQL and Memory Pressure

Version 2

    SQL and Memory Pressure

     

    A template we use that is based off a msdn blog from 2010(link in component notes).  Its centered around the page life expectancy perfmon metric primarily, including memory grants pending and buffer cache hit ratio.  Also threw in sql server and agent run states.  We use this as a base for every sql server we have and we add others after that are either system or db specific after, the vast majority of our apps are memory intensive so memory pressure is a big deal for us.  Explanations of specific component metrics are included in the descriptions.