Resource Pool Usage History (v11.1)

Check out the history tables such as:
dc_resource_pool_status_by_minute
You can list all history tables by running:
select * from data_collector order by table_name;

@Bryan_H said:
Check out the history tables such as:
dc_resource_pool_status_by_minute
You can list all history tables by running:
select * from data_collector order by table_name;

Hi Bryan_H, I've been looking at the dc_resource_pool_status_by_minute, but there is no column that looks like it contains anything that's 'inuse'.

I usually check reserved memory/queries as "in use". Here's a sample query I run to find maximum reserved memory compared to concurrency in resource pools:
select pool_name,reserved_queries_max_value,max(reserved_memory_kb_max_value) as memoryKB,count(*) as minutes from dc_resource_pool_status_by_minute
where date(start_time) = current_date
group by 1,2 order by 1 asc,2 desc;

Thanks Bryan_H, I'm guessing that reserved_memory_kb_max_value is a good indicator for "in use", so will use that.