This report provides a graph of several SQL Server memory performance counters for the specified server during the specified time period. Performance counter data is averaged by the hour. The graph displays the following memory performance counters:
Process:Page Faults Per Second (sqlservr)
(Scale=1/10)Process:Private Bytes (sqlservr)
(Scale=MB)SQLServer:Memory Manager / Total Server Memory
(SQL Server 7.0; Scale=KB)SQLServer:Buffer Manager / Buffer Cache Hit Ratio
(SQL Server 7.0; Scale=1)SQLServer:Buffer Manager / Free Buffers
(SQL Server 7.0; Scale=1/10)SQLServer:Buffer Manager / Lazy Writes Per Second
(SQL Server 7.0; Scale=1/10)SQLServer:Buffer Manager / Readahead Pages Per
Second
(SQL Server 7.0; Scale=1/10)SQLServer / Cache Hit Ratio
(SQL Server 6.5;
Scale=1)SQLServer:Cache / Number of Free Buffers
(SQL Server 6.5; Scale=1/10)SQLServer:I/O / Lazy Writes Per Second
(SQL Server 6.5; Scale=1/10)SQLServer:RA / Pages Fetched into Cache per Second
(SQL Server 6.5; Scale=1/10)