Post reply

Latches

  • February 22, 2011 at 6:29 am

    #144732

    Hi,

    Please, can you help me understand what means "latches" in sql server?

    Thanks since now,

    Rafael Melo - Br

  • February 22, 2011 at 7:00 am

    #1289836

    The SQLServer:Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks.

    A good discussion of latches can be found at:

    http://blogs.msdn.com/b/psssql/archive/2009/01/28/hot-it-works-sql-server-superlatch-ing-sub-latches.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 22, 2011 at 9:42 am

    #1289925

    Nice paper... It's clear to me now.

    Thanks a lot for your replying!

    Regards,

    Rafael Melo - Brazil.

  • February 22, 2011 at 12:28 pm

    #1290042

    Glad to be of assistance

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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