intent lock 中文意思是什麼
intent lock
解釋
意向鎖-
Are escalated to an exclusive lock on the table, and all other lower - granularity locks, including intent locks, on
上持有的所有鎖都將被升級到該表上的排他鎖，而 -
When locking pages, the database engine places an intent lock on the higher level objects containing the pages
當鎖定頁時，數據庫引擎將在包含頁的更高級別的對象上放置意向鎖。 -
When locking rows or index key ranges, the database engine places an intent lock on the pages containing the rows or keys
當鎖定行或索引鍵范圍時，數據庫引擎將在包含行或鍵的頁上放置意向鎖。 -
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鎖）之前，在表級請求共享意向鎖。 -
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鎖）放置在鎖層次結構的底層資源上。 -
Setting an intent lock at the table level prevents another transaction from subsequently acquiring an exclusive lock on the table containing that page
在表級設置意向鎖可防止另一個事務隨后在包含那一頁的表上獲取排他鎖（ x鎖） 。 -
For example, before a sql server database engine task applies shared or exclusive row locks within a table, it places an intent lock on the table
其他用戶可以同時讀取數據，但在釋放所有共享鎖之前，任何事務都不能獲取對該數據的排他鎖。 -
Indicates shared access to a resource with the intent of acquiring update locks on subordinate resources in the lock hierarchy
指示對有意在鎖層次結構中的從屬資源上獲取更新鎖的資源進行共享訪問。 -
Indicates shared access to a resource with the intent of acquiring exclusive locks on subordinate resources in the lock hierarchy
指示對有意在鎖層次結構中的從屬資源上獲取排他鎖的資源進行共享訪問。 -
This option only requires an intent - shared table lock
用戶必須是表所有者，或者是 -
During the main phase of the index operation, only an intent share lock is held on the source table
在索引操作的主要階段，源表上只使用意向共享（ is ）鎖。 -
To escalate locks, the database engine attempts to change the intent lock on the table to the corresponding full lock, for example, changing an intent exclusive lock to an exclusive lock, or an intent shared lock to a shared lock
升級鎖時，數據庫引擎將嘗試將表上的意向鎖更改為對應的全鎖，例如，將意向排他鎖（ ix鎖）更改為排他鎖（ x鎖） ，或將意向共享鎖（ is鎖）更改為共享鎖（ s鎖） 。
分享友人