SQL Server:Buffer Page Life Number of seconds a > 300 Manager Expectancy page will stay in the buffer pool without references. When under 300, this may indicate poor index design (leading to increased disk I/O and less effective use of memory) or, simply, a potential shortage of memory. SQL Server:Buffer Page Lookups/sec Number of requests to (Page lookups/ Manager find a page in the sec) / (Batch buffer pool. When the Requests/ ratio of batch requests sec) < 100 to page lookups crests 100, you may have inefficient execution plans or too many adhoc queries. SQL Server:Buffer Page Reads/sec Number of physical < 90 Manager database page reads issued. Higher than 90 may be a yellow flag for poor indexing or insufficient memory. SQL Server:Buffer Page Writes/sec Number of physical < 90 Manager database page writes issued. Values over 90 should be cross checked with “lazy writer/sec” and counters. “checkpoint” If the other counters are also high, then it may indicate insufficient memory. SQL Server:Buffer Readahead/sec Number of read in < 20% of Manager anticipation of use. If Page Reads/ this value is makes up sec even a sizeable minority of total Page Reads/sec (say, greater than 20% of total page reads), you may have too many physical reads occurring. SQL Server:Buffer Database Pages Number of pages in NA Manager the buffer pool with database content.
SQL Server:Buffer Manager Page Life Expectancy Number of seconds a page will stay in the buffer pool without references. When under 300, this may indicate poor index design (leading to increased disk I/O and less effective use of memory) or, simply, a potential shortage of memory. > 300 SQL Server:Buffer Manager Page Lookups/sec Number of requests to find a page in the buffer pool. When the ratio of batch requests to page lookups crests 100, you may have inefficient execution plans or too many adhoc queries. (Page lookups/ sec) / (Batch Requests/ sec) < 100 SQL Server:Buffer Manager Page Reads/sec Number of physical database page reads issued. Higher than 90 may be a yellow flag for poor indexing or insufficient memory. < 90 SQL Server:Buffer Manager Page Writes/sec Number of physical database page writes issued. Values over 90 should be cross checked with “lazy writer/sec” and “checkpoint” counters. If the other counters are also high, then it may indicate insufficient memory. < 90 SQL Server:Buffer Manager Readahead/sec Number of read in anticipation of use. If this value is makes up even a sizeable minority of total Page Reads/sec (say, greater than 20% of total page reads), you may have too many physical reads occurring. < 20% of Page Reads/ sec SQL Server:Buffer Manager Database Pages Number of pages in the buffer pool with database content. NA