SQL Server 2000 with high LOCK_HASH spinlock contention

  • Article

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.