Avatar of PNJIT
Flag for United States of America

asked on 

Microsoft, SQL, 2005, Detail Info regarding Latch Waits, MS-SQL

Need to find out what ACCESS_METHODS_SCAN_RANGE_GENERATOR means as a Latch Wait type in MS-SQL 2005.  I have a an instance that reports on a daily basis somewhere from 4000 to 5000 lock timeouts per second for a few minutes.  We have I believe isolated the transaction taking place at the time, and I can see this type of Latch Wait taking place.  But I am not able to understand the meaning of it.
Microsoft SQL Server 2005Microsoft DevelopmentMicrosoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon