Calculate AMPs used by a query

Database

Calculate AMPs used by a query

Hi Gurus,
I'm trying to figure out how many AMPs are being used by queries on daily basis. My ultimate goal is to create a report of ALL queries that used all the AMPs available. Is there any way we can do it using pmcpinfo or dbc?
- Rahul
Tags (2)
2 REPLIES
Junior Contributor

Re: Calculate AMPs used by a query

Hi Rahul,
in dbc.qrylog there's NumOfActiveAMPs.

Based on that it's easy to find out which queries used all AMPs:
WHERE NumOfActiveAMPs = HASHAMP()+1

Dieter
Enthusiast

Re: Calculate AMPs used by a query

Thanks Dieter.