Performance | Memory | Overview

A report summarizing the memory configuration and usage of the server.

Basic Metrics (SQL Server 2005 onwards)

What It ShowsComments
Physical memory
Min server memory
Max server memoryHighlighted if zero, or more than 90% of physical server memory
Page life expectancyHighlighted if lower than a limit that depends on the amount of memory. For the calculation used, see thresholds
Memory grants pending
Memory grants outstanding
Non-buffer pool memory
Granted workspace memory
Virtual memory
Connection memory
Optimizer memory
Lock memory
Plan cache memory
SQL cache memory
Stack size

More Advanced Metrics (SQL Server 2008 onwards)

What It ShowsComments
Available physical memory
Total including page file
System cache
Kernel paged pool
Kernel non-paged pool
System memory state
Physical memory in use
Large page allocations
Locked page allocationsHighlighted if zero, as this suggest that the "Lock pages in memory" right has not been assigned to the service account
Available commit limit
Virtual address space reserved
Virtual address space committed

Database Buffer Pool Utilization

This bar chart shows an estimate of the percentage of the buffer pool used for data and indexes by the top 10 databases relative to the total used. That bit in bold is important - the percentages in this chart always add up to 100%, even if only a small amount of available memory is in use.

The percentages are calculated by looking at up to 8GB of random pages (1,048,576 pages). The reason for limiting it to 8GB is performance - it is not uncommon for servers to have 512GB or more of RAM, and to scan the lot would take a long time. Testing has shown that the approach used gives a very good estimate.

< Performance | CPU Performance | Memory | Memory Nodes>