- From the Candidate Workloads tree, expand the workload to be analyzed.
- Select Analyze Workload. The Analyze Workload window appears.
-
Select the appropriate “what” options in the Workload Distribution Parameters list.
See the table following step 3 in Analyzing Workloads Based On “Who” Parameters for more information about Analyze Workload window options.
- Click Perform Analysis to analyze the selected workload with chosen options. By default, the Analyze Workload window creates an equal-width balanced histogram, dividing the total selected distribution parameter into the number of buckets specified in the Top N Value field. Each bucket contains equal amounts of the selected distribution parameter and the total query count lies in that bucket.
-
To view the corresponding equal-height histogram, click the Switch to Equal-Height Histogram button on the Analyze Workload tab.
You can also right-click the histogram itself and select Equal-Height Histogram from the menu that appears.
-
To view the Equal-Height Distribution report associated with the histogram, select View Equal-Height Table.
The table appears and is similar to the one shown in the figure below.