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

187
 Total Pages—Total number of the pages in the SQL Server buffer, including stolen pages,
available pages, and database pages.
 Database Pages—Number of database pages in the buffer pool.
 Free Pages—Available pages in the buffer pool.
 Set Threshold icon —Click the Set Threshold icon to set alarm thresholds for the buffer hit
ratio. The specified alarm thresholds appear on the Buffer Hit Ratio trend graph as dotted lines.
The data is highlighted in orange when the buffer hit ratio reaches the level-1 threshold, and is
highlighted in red when the buffer 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 buffer 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 hit ratio
trend. Hover the cursor over a spot on the curve to view the buffer hit ratio at the specific time
point. Authorized users can view buffer hit ratio statistics 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.
Connection Statistics
The Connection Statistics area layout is shown in Figure 136.
Figure 136 Connection Statistics area layout
Connection Statistics area fields:
 Connection Time trend graph—Shows the connection time trend 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 connection time of the 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.
 Connection Time—Time consumed when APM established the connection with the SQL Server.