Answers

Question and Answer:

  Home  MS SQL Server Locks

⟩ Explain optimistic and pessimistic concurrency?

Optimistic concurrency: - Assumes that a resource is likely to be available at all times. This means that resource locking is very unlikely. If a conflict occurs, the application must read the data and attempt the change again.

Pessimistic concurrency : - this locks the resources as and when required. A transaction can be assured to be completed unless a deadlock occurs

 171 views

More Questions for you: