Answers

Question and Answer:

  Home  SQL Server Optimization

⟩ What is Shared lock?

Shared Lock allows simultaneous access of record by multiple Select statements.

Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading.

If update process is going on then read command will have to wait until updating process finishes.

 179 views

More Questions for you: