HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide

172
 Granted Work space Memory— Specify the granted work space memory for hashing
ordering, copying, index creation operations when APM did the last polling in SQL Server.
 Memory Grants Pending—Specify the memory grant numbers when the SQL Server progress
is pending for getting the workspace..
 Memory Grants Outstanding—Specify the memory grant numbers when the SQL Server
progress is successful to getting the workspace.
 History Record—Click the History Record icon to view the memory usage ratio trend of
the memory usage in a past time period, which includes the last 1 hour, last 6 hours, today,
yesterday, this week, this month, and this year. If you select the time period Last 1 hour,
Last 6 hours, or Today, the memory usage ratio of the SQL Server is measured in unit of a
polling interval; if you select the time period Yesterday, This week, or This month, the
memory usage ratio of the SQL Server is measured in hours, and the diagram displays the
memory usage ratio trend, and the maximum, minimize, and average memory usage ratio of
the SQL Server; if you select the time period This year, the memory usage ratio of the SQL
Server is measured in days, and the diagram displays the memory usage ratio trend, and the
maximum, minimize, and average memory usage ratio of the SQL Server. Move the pointer
over the each sampling point to view the memory usage ratio of the SQL Server for the time
being.
Buffer management
The Buffer Management information is shown in Figure 126.
Figure 126 Buffer management-SQL Server
• Fresh—Click the Fresh icon to update the detail.
• The curve graph displays the buffer hit ratio trend of the SQL Server in the past one hour by
default. You can also select a time period to view the buffer hit ratio trend in the specified time