Using tablock causes a table - level lock to be taken for the duration of the bulk operation and eliminates the overhead of locking individual rows 使用tablock会导致在大容量操作期间进行表级锁定，并消除按行锁定的开销。
If row locking is used , all rows in the fetch buffer are locked , so a very large setting for the fetch size can affect concurrency 如果使用行锁定，则提取缓冲区中的所有行都会被锁定，因此提取大小设置得过大会影响并发性。
The database engine escalates row or page locks to table locks if the amount of memory used by lock objects exceeds one of the following conditions 如果锁对象使用的内存量超出下列条件之一，则数据库引擎将行锁或页锁升级为表锁：
To preserve system resources , the lock manager automatically performs lock escalation when a configurable threshold on the number of row locks is exceeded 为保留系统资源，当超过行锁数的可配置阈值时，锁管理器将自动执行锁升级。
Considering the effect of line phase locked , a front modulation is added in color subcarrier regeneration hardware module to improve the module ’ s precision 考虑到行锁相对色副载波还原的影响,在硬件实现时增加了前向调节的功能,提高了色副载波还原的精度。
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 数据库引擎可以为同一语句执行行锁定和页锁定，以最大程度地减少锁的数量，并降低需要进行锁升级的可能性。
For example , if a repeatable read transaction has a shared lock on a row , and the transaction then modifies the row , the shared row lock is converted to an exclusive row lock 例如，如果repeatable read事务具有用于某行的共享锁，并且该事务随后修改了该行，则共享行锁便会转换为排他行锁。
A 4 - byte column that the sql server database engine automatically adds to a row to make each index key unique . this column and its values are used internally and cannot be seen or accessed by users 例如， sql server数据库引擎任务在表内应用共享行锁或排他行锁之前，它在该表上放置一个意向锁。
Microsoft sql server 2005 mobile edition sql server mobile automatically escalates row locks and page locks into table locks when a transaction exceeds its escalation threshold 当事务超出其升级阈值时， microsoft sql server 2005 mobile edition ( sql server mobile )会自动将行锁和页锁升级为表锁。
If a transaction acquires a large number of row or page locks , the database engine may grant a table lock and then free all the lower - level locks to minimize locking overhead 如果一个事务获取了大量的行锁或页锁，则数据库引擎可能授予它一个表锁，然后释放所有较低级别的锁，以将锁定开销降到最小。
