| Example
Scenario |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Power Users |
||||||||||||||
| – | Up to 70% of
the CPU resources |
||||||||||||||
| – | Any degree of
parallelism |
||||||||||||||
| – | Any query
which is expected to take over one hour will |
||||||||||||||
| be migrated to
background |
|||||||||||||||
| • | Report Users |
||||||||||||||
| – | Up to 20% of
the CPU resources |
||||||||||||||
| – | No parallelism |
||||||||||||||
| – | Limit of 40
concurrent queries |
||||||||||||||
| – | Any query
which is expected to take over 20 minutes will |
||||||||||||||
| be aborted |
|||||||||||||||
| • | Background
Jobs |
||||||||||||||
| – | Up to 10% of
the CPU resources |
||||||||||||||
| – | Any degree of
parallelism |
||||||||||||||
| – | Limit of 5
concurrent queries |
||||||||||||||