|
|
Archives of the TeradataForum
Message Posted: Tue, 22 Nov 2005 @ 18:16:18 GMT
Subj: | | Re: Excessive Delays between DBQLogTbl's StartTime and FirstStepTime |
|
From: | | Ballinger, Carrie |
Can I expand this point from my previous email slightly?
| In your case, after the upgrade, the DBQL cache was initialized at system startup, so the collectstamps for all entries in that first cache
will be the time the system became active, not the time the user queries were actually executed. | |
To be more accurate, DBQL caches are actually initialized at NODE startup, not system startup. I am assuming that is why, Mark, you had light
differences in collecttimestamps in your sample, 1 second or so apart.
Thanks, -Carrie
| |