Created
January 8, 2017 12:36
-
-
Save lisysolution/a10739c88c6af8b07e55ea973908b4f7 to your computer and use it in GitHub Desktop.
SQL Server에서 CPU 사용율이 높은 쿼리 검색
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT TOP 20 | |
[Average CPU used] = total_worker_time / qs.execution_count, | |
[Total CPU used] = total_worker_time, | |
[Last CPU used] = last_worker_time, | |
[MAX CPU used] = max_worker_time, | |
[Execution count] = qs.execution_count, | |
[Individual Query] = | |
SUBSTRING(qt.text, | |
qs.statement_start_offset/2, | |
(CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2), | |
[Query] = qt.text, | |
DatabaseName = DB_NAME(qt.dbid), | |
qs.creation_time, | |
qs.last_execution_time | |
FROM | |
sys.dm_exec_query_stats qs | |
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt | |
ORDER BY | |
[Average CPU used] DESC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment