How can your resolve deadlocks?
Answer Posted / darshan
Hi
1)
First find out which process block the other process from
activity monitor or sp_who2. Then kill that process.
2)
If update locks are more then it will make deadlock. So
reduce that.
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the source of constraints?
What is the difference between local and global temporary tables?
What is the purpose of the master database?
What is the purpose of optimization?
Explain how to integrate the ssrs reports in application?
what are database files and filegroups? : Sql server database administration
What are subqueries in sql server? Explain its properties.
Tell me what is fill factor?
What is the full form of dql?
Can We Use Data-grids For Our Report In Ssrs?
explain databases and sql server databases architecture? : Sql server database administration
What do you understand by SQL*Net?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Explain different types of index?
How to get the definition of a trigger back?