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

Published Mar 13 2019 08:28 AM 49 Views
Microsoft
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-lockh...

Cheers  Juergen


%3CLINGO-SUB%20id%3D%22lingo-sub-366933%22%20slang%3D%22en-US%22%3ENew%20hashkey%20algorithm%20for%20lockhash%20values%20introduced%20in%20SQL%20Server%202008%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366933%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Jan%2021%2C%202010%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EHello%20folks%2C%20I%20wish%20you%20all%20a%20Happy%20New%20Year%202010.%20I%20only%20wanted%20to%20point%20your%20attention%20to%20a%20blog%20about%20an%20improvement%20in%20SQL%20Server%202008%20R2%20which%20will%20reduce%20the%20probability%20of%20deadlocks%20and%20blocking%20lock%20situations%20in%20some%20scenarios%20which%20we%20encountered%20in%20SAP%20platform%20migrations%20and%20some%20other%20scenarios%20of%20mass%20data%20loads%20with%20dozens%20of%20parallel%20tasks.%20Since%20the%20description%20of%20the%20feature%20describes%20a%20very%20common%20scenario%2C%20we%20decided%20to%20publish%20the%20blog%20on%20the%20SQL%20Server%20Storage%20Engine%20blog%20under%20this%20link%3A%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fsqlserverstorageengine%2Farchive%2F2010%2F01%2F18%2Fimprovement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx%22%20mce_href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fsqlserverstorageengine%2Farchive%2F2010%2F01%2F18%2Fimprovement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fsqlserverstorageengine%2Farchive%2F2010%2F01%2F18%2Fimprovement-in-minimizing-lockhash-key-collisions-in-sql-server-2008r2-and-its-impact-on-concurrency.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3ECheers%26nbsp%3B%20Juergen%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-366933%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2021%2C%202010%20Hello%20folks%2C%20I%20wish%20you%20all%20a%20Happy%20New%20Year%202010.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-366933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 13 2019 08:28 AM
Updated by: