-
Select Distribution Parameter.
The following table describes the displayed columns in the “what” classification Analyze Workload report.
Columns in the Analyze Workload Report – “What” Classification Column Name Description Estimated Processing Time Min, Max, Query Count
The minimum and maximum estimated processing time and the number of queries that completed during this collection interval for this bucket. Percent of Total CPU The percentage of the total CPU time (in seconds) used on all AMPs for this bucket. Percent of Total I/O The percentage of the total number of logical input/output (reads and writes) issued across all AMPs for this bucket. Average Est Processing Time The average estimated processing time for each query. Normalized CPU per Query (seconds) Min, Avg, StDev, 95th Percentile, Max
The minimum, average, maximum, standard deviation, 95th percentile and maximum expected CPU time for queries in this bucket. UnNormalized CPU per Query (seconds) Min, Avg, StDev, 95th Percentile, Max
The minimum, average, maximum, standard deviation, 95th percentile and maximum expected UnNormalized CPU time for queries in this bucket. Response Time (Seconds) Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum response time for queries in this bucket. Result Row Count Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum result rows returned for this bucket. Disk I/O Per Query Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum disk I/Os per query for this bucket. CPU To Disk Ratio Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum CPU/Disk ratio for this bucket. Active AMPS Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum number of active AMPs for this bucket. Spool Usage (Bytes) Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum spool usage across all VProcs for this bucket. CPU Skew (Percent) Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum AMP CPU skew for this bucket. I/O Skew (Percent) Min, Avg, StDev, Max
The minimum, average, standard deviation, and maximum of AMP I/O skew for this bucket.