The QryLogSummaryV view of DBQLSummaryTbl holds the counts logged for queries of users with THRESHOLD or SUMMARY rules. It is only populated if summary information is requested or a threshold value is used.
Possible Values for ValueType
The THRESHOLD criterion is as follows:
Value | Description |
---|---|
C | AMP CPU seconds. |
H | Elapsed hundredths of a second. |
I | I/O count. |
N | Normalized AMP CPU seconds. |
S | Elapsed time in seconds. |
LowHist and HighHist
Value | Description |
---|---|
HighHist |
|
LowHist |
|
For the SUMMARY case, a row exists for each collection if the count of the queries run in that time frame (LowHist to HighHist) is greater than 0.
For the THRESHOLD case, one row (with LowHist=TypeofCriterion and HighHist=0) exists for the collection if there were queries shorter than LowHist seconds.