Resource Pool Usage History (v11.1)

bmurrell

Hi all

I'm looking at resource_pool_status, and use (memory_inuse_kb/memory_size_actual_kb)*100 to determine the % Used for each pool.
I'm trying to get the history for this, so looking at dc_resource_pool_status%. However, these columns don't exist and I can't determine how to get this historically?
Any help would be appreciated.

Thanks

Bryan_H

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;

bmurrell

@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'.

Bryan_H

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;

bmurrell

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