Memory Usage - Top 10 Sessions (6.0)

Organization of this page

Overview
Storage location
Record
Fields
Drilldown reports (field level)

Overview

The Memory Usage - Top 10 Sessions (6.0) report displays information related to the top 10 sessions that are currently using the largest amounts of memory. This report is displayed as a bar graph. From the displayed report, you can display more detailed drilldown reports.

To Page Top

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

To Page Top

Record

Process Detail (PD_PDET)

To Page Top

Fields

Field name	Description
Mem Usage	Microsoft SQL Server version 2014 or earlier: Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes) Microsoft SQL Server version 2016 or later: Number of pages of memory used in the process
Program	Application program name

To Page Top

Drilldown reports (field level)

Report name	Description
`Session Detail (6.0)`	Displays detailed information related to resource usage in each session. To display this report, click the Mem Usage field.

To Page Top