Solution : https://service.sap.com/sap/support/notes/32129 (SAP Service marketplace login required)
Summary :
This SAP Note outlines procedures to analyze SQL Server deadlocks, occurring when multiple database processes mutually block each other, often because of application-level lock conflicts. Deadlocks are automatically resolved by terminating one process, resulting in a SQL error 1205. Techniques for investigating these deadlocks include using a deadlock profiler trace for SQL Server 2005 and newer, as well as logging in the SQL error log with trace flags (1204, 3605, 1222) for more detailed analysis. Additionally, ABAP system logs provide information on terminated processes, but not a comprehensive deadlock analysis. The note also includes instructions on configuring SQL Server to automatically log deadlocks and manage trace files.
Key words :
\program files\microsoft sql server\mssql, deadlock<version>_<date>-<time>, sap system automatically set trace flags 1204, deadlock concerns key locks, deadlock concerns page locks, attached sql script sap_deadlock_trace, sql server management studio, sql server configuration manager, sql server enterprise manager, sql server query analyzer
Related Notes :
709262 | Deadlock trigger eliminated. |