개발 참고자료

SELECT sqltext.TEXT
, req.session_id
, req.status
, req.command
, req.cpu_time
, req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

/**********************************************************************************/
아래 쿼리 실행하면 느린쿼리 잘 나옴....

SELECT dm_ws.wait_duration_ms 실행대기시간
, dm_ws.wait_type 대기형태
, dm_es.status 실행상태
, dm_t.TEXT 실행쿼리
, dm_qp.query_plan 실행계획
, dm_ws.session_ID 세션아이디
, dm_es.cpu_time
, dm_es.memory_usage
, dm_es.logical_reads 논리적읽기
, dm_es.total_elapsed_time 총실행시간
, dm_es.program_name
, DB_NAME(dm_r.database_id) DB명
,
--Optional columns
dm_ws.blocking_session_id blk
, dm_r.wait_resource
, dm_es.login_name
, dm_r.command
, dm_r.last_wait_type
FROM sys.dm_os_waiting_tasks dm_ws
INNER JOIN sys.dm_exec_requests dm_r ON dm_ws.session_id = dm_r.session_id
INNER JOIN sys.dm_exec_sessions dm_es ON dm_es.session_id = dm_r.session_id CROSS APPLY sys.dm_exec_sql_text ( dm_r.sql_handle ) dm_t
CROSS APPLY sys.dm_exec_query_plan ( dm_r.plan_handle ) dm_qp
WHERE dm_es.is_user_process = 1
--AND DB_NAME(dm_r.database_id) = 'limc'

메모리 조정 참조 : https://iseogs.tistory.com/181