<div>
<div class="content wysiwyg-content">
Hi.<br />
The latch wait time (ms) on my production sql 2008R2 server is pretty high, it is up to 189620ms and stay with this valu solid. &nbsp;User connections are hung and apps get disconnected. Is anyone experience this type of error in SQL ???? How to resolve this issue if there is any ????<br />
Any suggestion would be very helpful.<br />
<br />
Thanks,<br />
<br />
Phuong.
</div>
</div>


Hi.
The latch wait time (ms) on my production sql 2008R2 server is pretty high, it is up to 189620ms and stay with this valu solid.  User connections are hung and apps get disconnected. Is anyone experience this type of error in SQL ???? How to resolve this issue if there is any ????
Any suggestion would be very helpful.

Thanks,

Phuong.

sql latch wait time is high

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.