HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide
174
Figure 127 Connection statistics-SQL Server
• Fresh—Click the Fresh icon to update the detail.
• The curve graph displays the connection time trend of the SQL Server in the past one hour by
default. You can also select a time period to view the connection time 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.
• Connections Statistics chart—This chart displays the variation of connection for SQL Server in the
last hour. Put the mouse on the curve to view the specific data of all collection points.
• Attribute and Value—Indicate the name and date of the indexes. The indexes include:
Connection Time—Indicate the consuming time of building a connection in the last time APM
polling the SQL Server.
User Connections—Indicate the number of connections which are in the status of connection
when APM did last polling.
Logins/sec—Indicate the times of the login per second when APM did last polling.
Logouts/sec—Indicate the times of the logout per second when APM did last polling.
Click the “threshold value setting” icon to set the warning threshold value for connection
time. After this operation, the threshold value is shown as dashed line in the connection time
area. Yellow color stands for the Level 1 threshold value. Red color stands for the Level 2
threshold value. 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 connection time 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 connection time of the SQL Server is measured in unit of a polling interval; if you select the