All Forums Analytics
Random_Thought 70 posts Joined 06/09
02 Jul 2009
Another Question regarding DBC.AMPUSAGE

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

dnoeth 683 posts Joined 11/04
02 Jul 2009

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

You must sign in to leave a comment.