Data warehouses today run a complex mix of applications, all competing at once for database resources. Frequent data loading competes with business-critical tactical requests and strategic requests for business decision-making. Each workload type has different system resource needs and user response time expectations. TASM brings order to this environment. DBAs can use TASM to specify Service Level Goals for selected workloads, monitor performance toward those goals, and define actions for Vantage to take to avoid slowdowns of critical work.
Specifically, users create TASM rules that automate how work submitted to Vantage executes under different circumstances and when the database takes the following actions:
- Limits sessions, utilities, and requests – delaying or rejecting them when limits are reached
- Divides system resources among different types of requests
- Sends alerts or changes the workload of active requests that exceed limits
- Monitors time of day and system resources and reacts in predefined ways