如果用一个表锁替换这些行锁,将不再会超出maxlocks值,那么锁升级就会停止。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
锁定问题通常表明应用程序中存在一些相当严重的并发性问题,在增大锁列表参数的值之前应当解决这些问题。
The locking problems normally indicate some fairly significant concurrency problems in the application that should be dealt with before the lock list parameter is increased.
要完全控制配置,可以在模式中指定一些配置值并在参数上使用“锁”来防止修改。
You can completely control the configuration by specifying the configuration values in the pattern and using the "lock" on the parameters to prevent modification.
应用推荐