MSSQL 썸네일형 리스트형 [MS-SQL] 쿼리 튜닝 참조 자료 참조 쿼리 하단 참조. 파일 다운로드 Top 20 Executed Queries;with frequent_queries as ( select top 20 query_hash, sum(execution_count) executions from sys.dm_exec_query_stats where query_hash 0x0 group by query_hash order by sum(execution_count) desc ) select @@servername as server_name, coalesce(db_name(st.dbid), db_name(cast(pa.value AS INT)), 'Resource') AS [DatabaseName], coalesce(object_name(ST.objectid, S.. 더보기 이전 1 다음