鸽子飞扬

摘要： （转）以备不时之需最耗时的sqldeclare @n intset @n=500 ;with cte1 as(select a.*,t.*from sys.dm_exec_query_stats across apply sys.dm_exec_sql_text(a.plan_handle) twhere t.dbid >= 5)selectt.dbid,db_name(t.dbid) as dbname,a.total_worker_time,a.avg_time_ms,a.execution_count,a.cache_count,replace(replace(t.text,CHA 阅读全文