HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide

189
 Cache Pages—Number of the pages that the cache objects were using. The size of each page
is 8K.
 Set Threshold icon —Click the Set Threshold icon to set alarm thresholds for the cache hit
ratio. The specified alarm thresholds appear on the Cache Hit Ratio trend graph as dotted lines.
The data is highlighted in orange when the cache hit ratio reaches the level-1 threshold, and is
highlighted in red when the cache hit ratio reaches the level-2 threshold. Use the global
thresholds or custom thresholds. For information about setting the thresholds, see see "5
Configuration management." Higher cache hit ratio indicates better performance. Select Less
than or equal to for the Threshold Condition field.
 History icon —Click the History icon to view the history graph of the buffer details trend.
Hover the cursor over a spot on the curve to view the buffer details at the specific time point.
Authorized users can view the buffer details over the last 1 hour, last 6 hours, today, yesterday,
this week, this month, and this year by clicking the corresponding icons on the upper right of the
graph.
Lock Details
The Lock Details area layout is shown in Figure 138.
Figure 138 Lock Details area layout
Lock Details area fields:
 Lock Statistics trend graph—Shows the lock changes of the SQL Server over the last 1 hour in a line
chart. Hover the cursor over a spot on the curve to view the lock trend of SQL Server at the specific
time point. To change the report period, click the Last 1 Hour icon on the upper right of the
graph, and then select an icon from the list. Available options include Last 6 Hours , Today
, Yesterday , This Week , This Month , and This Year .
 Attribute/Value—Monitor index name and data that was obtained when APM last polled the SQL
Server.
 Lock Requests/sec—Number of the received lock requests and the lock conversions per second.
 Lock Waits/sec—Number of the waiting lock requests per second.