Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • RE: Lock Escalation in Sql Server 2014

    Alexander Suprun (9/8/2014)


    skavijay (9/5/2014)


    I do experiencing dead-locks in this process and resolving it by handling it as and when it comes.

    I assume that you are talking about blocking not dead-locks,...

  • RE: Lock Escalation in Sql Server 2014

    Hi after been experiencing good number of times I did handling in C# code when the dead lock error number comes then aborting and retrying again 🙂

    But after knowing this...

  • RE: Lock Escalation in Sql Server 2014

    "It" means the lock_Escalation option and would want to set Disable for my new database and for the table that is being used by all modules.

  • RE: Lock Escalation in Sql Server 2014

    Hi

    Thank you for reply.

    So the table still be part of transaction and dead lock might occur is that what would you say even after disabling it?

Viewing 4 posts - 1 through 5 (of 5 total)