New hashkey algorithm for lockhash values introduced in SQL Server 2008 R2

  • Article

Hello folks, I wish you all a Happy New Year 2010. I only wanted to point your attention to a blog about an improvement in SQL Server 2008 R2 which will reduce the probability of deadlocks and blocking lock situations in some scenarios which we encountered in SAP platform migrations and some other scenarios of mass data loads with dozens of parallel tasks. Since the description of the feature describes a very common scenario, we decided to publish the blog on the SQL Server Storage Engine blog under this link:

https://blogs.msdn.com/sqlserverstorageengine/archive/2010/01/18/improvement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx

Cheers Juergen