ECTPARSING_USER_IDEXECUTIONSSORTSCOMMAND_TYPEDISK_READSSQL_TEXTFROMVSQLAREAORDERBYDISK_READSDESCWHEREROWNUM10复制代码44等待时间最多的5个系统等待事件的获取
SELECTFROMSELECTFROMVSYSTEM_EVENTWHEREEVENTNOTLIKESQLORDERBYTOTAL_WAITSDESCWHEREROWNUM5
45检查运行很久的SQL
复制代码COLUMNUSERNAMEFORMATA12
COLUMNOPNAMEFORMATA16
COLUMNPROGRESSFORMATA8
SELECTUSERNAMESIDOPNAMEROUNDSOFAR100TOTALWORK0ASPROGRESSTIME_REMAININGSQL_TEXT
FROMVSESSION_LONGOPSVSQLWHERETIME_REMAINING0
ANDSQL_ADDRESSADDRESSANDSQL_HASH_VALUEHASH_VALUE复制代码
f46检查消耗CPU最高的进程
复制代码SETLINE240
SETVERIFYOFF
COLUMNSIDFORMAT999
COLUMNPIDFORMAT999
COLUMNS_FORMAT999
COLUMNUSERNAMEFORMATA9HEADING