mc-activity-query monitoring-running queries-memory column
Posted: Thu May 19, 2016 11:30 am
Hi,
I have the following situation:
- resource pool configured to use max 25 G memory
create resource pool xxxx_pool
memorysize '30%'
maxmemorysize '95%'
priority 100
runtimepriority MEDIUM
runtimeprioritythreshold 30
queuetimeout 120
runtimecap '10 seconds'
cascade to general
- 6 SELECTs running, that has associated 2.5 GB memory in column Memory(MB) = 15 GB
activity-query monitoring-running queries- total memory reserved = 15 GB
- in the tab 'Queued Queries' there are 4 queries that have , in column Avg Memory Reserved, 2.5 GB
- in mc-activity-resource pool monitoring-resource usage per pool -xxxx_pool
maximum memory size = 25 GB
average free memory - during the process - 25G decreased to 2G increased to 25 GB
- the system memory is used 30%
- part of them crashed due to:
1. Execution time exceeded run time cap of 00:00:10
2. Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 2732190, Free = 1270742 (Limit = 17831818, Used = 16561076) (queueing threshold)]
I don't understand why the entire memory can't be used by the queued queries.
How can I see information about allocated/reserved memory for each resource pool ? seems to be different.
What is the algorithm used for allocation/reservation of memory ?
Thank you
I have the following situation:
- resource pool configured to use max 25 G memory
create resource pool xxxx_pool
memorysize '30%'
maxmemorysize '95%'
priority 100
runtimepriority MEDIUM
runtimeprioritythreshold 30
queuetimeout 120
runtimecap '10 seconds'
cascade to general
- 6 SELECTs running, that has associated 2.5 GB memory in column Memory(MB) = 15 GB
activity-query monitoring-running queries- total memory reserved = 15 GB
- in the tab 'Queued Queries' there are 4 queries that have , in column Avg Memory Reserved, 2.5 GB
- in mc-activity-resource pool monitoring-resource usage per pool -xxxx_pool
maximum memory size = 25 GB
average free memory - during the process - 25G decreased to 2G increased to 25 GB
- the system memory is used 30%
- part of them crashed due to:
1. Execution time exceeded run time cap of 00:00:10
2. Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 2732190, Free = 1270742 (Limit = 17831818, Used = 16561076) (queueing threshold)]
I don't understand why the entire memory can't be used by the queued queries.
How can I see information about allocated/reserved memory for each resource pool ? seems to be different.
What is the algorithm used for allocation/reservation of memory ?
Thank you