Few More Queries
--Check query Performance SEL TOP 5 QueryId , cast ( QUERYTEXT as varchar ( 5000 )) , ElapsedTime , MaxAMPCPUTime , AMPCPUTime , MaxAmpCpuTime * NumOfActiveAmps ,( MaxAmpCpuTime - ( 1.00 * AmpCpuTime )/ NumOfActiveAmps ) ,( 1 -( 1.00 * AmpCpuTime /( MaxAmpCpuTime * NumOfActiveAmps )))* 100 ,( MaxAmpCpuTime * NumOfActiveAmps )/( AmpCpuTime ) FROM DBC . QRYLOG WHERE MAXAMPCPUTIME > 100 ; -- Query...