Memory

This screen is accessible from transaction DBACOCKPIT under  Performance   Memory .

The following tabs are available:

• Memory Overview

  This screen has three sections:

  • Operating System Memory:

    Shows the total and available physical and page memory

  • SQL Server Memory:

    Shows how much memory is in use by the SQL Server instance and the minimum and maximum limits. It also shows the size and hit ratios of the data cache and the procedure cache

  • Memory state history:

    Shows an indicator over time of whether the available physical memory was low or high. In addition the history of page life expectancy is shown.

• Memory Components

  The top half of this screen shows a list of the memory components within the SQL Server memory in descending order of size. Two pie charts appear on the bottom half of the screen. The one on the left shows which memory components make up 90 % of the server memory. The smaller pie chart on the right shows which components make up the remaining 10 %. This allows you to quickly determine if the memory is flooded by one or two components.

• Memory Usage

  This screen shows a list of the largest tables in the SQL Server data cache. By default the 100 largest objects are shown. In some cases these objects belong to a database other than the one being monitored, and sometimes those databases are inaccessible to the monitor connection. In such cases the message no access to database appears. The column avg_free_per_page_kb indicates how much free space exists within the 8 K pages on average. The button Table Details goes to Single Table Analysis for the table.

• NUMA Memory

  This screen shows the state of NUMA nodes, their states, and memory consumption.