您要查找的是不是：
- Using lock escalation reduces system overhead. 利用锁升级可以减少系统开销。
- However, memory pressure can still activate lock escalation. 但是,内存不足仍可激活锁升级。
- Locks option also affects when lock escalation occurs. 选项也会影响何时进行锁升级。
- Lock escalation only occurs for tables that have been accessed at the time the escalation is triggered. 只有触发升级时已经访问的表才会发生锁升级。
- Lock escalation occurs on a per-table basis when a request for a lock causes a specific lock escalation threshold to be exceeded. 如果请求锁时超出特定的锁升级阈值,锁就会按各个表分别进行升级。
- When lock escalation occurs, the lock selected for the heap or index is strong enough to meet the requirements of the most restrictive lower level lock. 发生锁升级时,为堆或索引选择的锁必须足够强,才能满足限制性最强的较低级别的锁的要求。
- Disables lock escalation based on memory pressure, or based on number of locks. 基于内存不足或基于锁数禁用锁升级。
- Similarly, lock escalation is not triggered if a statement has a self join on a table, and each reference to the table only acquires 3,000 locks in the table. 同样,如果语句中含有表的自联接,并且表的每一个引用仅在表中获取3,000个锁,则不会触发锁升级。
- To preserve system resources, the lock manager automatically performs lock escalation when a configurable threshold on the number of row locks is exceeded. 为保留系统资源,当超过行锁数的可配置阈值时,锁管理器将自动执行锁升级。
- The Database Engine might do both row and page locking for the same statement to minimize the number of locks and reduce the likelihood that lock escalation will be necessary. 数据库引擎可以为同一语句执行行锁定和页锁定,以最大程度地减少锁的数量,并降低需要进行锁升级的可能性。
- Lock escalation is the process of converting many fine-grain locks into fewer coarse-grain locks, reducing system overhead while increasing the probability of concurrency contention. 锁升级是将许多较细粒度的锁转换成数量更少的较粗粒度的锁的过程,这样可以减少系统开销,但却增加了并发争用的可能性。
- He chiseled a hole in the door to fit a new lock. 他在门上凿了个孔，以便装一把新锁。
- This lock can only be opened from the inside. 这把锁只能从里面打开。
- He put the key in the lock and turned it. 他把钥匙插入锁里转动。
- We must put a new lock on the front door. 我们得在前门上安一把新锁。
- Someone has been tampering with the lock. 有人乱动过这把锁。
- Someone has to lock up the house. 总要有人把房子锁起来。
- She inserted the key into the lock. 她把钥匙插入锁中。
- On no account (do you) forget to lock the door. 千万别忘了锁门。
- He kept a lock of her hair as a memento. 他保留着她的一束头发作纪念。
