Blog Post

Running SAP Applications on the Microsoft Platform
1 MIN READ

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

msjuergent's avatar
msjuergent
Icon for Microsoft rankMicrosoft
Mar 13, 2019
First published on MSDN on Jan 21, 2010

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:

http://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


Updated Mar 13, 2019
Version 2.0
No CommentsBe the first to comment