May 13, 2005 at 7:59 am
Does anyone know how the perfomance counter 'Average Latch Wait time' is calculated and what the factors are that influence it.
Hhow do you determine what a reasonable value is. I am running at 500 ms which I think is high.
I would be interested in knowing what other dba's consider to be an acceptable value.
May 16, 2005 at 8:40 am
Latches are light-weight objects similar to locks, that are used internally by SQL Server for syncronization of (normally) very quick operations. The average wait time counter is a bit tricky because it only includes the time for those latch requests that actually needed to wait. You should be looking at Latch Waits and Total Wait Time as well to determine if there might be a problem. Still it might be difficult to determine if the numbers are high if you do not have benchmark base values to compare against. If you really do think it might be a sign of some problem you should look at other counters as well, specifically memory usage.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply