| 1. | Intent locks serve two purposes
意向锁有两种用途： |
| 2. | When locking pages , the database engine places an intent lock on the higher level objects containing the pages
当锁定页时，数据库引擎将在包含页的更高级别的对象上放置意向锁。 |
| 3. | Intent locks , row locks , and page locks all count toward the escalation count , unless they are temporary table locks
除非属于临时表锁，否则意向锁、行锁和页锁都将计入升级统计中。 |
| 4. | When locking rows or index key ranges , the database engine places an intent lock on the pages containing the rows or keys
当锁定行或索引键范围时，数据库引擎将在包含行或键的页上放置意向锁。 |
| 5. | Sometimes , the term update refers to any data modification , including insert , update , and delete operations . update lock
第二个任务在锁定该表之前不必检查各个页锁或行锁，而只需检查该表的意向锁。 |
| 6. | When the total of intent locks , row locks and page locks on a specific table exceeds the escalation threshold , escalation occurs
当特定表上意向锁、行锁和页锁的总数超出升级阈值时，就会进行升级。 |
| 7. | The act of modifying one or more data values in an existing row or rows , typically by using the update statement
如果另一个任务尝试在表级上应用共享锁或排他锁，它会被第一个任务所持有的表级意向锁阻塞。 |
| 8. | For example , a shared intent lock is requested at the table level before shared locks are requested on pages or rows within that table
例如，在该表的页或行上请求共享锁（ s锁）之前，在表级请求共享意向锁。 |
| 9. | The database engine uses intent locks to protect placing a shared lock or exclusive lock on a resource lower in the lock hierarchy
数据库引擎使用意向锁来保护共享锁（ s锁）或排他锁（ x锁）放置在锁层次结构的底层资源上。 |
| 10. | Setting an intent lock at the table level prevents another transaction from subsequently acquiring an exclusive lock on the table containing that page
在表级设置意向锁可防止另一个事务随后在包含那一页的表上获取排他锁（ x锁） 。 |
