푸팟퐁쿼리

인스턴스의 캐시에 올라와있는 쿼리 중 비용을 많이 소비하고 있는 쿼리를 뽑는 쿼리입니다. 장애 상황에서 제일 문제되는 쿼리를 뽑을 때 사용할 수 있습니다. SELECT TOP 300 db_name(execText.dbid) AS dbName ,execution_count AS execCnt ,(total_worker_time / execution_count) / 1000 AS avgCPU ,(total_elapsed_time / execution_count) / 1000 AS avgDuration , total_logical_reads / execution_count AS avgReads , max_worker_time AS maxCPU , max_elapsed_time AS maxDuration , m..

SELECT TOP 50 query_stats.query_hash AS 'Query Hash', SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS 'Avg CPU Time', SUM(query_stats.total_logical_reads) / SUM(query_stats.execution_count) AS 'Avg logical Read', SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS 'Avg Worker time', MIN(query_stats.statement_text) AS 'Statement Text', MIN(DB_NAME(que..