Nick Kewney

Software Architect & Product Builder

Recent Posts

T-SQL script for identifying deadlocked processes

A useful script for identifying SQL deadlock cause/victim. WITH [Blocking] AS (SELECT w.[session_id] ,s.[original_login_name] ,s.[login_name] ,w.[wait_duration_ms] ,w.[wait_type] ,r.[status] ,r.[wait_resource] ,w.[resource_description] ,s.[program_name] ,w.[blocking_session_id] ,s.[host_name] ,r.[command] ,r.[percent_complete]

Read More »