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 쿼리팁 (1) | 2020.03.13 |
특정문자 (') 치환법 (0) | 2019.12.13 |
SQL 팁 (0) | 2019.11.21 |