Pro-active management of DW Workloads
•Predictive Query
Governing and Dynamic Re-prioritization:
–Queries which are
estimated to take longer than an DBA-specified limit will abort or be ‘de-prioritized’
•Automatic Queuing:
–A limit can be set on
the number of active session for each group of users; queries submitted which exceed this limit will
be queued
•Via Database Resource
Manager