In this example, one initial workload consumes the majority of the resources. A more granular breakdown of that workload is investigated. Long running outliers are noted in the analysis. The goal is to have these outliers classified into their own workload so that different workload management techniques are applied.
- Select . The Define DBQL Inputs dialog box appears.
- Complete the Define DBQL Inputs options. For more information, see Defining DBQL Inputs.
- In the Category box, select Account String, and click OK. The Unassigned requests report appears.
-
Right-click over each workload and select Auto-Generate Workloads.
The Candidate Workloads Report appears.
The CPU distribution of all workloads is 8% ADW-TACT and 92% ADW-DS. Workload WD-ADW-DS is selected for further analysis because it is consuming 92% of the total CPU.
-
Right-click WD-ADW-DS, and select Analyze Workload.
The Analyze Workload tab appears.
There are a total of five distinct query band names. The query bands can be viewed only if Queryband is selected from the Workload Correlation Parameter list. The five distinct query band names in this example are:- QueryBand (5)
- AggLevel (7)
- Function (5)
- Region (7)
- TopTierApp (3)
- Urgency (3)
There are several suitable analysis candidates available in this query band list, as denoted by the distinct value counts.
- QueryBand (5)
- For this example, select QueryBand as the correlation parameter.
-
Click
to load the query band names in the Queryband Filter drop-down list.
-
Select Function, then click Perform Analysis.
The Correlation Report and graph appear.
A total of five query band values display for the Queryband=Name function. Notice a possible distinction with Function=MIN, which included queries with greater time spent than any of the other queries.
- From the report, right-click the MIN row, and select Split to New Workload.
-
Name the new workload WD_ADW_Outliers.
This step is done to insure that unassigned clusters fall back into the original WD-ADW-DS workload classification.
The QueryBand Function=MIN is split to the new workload, ADW-Outliers. The remaining four functions are unassigned, falling back to ADW-DS if no other action is taken on them.
The Correlation/Distribution Reports and graph refresh with the remaining four unassigned query band values for the next add or split operation.