Another Question regarding DBC.AMPUSAGE
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Another Question regarding DBC.AMPUSAGE Expand / Collapse
Author
Message
Posted 7/2/2009 10:52:21 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 9/10/2009 6:25:29 AM
Posts: 16, Visits: 74
When usage is logged in AMPUSAGE, and we include the &D&H in the Account name, does the CPU and Disk IO get logged against multiple Days and Hours if the same unit of work spans that far?

IE if I run a query that runs for 7 hours at 9 am, does it log an entry just for the 09070209 or 7 entries showing the CPU and disk io for those hours?

Random
Post #16004
Posted 7/2/2009 1:39:13 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:40:02 PM
Posts: 717, Visits: 466
The account string is expanded once when a query starts.
So it's just one row with the start date/hour and accumulated cpu/io.

Dieter
Post #16016
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 6:46pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.078. 7 queries. Compression Disabled.