Hi Experts .
Database is facing frequent DEADLOCKs which is not good for system performance. I did not take any action (because, I assumed there are some maintenance activity also can produce that kind of error) but I waited for some evidence.
Now tonight I find a DEADLOCK appeared in Database. Its been 4yrs but this dead locki have never seen.
Also I would like to quote
Could you please tell me, how can i check what "row Versioning" on MS SQL database is there? If we turn on row versioning on database , can it help to reduce the DEADLOCK issue.
How do i check the isolation level on the database, .Thanks in advance.