SQL Server 2000 with high LOCK_HASH spinlock contention
Published Jan 15 2019 10:46 AM 154 Views
First published on MSDN on Aug 28, 2007

I want to make you aware of an update (QFE) to address LOCK_HASH contention during logon and sp_reset_connection requests.  The details of the fix are scheduled to be published under knowledge base article 939317.

Customers have generally reported increased than expected CPU and unexpectedly high values for the LOCK_HASH row in dbcc sqlperf(spinstats).   If the server has such symptoms you might consider contacting Microsoft for the SQL Server 2000 QFE.

Version history
Last update:
‎Jan 15 2019 10:46 AM
Updated by: