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
How to delete duplicate rows from table except one?
How to access the deleted record of an event?
How do you debug a procedure in sql server?
How does clustered and non clustered index work?
What the different components in replication and what is their use?
how would you store your query in an SSRS report or a Database server?
What is difference between line feed ( ) and carriage return ( )?
What is nolock?
How to resolve the orphan use problem? : sql server security
What are ddl (data definition language) statements for tables in ms sql server?
What is etl - extraction, transformation, and loading?
Does a server store data?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Does windows server 2016 come with sql server?
what are the Prerequisites for Replication?