Managing workloads with resource pools and user profiles
The scenarios in this section describe common workload-management issues, and provide solutions with examples.
The scenarios in this section describe common workload-management issues, and provide solutions with examples.
In this section
- Periodic batch loads
- CEO query
- Preventing runaway queries
- Restricting resource usage of ad hoc query application
- Setting a hard limit on concurrency for an application
- Handling mixed workloads: batch versus interactive
- Setting priorities on queries issued by different users
- Continuous load and query
- Prioritizing short queries at run time
- Dropping the runtime priority of long queries