SP 모니터링 썸네일형 리스트형 [DB] MSSQL 2005 저장프로시져 모니터하기 -- 1.저장프로시져별 실행수 뽑기 select db_name(st.dbid) DBName,object_schema_name(st.objectid,dbid) SchemaName,object_name(st.objectid,dbid) StoredProcedure,sum(qs.execution_count) Execution_countfrom sys.dm_exec_cached_plans cpjoin sys.dm_exec_query_stats qs on cp.plan_handle=qs.plan_handlecross apply sys.dm_exec_sql_text(cp.plan_handle)stwhere DB_Name(st.dbid) is not null and cp.objtype = 'proc'group by D.. 더보기 이전 1 다음