1211* 停止锁定扩大(lock escalation)。SQL Server 资料库引擎(Database Engine)不会 将资料列或页面锁定扩大到资料表锁定。
基于20个网页-相关网页
If not, lock escalation continues until the percentage of the lock list held is below the value of MAXLOCKS.
否则,锁升级就会一直进行,直到所持有的锁列表百分比低于MAXLOCKS。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
如果用一个表锁替换这些行锁,将不再会超出maxlocks值,那么锁升级就会停止。
MAXLOCKS defines a percentage of the lock list held by an application that must be filled before the database manager performs lock escalation.
MAXLOCKS定义了应用程序持有的锁列表的百分比,在数据库管理器执行锁升级之前必须填充该锁列表。
应用推荐