<div>
This does not explain exactly what this latch does (how it works). &nbsp;Any insight?
</div>


<div>
The only information there is on that is in BOL- which I posted above.<br />
At the end of the day it is a kind of wait latch.<br />
<br />
You probably have parallel processing going on which causes this type of a latch.<br />
If its causing problems, then you have the query isolated, and then try to optimize it.
</div>


<div>
My questions are:<br />
<br />
1. &nbsp;What is a range generator?<br />
2. &nbsp;What structure is being latched?
</div>


<div>
<div class="content wysiwyg-content">
Need to find out what ACCESS_METHODS_SCAN_RANGE_<wbr />GENERATOR means as a Latch Wait type in MS-SQL 2005. &nbsp;I have a an instance that reports on a daily basis somewhere from 4000 to 5000 lock timeouts per second for a few minutes. &nbsp;We have I believe isolated the transaction taking place at the time, and I can see this type of Latch Wait taking place. &nbsp;But I am not able to understand the meaning of it.
</div>
</div>


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, 2005, Detail Info regarding Latch Waits, MS-SQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.