You can define thresholds for workload event types. When a threshold is met or exceeded, the associated workload event occurs. Maximum and minimum limits must be positive integers. The following event types are available.
|Active Requests||Defines maximum or minimum number of queries that can be active at one time. Active Requests are not available for utility workloads.|
|Arrivals||Defines maximum or minimum per-second arrival rate for queries. Arrivals are not available with utility workloads.|
|AWT Wait Time||Defines minimum time a step in a request can wait to acquire an AWT.|
|CPU Utilization||Defines maximum or minimum CPU usage for a query.|
|Delay Queue Depth||Defines minimum number of queries in the delay queue.|
|Delay Queue Time||Defines a minimum for the time a request can be in the delay queue.|
|SLG Response Time||Triggers an event based on the Response Time SLG set for the workload. Available only if a Response Time SLG is set for the workload.|
|SLG Throughput||Triggers an event based on the Throughput SLG set for the workload. Available only if a Throughput SLG is set for the workload.|
Some workload event types allow you to set a qualification time. Setting qualification times can prevent very short incidents from triggering events. The qualification time is checked at the end of each interval.
|Qualification Method Options||Description|
Specifies how long an event threshold must be met before an event is triggered.
Specifies that an event is triggered immediately after an event threshold is met.
Specifies the following: