Post reply

Average Latch Wait Time > 1600ms

  • January 30, 2003 at 2:08 am

    #105572

    I run 32 SQL servers. Most of them run SQL7 SP3. What can I do to reduce the "Average Latch Wait Time" wich is exeeding 1600 ms in some of the servers. Is it only a HW issue or is there any "knobs" I can turn to fix this.

    //Patrick

  • January 30, 2003 at 11:49 am

    #447638

    latching can come from a variety of things. If you have an I/O bottleneck you could see some page latching. If you have high contention for the same data you could see high latch times from that.

    DBCC SQLPerf(waitstats) will tell you what you're latching on I would run that and see what the problem is first. The values are cumulative so run DBCC SQLPerf(waitstats,clear) first then I would run this every 30 seconds or so for awhile and see what numbers are the highest.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply