Blog Post

SQL Server Blog
2 MIN READ

How It Works: SQL Server Locking WAIT_WITH_LOW_PRIORITY

BobDorr's avatar
BobDorr
Icon for Microsoft rankMicrosoft
Feb 06, 2022
  Move from: bobsql.com   I received a question from Jonathan as he read over prior posts on locking and I cannot take credit for the question nor the answer, just being the middle man for th...
Updated Feb 06, 2022
Version 1.0
bobsql
Zikato's avatar
Zikato
Copper Contributor
May 11, 2023

What would happen if after cycling back to partition 0, we couldn't acquire a lock on any of the 0 - 3 partitions?
Would it release the locks on portions 4 - X and start the cycle all over again?