undocumented virtual column %%lockres%%

undocumented virtual column  %%lockres%%

KeyHashValue : A lot of duplicate keys

HashBytes (Transact-SQL)

Change Lock Resource Hashing Algorithm to Reduce Likelihood of Collisions

Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency

http://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/e43a46cd-e934-4ca6-ab9d-cacd15272c50/keyhashvalue-a-lot-of-duplicate-keys?forum=sqldatabaseengine

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/26/range-locks.aspx

posted @ 2013-12-13 22:58  桦仔  阅读(340)  评论(0)  编辑  收藏  举报