The following SELECT statement retrieves the QryLogTDWMSum view:
SELECT * from DBC.QryLogTDWMSum;
The query returns the following result:
ProcID 30718 CollectTimeStamp 2013-12-16 16:52:33 WDID 12 OpEnvID 1 SysConID 1 StartColTime 2013-12-16 16:52:33.130000 Arrivals 4 ActiveCount 0 Completions 4 MinRespTime .01 MaxRespTime .13 AvgRespTime .05 MinCPUTime .27 MaxCPUTime 4.04 AvgCPUTime 1.61 DelayedCount 0 AvgDelayTime 0 ExceptionAbCount 0 ExceptionMvCount 0 ExceptionCoCount 0 ExceptionCount 0 MetSLGCount 4 AbortCount 0 ErrorCount 0 RejectedCount 0 MovedInCount 0 IntervalDelayCnt 0 DelayedQueries 0 OtherCount 0 VirtualPartNum 1 AvgIOWaitTime 0 MaxIOWaitTime 0 AvgOtherWaitTime 1 MaxOtherWaitTime 3 AvgCPURunDelay 0 MaxCPURunDelay 0 AvgSeqRespTime 0 MaxSeqRespTime 0 AvgLogicalIO 125 MaxLogicalIO 259 AvgLogicalKBs 5,705 MaxLogicalKBs 12,640 AvgPhysicalIO 2 MaxPhysicalIO 6 AvgPhysicalKBs 62 MaxPhysicalKBs 248 ThrottleBypassed 0