![]() |
When comparing CPU consumption time between DBQLogTbl.AMPCPUTime and DBC.Acctg against User/Hour/Day, we notice difference in CPU time recorded. Sometime a net difference of 1-2% recorded high or less in Acctg when compared to DBQL.
06 Feb 2014
| 1 comment
,
|
![]() |
Hi, I have put together a dashboard showing all the AMPCPUTime consumed by our various workloads based on the data from the DBQL LOG table column, AMPCPUTime. I want to add the Idle time into this so that management get an accurate picture of what is going on the system.
01 Jan 2014
| 1 comment
,
|
![]() |
Hello,
05 May 2013
| 1 comment
,
|
![]() |
Hi experts, I understand that the CPU utilized by a query can be determined by adding AMPCPUTime and ParserCPUTime. If I get a value of 100 does this mean that the CPU was processing the query for 100 seconds? Or is the number represented in some other unit?
13 Sep 2011
| 4 comments
,
|
![]() |
According to my understanding, the value returned by subtracting StartTime from FirstRespTime should be equal to AMPCpuTime. But this doesnt seem to work. Can anyone please help me understand how are all these values related/calculated?
08 Jun 2010
| 4 comments
,
|