Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Sunday, November 3, 2013

Guidelines for minimizing Deadlocks in SQL Server


  • User resources in the  same sequence in all transactions
  • Shorten transactions by minimizing the number of  steps.
  • Shorten transaction times by  avoiding queries that affect many rows.
  • Set the DEADLOCK_PRIORITY setting to low.

No comments:

Post a Comment