管理类(Administrative):由管理命令引起,如重建索引,行级锁(row-level locking)引起的锁等待; 应用程序类(Application): APP代码引起;
基于335个网页-相关网页
闩锁首次在SQL Server 7.0里引入,同时微软首次引入了行级别锁(row-level locking)。对于行级别锁引入闩锁的概念是非常重要的,不然的话在内存中会出现丢失更新(Lost Updates)的现象。
基于24个网页-相关网页
locking on row level 提供行锁
The first thing every contestant needed to do was change every table to row-level locking.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
在导出操作期间,行级别锁定应用于导出表(exporting table),这意味着一次只持有一个锁。
WebSphere Process Server accesses its databases in multiple concurrent threads and USES row-level locking to ensure data consistency during its transactions.
WebSphere Process Server通过多个并发线程访问其数据库,并使用行级锁定来确保其事务期间的数据一致性。
应用推荐