Workload
The Workload tab graphically displays four sets of statistics that you can use to monitor the database workload and identify spikes and bottlenecks.
Each set of statistics is displayed in a separate region, as described in the following sections.
Monitored and Analyzed Time Indications
The time slider has more functionality in the Workload tab than it does in the Active Session History and SQL Monitoring tabs. Note the following Quick Select time range options:
-
Last Hour, Last 8 Hours, and Last 24 Hours - The charts in the Workload tab display data for the entire time period of specified time range. A shadowed area is displayed in each chart that corresponds to the position of the time slider in the time range.
-
Last Week - The charts in the Workload tab display data for the selected time period of the time slider in the time range. A shadowed area is not displayed in this case.
-
Custom - The shadowed area display depends on whether the time period is up to and including 24 hours, or greater than 24 hours.
Regions
The tab contains four regions, namely CPU Statistics, Wait Time Statistics, Workload Profile, and Sessions.
Each region contains one or more charts that indicate the characteristics of the workload and the distribution of the resources. The data displayed on all the charts is for the same time period, as selected by the Time Range and time slider at the top of the window.
For more information about the Workload tab, its regions and the associated charts, see: