摘要：查看被缓存的查询计划 SETTRANSACTIONISOLATIONLEVELREADUNCOMMITTEDSELECTTOP20st.textAS[SQL],cp.cacheobjtype,cp.objtype,COALESCE(DB_NAME(st.dbid),DB_NAME(CAST(pa.valueASINT))+'*','Resource')AS[DatabaseName],cp.usecountsAS[Planusage],qp.query_planFROMsys.dm_exec_cached_planscpCROSSAPPLYsys.dm_exec 阅读全文