All Forums Database
rahulraj 1 post Joined 03/10
09 Mar 2010
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

dnoeth 4628 posts Joined 11/04
09 Mar 2010

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

Dieter

Smarak0604 3 posts Joined 08/12
26 Dec 2012

Thanks Dieter.

You must sign in to leave a comment.