SQL Server Select Locks to add

1.

Database-level shared locks to prevent others from deleting this database.

2.

The intent shared lock on the table to prevent others from modifying the definition of the table.

3.

Add intent to share the lock on the page.

4.

A shared lock is added to each row read.

5.

If an index is used, a shared lock is added to the key value for each index.

6.

If it is a heap table, a shared lock is to be added to the RID.

--------------------------------------------------------------------------------------------------------------- ---------------------------------------

Ways to Reduce locks:

1. Try to return a small result set

2. Try to use Index seek

SQL Server Select Locks to add