H3C Technologies H3C Intelligent Management Center - Manual (Page 253)

239
{
History Record—Click the History Record icon to view the history graph of the lock statistics
trend. Point to a spot on the curve to view lock statistics at the specific time point. Authorized
users can view lock 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.
SQL Statistics
The SQL Statistics area layout is shown in Figure 189 .
Figure 189 SQL Statistics area layout
SQL Statistics area fields:
• SQL Statistics trend graph—Shows the changes of batch requests, SQL compilations, and SQL
recompilations per minute of the SQL Server over the last 1 hour in a line chart. Point to a spot on
the curve to view the changes of the index of 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.
{
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.