摘要: (转)以备不时之需最耗时的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 阅读全文
posted @ 2013-09-25 16:42 IT高薪猎头 阅读(615) 评论(0) 推荐(0) 编辑