Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

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 name Description
Mem Usage Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes)
Program Application program name

Drilldown reports (field level)

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