Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We are having issues with deadlocks and I am trying to isolate what database object is causing the problem.

I found Deadlock error isn't returning the deadlock SQL to be very helpful and I read through a lot of the MSDN stuff. I set up a trace and now have a deadlock graph but I am having a hard time reading it. I know it's a page lock, and in the page lock box on the graph I have a DB_ID (great! told me the database), File ID, Page ID, and associated objid. I can't seem to use these IDs to dig any deeper.

My sense is that simple SELECT queries are getting victimized by our replication process (as appropriate), but I need to know the specifics in order to fix the problem - the majority of our queries relies upon views that may need to be modified.

EDIT: I should have kept looking... SQL Server Deadlock Graph - Table, Page or Row Lock? may solve my issue. I'm going to continue to work on it - and might remove this question...

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.