Archives of the TeradataForum
Message Posted: Wed, 07 Feb 2007 @ 12:30:46 GMT
RESUSAGE has a lot of great information up to a point. However it does not have anything at a session level. Depending on account string expansion you can get some of this information from AMPUSAGE. For minute by minute session activity nothing beats having PMON information IMHO.
We have a daily report with RESUSAGE info showing high level what occurred on the system the previous day (Avg/Max CPU busy, OS%Cpu, AvgCPUBusyvsIOWait, IOWaitvsDiskIO, Paging&MemoryAllocationFails, Avg/MinFreeMemoryAvailable, Qlength, etc). None of it tells you what session\user was working during that time to account for that activity. PMON info does....
Depending on how you have DBQL setup it may also tell you the historical information that you need. However, this is not as easy as having PMON info recorded minute by minute....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|