Use this query to list the indexes with page file locking disabled: SELECT * FROM sys.indexes WHERE allow_page_locks = 0 As for the other stuff I've seen people elsewhere mention that they would add steps to enable then disable page file locking when doing a REORGANIZE: ALTER INDEX < INDEX_NAME > ON < TABLE_NAME> SET (ALLOW_PAGE_LOCKS = ON)
