You can use the concurrency high water marks and the concurrency
limit metrics to evaluate whether the concurrency limit of a workload
is appropriate.
About this task
The concurrency high water marks are plotted over time so
that each point represents the high water mark for a specific collection
interval. The concurrency limit specifies the maximum number of concurrent
activities that the service superclass associated with the workload
can run. Use the charts on the
Service Superclasses page
of the
Workload Manager Configuration dashboard
in the
database performance monitor to
determine whether the concurrency limit of the associated workload
is appropriate.
Procedure
- On the Service Superclasses page,
click Show charts.
- Click the Concurrency and CPU Usage tab.
- Define the time period that you want to evaluate.
- Select the check box next to the service superclass that
you want to analyze.
- Plot the concurrency high water marks by selecting the High
water mark check box.
- Plot the concurrency limit by selecting the Concurrency
limit check box.
- Compare the two graphs.
Results
The concurrency limit of the workload is appropriate if the
concurrency high water mark graph is close to the concurrency limit
graph throughout the specified time period.