Solved

sql latch wait time is high

Posted on 2010-11-22
1
1,216 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:pluu
1 Comment
 
LVL 13

Accepted Solution

by:
Wizilling earned 500 total points
ID: 34193463
it usually bottlenecks with io or memory.
have you checked average read time and averaage write time
also check total server memory and target server memory.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 80
SQL Query 3 48
SQL Server - SQL field is defined as text 3 26
Getting max record but maybe not use Group BY 2 13
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now