Archives of the TeradataForum
Message Posted: Wed, 07 Feb 2007 @ 12:30:46 GMT
Subj: | | Re: PMON data tables |
|
From: | | Sanchez, Idrike |
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....
Kiki Sanchez
Data Warehouse Group
Technology Division
Continental Airlines
|