How can your resolve deadlocks?
- 4 Answers
- 14469 Views
- IBM, IMS, Iron Mountain, NuWare, I also Faced
- E-Mail Answers
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 do you mean by table and field in sql?
How many types of the database links?
What is 1nf normalization form?
Can you get second highest salary from the table?
How to Check if table exists in sql server?
Different types of keys in SQL?
How can you hide the sql server instances?
What is transaction server implicit?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What are the aggregate and scalar functions?
What is a collation?
Why is the need for data conversion transformations?
How to sort the query output with order by clauses in ms sql server?
What is dynamic cursor in SQL SERVER?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
