SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,778 questions
Hello I am facing a deadlock in sql server, please can anyone help?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Sameer Thakur
0
Reputation points
Hello I am facing a deadlock in sql server, please can anyone help?
{count} votes
-
Viorel 112.5K Reputation points2023-04-09T04:53:43.0133333+00:00 Perhaps you can repeat the operation (in SQL or on client side: https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms177453(v=sql.90)).
-
Erland Sommarskog 101.4K Reputation points MVP2023-04-09T10:43:20.4266667+00:00 We might be able to help you if provide sufficient information. Important when you deal with deadlocks is to get hold of the deadlock XML which gives the details of the deadlock. You can retrieve information about recent deadlocks on your instance with this query:
; WITH CTE AS ( SELECT CAST(event_data AS xml) AS xml, timestamp_utc FROM sys.fn_xe_file_target_read_file( N'system_health*.xel', DEFAULT, DEFAULT, DEFAULT) WHERE object_name = 'xml_deadlock_report' ) SELECT xml.query('/event/data[1]/value[1]/deadlock[1]'), timestamp_utc FROM CTE ORDER BY timestamp_utc DESCYou will need to open the XML to verify that the XML to verify that this is the very deadlock you are having problem with. The query above requires SQL 2017 or later. On older versions, use this query instead:
; WITH CTE AS ( SELECT CAST(event_data AS xml) AS xml FROM sys.fn_xe_file_target_read_file( N'system_health*.xel', DEFAULT, DEFAULT, DEFAULT) WHERE object_name = 'xml_deadlock_report' ) SELECT xml.query('/event/data[1]/value[1]/deadlock[1]'), xml.value('/event[1]/@timestamp', 'datetime2(3)') AS timestamp_utc FROM CTE ORDER BY timestamp_utc DESC -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,441 Reputation points2023-04-10T05:50:56.26+00:00 Hi @Sameer Thakur, In order to better solve your problem, you need to provide more description of your problem.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT 26,316 Reputation points Microsoft Employee2023-04-12T15:49:53.0233333+00:00 Hello Sameer Thakur, I am checking to see if you need any further help here.
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
goncaloperes 0 Reputation points2023-05-25T13:44:04.34+00:00 Without further specifics, I can only supply you with additional resources. Please check if they are helpful.
Sign in to comment
100 answers
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted comment
Comments have been turned off. Learn more
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more