HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide
180
Average Latch Wait Time—Indicate the average latch wait time when APM did the last
polling, the unit is micro second.
History Record—Click the History Record icon to view the Latch details trend 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 Latch details 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 Latch details of the SQL Server is
measured in hours, and the diagram displays the Latch details trend, and the maximum,
minimize, and average Latch details of the SQL Server; if you select the time period This
year, the Latch details of the SQL Server is measured in days, and the diagram displays the
Latch details trend, and the maximum, minimize, and average Latch details of the SQL Server.
Move the pointer over the each sampling point to view the Latch details time of the SQL Server
for the time being.
Access method details
The Access Method Details are shown as Figure 132.
Figure 132 Access method details-SQL Server
• Fresh—Click the Fresh icon to update the detail
• The curve graph displays the Access method details trend of the SQL Server in the past one hour
by default. You can also select an Access method details time period to view the Access method
details trend in the specified time period. Click the Last 1 hour icon , the Last 6 hours icon ,
the Today icon , the Yesterday icon , the This week icon , the This month icon , or the
This year icon to select a time period.
• Access Method Details chart—This chart displays the trend of the times of Full/Range/Probe Scan
per minute when SQL Server did the last polling. Green color stands for number of full scan per
minute; Orange color stands for the ranges scans per minute and blue color stands for probe scan
per minute.
Put the mouse on the curve to view the specific data of all collection points.
Click the icon name to display/hide the corresponding index.