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.

I have my code running online shared hosting provider. Recently I am seeing too many deadlock exception is being thrown. As you know that shared hosting uses the same database server to host all the databases, I am thinking does other database is running in same server blocking the resource that required for my database query to run. It sounds like stupid. But I have little knowledge on this matter. We are using MS-SQL server2005 and application written in .net framework 2.0. I am not sure about the Windows Server running.

I hope I had enough information here. Please let me know if you need more information.

Does deadlock occurs between two or more databases?

share|improve this question
add comment

1 Answer 1

up vote 4 down vote accepted

If you are only accessing your database, it is highly unlikely that deadlocks you are experiencing are caused by other customers that happen to have their database on the same server - they'd have to be intentionally crossing database boundaries with transactions, and they'd most certainly not have the ability to do that. However we need a lot more information about what kind of deadlocks you are seeing, as they could involve system objects, etc. Are the objects involved only in your database? Have you looked at the deadlock graphs at all, or are you just responding to "deadlock victim" messages? Lots of info in this StackOverflow question about interpreting deadlocks, but you need to capture the graph using Profiler or some kind of monitoring tool (for which you may need to ask the host's assistance).

share|improve this answer
    
I have posted this question based on the exception messages in my application. I do not have deadlock graph at this moment. As you said highly unlikely, I would mark this answered. When I get more information, I will post another question. –  Amzi Feb 25 '12 at 18:07
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.