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

177
• Lock Details—This chart displays the variation trend of Lock Waits/sec, Lock Timeouts/sec and
Number of Deadlocks/sec in last one hour. Green color stands for Lock Waits/sec. Orange color
stands for Lock Timeouts/sec. Blue color stands for Number of Deadlocks/sec.
 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.
• Attribute and Value—Indicate the name and date of the monitor indexes. The indexes include:
 Lock Requests/sec—Indicate the number of the new lock and lock transformation request s in
lock management when APM did the last polling.
 Lock Waits/sec—Indicate the number of the requests of lock waiting per second when APM
did the last polling.
 Lock Timeouts/sec—Indicate the number of the requests of lock timeout per second when
APM did the last polling.
 Number of Deadlocks/sec—Indicate the number of requests of deadlocks per second when
APM did the last polling.
 Average Wait Time—Indicate the average wait time for each lock request when APM did the
last polling.
 Click the “threshold value setting” icon to set the warning threshold value for Lock detail
indexes. When it meets the level 1 threshold value warning condition, the yellow light
displays; when it meets the level 2 threshold value warning condition, the red light displays.
You can use the custom threshold or global threshold to set the threshold value.
 History Record—Click the History Record icon to view the lock detail 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 lock
detail 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 lock detail of the SQL Server is measured in
hours, and the diagram displays the lock detail trend, and the maximum, minimize, and
average lock detail of the SQL Server; if you select the time period This year, the lock detail
of the SQL Server is measured in days, and the diagram displays the lock detail trend, and the
maximum, minimize, and average lock detail of the SQL Server. Move the pointer over the
each sampling point to view the lock detail time of the SQL Server for the time being.
SQL statistics
The SQL Statistics details are shown in Figure 130.