Welcome to Sign in | Help

Re: Average Latch Wait Time

  •  01-22-2010, 5:28 PM

    Re: Average Latch Wait Time

    Sunt posibilitati multiple pentru cauza unei valori mari.
    Una din ele poate fi un bottleneck I/O datorat design-ului interogarilor si bazei de date. Examinati disk sec/transfer si avg disk queue length.
    In plus examinati si buffer cache hit ratio.


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems