Page level locking in SQL Server

Stephen West ~ Modified: March 5th, 2016 ~ ~ 1 Minute Reading

This topic has 2 replies, 2 voices, and was last updated 9 years, 1 month ago by Stephen West.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
March 7, 2016 at 11:39 am #1477 Score: 0
Lincoln Burrows
Moderator

Karma: 16 pts
You can enable page level locking with the help of SSMS and TSQL.
1. Go to the Index Properties and select the check box Use page locks when accessing the index as highlighted and then save the changes before rebuilding the index. OR
2. Enable page level locking on index using TSQL command
```
ALTER INDEX <index name> ON <table name> SET (ALLOW_PAGE_LOCKS = ON)
GO
```
March 8, 2016 at 6:05 am #1486 Score: 0

Stephen West
Moderator

Karma: 4 pts

Thanks for a warm reply.
Please tell me the things, that we should care when we are performing a page level locking in SQL Server.
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.