How can your resolve deadlocks?
Answer Posted / xavier rajan, photon infotech
A deadlock occurs when two or more
processes try to access a resource that another process has
a lock on. Microsoft SQL Server automatically
detects these deadlocks, terminates one of the processes,
and rolls back any changes made by that process.
The process chosen for termination will be the one with the
least amount of active time on the server. In
most cases, you can simply reissue the statements that were
rolled back and should have no problems.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a partition key?
How to store and query spatial data?
Do you know what is a trace frag? Where do we use it?
What is sql server profiler trace data file?
What is subquery in sql?
Name few endpoints exposed by ssrs 2012?
What does sql server mean?
What are drilldown reports?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How many columns can exist together per table?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is a fan-out query in SQL Azure?
What are the different types of sub-queries?
What are “lost updates”?
how to overcome kernel isssues