April 4, 2011 at 2:15 pm
Hello, I found a deadlock on the database, how can I find out what is objectid and how to fix this lock? Thank you
process dbid: 47, object id: 72057594107920384, index id: (e10026cad67b) DELETE Line #: 187
193
RPC Event: Proc [Database Id = 47 Object Id = 382624406]
dbid: 47, object id: 72057594107920384, index id: (3b0177f0a8db) UPDATE
April 5, 2011 at 5:29 am
With just that information, you can't. You need to have trace flag 1222 enabled and then a full set of information about the deadlock, including both the victim and the survivor, will be displayed in the error log and you can interpret that information to figure out why you had a deadlock.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 5, 2011 at 6:36 am
Will this trace slow down performance.This is production server.
Thank you
April 5, 2011 at 6:46 am
It's not a trace. It's a traceflag. Totally different issue. No. It won't affect performance. You need it to understand deadlocks, otherwise you're just guessing. Here's the BOL entry on setting traceflags
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply