본문 바로가기
MS-SQL

MS-SQL 부하쿼리

by 호야호잇 2020. 9. 23.

SELECT TOP 100 (A.TOTAL_WORKER_TIME/A.EXECUTION_COUNT) AS [AVG_CPU_TIME] , CONVERT(VARCHAR, LAST_EXECUTION_TIME) AS 'LAST_EXECUTION_TIME', TOTAL_PHYSICAL_READS, SUBSTRING(B.TEXT, A.STATEMENT_START_OFFSET/2,(CASE WHEN A.STATEMENT_END_OFFSET = -1 THEN LEN(CONVERT(NVARCHAR(MAX), B.TEXT)) *2 ELSE A.STATEMENT_END_OFFSET END - A.STATEMENT_START_OFFSET)/2) AS QUERY_TEXT , DBNAME = UPPER(DB_NAME(B.DBID)) , B.OBJECTID AS 'OBJECT_ID' FROM SYS.DM_EXEC_QUERY_STATS A CROSS APPLY SYS.DM_EXEC_SQL_TEXT(A.SQL_HANDLE) AS B ORDER BY [AVG_CPU_TIME] DESC

'MS-SQL' 카테고리의 다른 글

조건절 LIKE 검색 조건(기호 인식)  (0) 2020.07.28
[MSSQL] [DMV] 비용이 드는 쿼리 찾아내기  (0) 2020.03.20
MS-SQL 쿼리팁  (0) 2020.03.13
특정문자 (') 치환법  (0) 2019.12.13
SQL 팁  (0) 2019.11.21