mssql 비용이 많이드는 쿼리 검색
sys.dm_exec_query_stats(Transact-SQL) 참고 https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=KO-KR&k=k(DM_EXEC_QUERY_STATS_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true SELECT SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, (( CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END - qs.statement_start_o..
DataBase/SQL Server
2021. 1. 4. 16:08
