How to get CPU for aborted session

Database

How to get CPU for aborted session

Hi,

 

If a SQL / Session is aborted then the DBQLogTbl doesnt capture the actual CPU consumed by the request before it was aborted.

If I want to find out the CPU of aborted sessions, is there a place i can quey and get that information ?

 

Thanks !

4 REPLIES
Enthusiast

Re: How to get CPU for aborted session

DBQL holds CPU consumption of the queryid upto the step prior to when the query was aborted. You have to use monitorsession APIs that capture CPU usage at a 10 minute interval to arrive at lost CPU numbers.

Re: How to get CPU for aborted session

Hi,

 

Thanks for info, however I am not aware of monitorsession API , do you havemore infomraton on that?

Junior Contributor

Re: How to get CPU for aborted session

Since TD14.10 there's a new algorithm (DBQLogTbl.DataCollectAlg = 3) which includes data for aborted steps.

But it must be enabled explicitly (either using dbscontrol or using BEGIN QUERY LOGGING).

Teradata Employee

Re: How to get CPU for aborted session

And information about MonitorSession and other Performance Monitor functions is found in the "Application Programming Reference" manual.