Interested to Buy Any Domain ? << Click Here >> for more details...
How can your resolve deadlocks?
- 4 Answers
- 15283 Views
- IBM, IMS, Iron Mountain, NuWare, I also Faced
- E-Mail Answers
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 sqlcmd?
What is abstracting periodical?
What is ms sql server index?
How to return the second 5 rows in ms sql server?
What does asynchronous call backs means?
How to create an index on an existing table in ms sql server?
Can the “if update (colname)” statement be used in a delete trigger?
What is auditing in sql server?
What are the restraints imposed on the table design by a merge replication?
Why use sub query in sql server and list out types of sub queries?
How many tables can be joined in SQL Server?
Explain mixed authentication mode of sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Are resultset updatable?
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 ?
