Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 07 Feb 2007 @ 12:30:46 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020