HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide
191
Batch Requests/Min—Number of the Transact-SQL command batches that the SQL Server
received per minute. High value of this index indicates good throughput.
SQL Compilations/Min—Times of SQL compilations per minute. This value is in steady state
after the activity of the SQL Server user becomes stable.
SQL Recompilations/Min—Times of SQL recompilations per minute.
Auto Param Attempts/Min—Times of the auto-parameterization attempts per minute. The
auto-parameterization attempt progress happens whenever the SQL Server instance tries to
replace some characters with the parameters to parameterize Transact-SQL requests. To the
similar requests, this progress can reuse the operation plan saved in the cache.
Auto Param Failures/Min—Times of the failed auto-parameterization attempts per minute. The
value should be small.
History icon —Click the History icon to view the history graph of SQL statistics trend.
Hover the cursor over a spot on the curve to view the trend of SQL statistics at the specific time
point. Authorized users can view SQL 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.
Latch Details
The Latch Details area layout is shown in Figure 140.
Figure 140 Latch Details area layout
Latch Details area fields:
Average Latch Wait Time trend graph—Shows the changes of the average latch waiting time of
SQL Server over the last 1 hour in a line chart. Hover the cursor over a spot on the curve to view the
average latch waiting time 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 Waits/Min—Number of the waiting latch requests per second.
Average Latch Wait Time—Average waiting time (in millisecond) for latch requests.