Memory Usage - Top 10 Sessions

Overview

The Memory Usage - Top 10 Sessions 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.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

Record

Process Detail (PD_PDET)

Fields

Field nameDescription
Mem UsageNumber of procedure cache pages allocated to the process (1 page equals 8 kilobytes)
ProgramApplication program name

Drilldown reports (field level)

Report nameDescription
Session DetailDisplays detailed information related to resource usage in each session. To display this report, click the Mem Usage field.