1. SQL Server Error Log 또는 Deadlock Graph 확인 SQL Server는 Deadlock 발생 시 해당 정보를 SQL Server Error Log나 Extended Events, Trace, System Health Session등에 기록합니다. ✅ 방법 A: 시스템 헬스 세션(System Health Session)에서 확인 SELECT XEvent.value(‘(event/data[@name=”resource”]/value)[1]’, ‘VARCHAR(MAX)’) AS Resource, XEvent.value(‘(event/data[@name=”objectname”]/value)[1]’, ‘VARCHAR(MAX)’) AS ObjectName, XEvent.value(‘(event/data[@name=”database_name”]/value)[1]’, ‘VARCHAR(MAX)’) AS DatabaseName, XEvent.value(‘(event/action[@name=”sql_text”]/value)[1]’, ‘VARCHAR(MAX)’) AS SQLText, XEvent.value(‘(event/data[@name=”transactionname”]/value)[1]’, ‘VARCHAR(MAX)’) AS TransactionName, DeadlockGraph FROM (… Read More »