Post reply

LATCH_EX WaitType and Resource is ACCESS_METHODS_SCAN_RANGE_GENERATOR

  • July 26, 2015 at 10:59 am

    #302799

    Hi,

    Sometimes the application becomes very slow,causing production issues. When i check the sql logs i see:

    Message Timeout occurred while waiting for latch: class 'ACCESS_METHODS_SCAN_RANGE_GENERATOR', id

    I have attached the screenshot of the exact message present in the sql logs.

    Also, i run the below statement:

    select * from sys.sysprocesses where blocked<>0

    I have attached the screenshot of the output .

    Please advise on how to move forward and fix this issue.

  • August 2, 2015 at 9:19 am

    #1816659

    Please help on how to resolve the issue

  • August 2, 2015 at 9:51 am

    #1816666

    seems to be an isolation level issue , do you have optimistic concurrency enabled?

    Jayanth Kurup[/url]

  • August 2, 2015 at 11:10 am

    #1816682

    Jayanth_Kurup (8/2/2015)

    seems to be an isolation level issue , do you have optimistic concurrency enabled?

    Latches aren't related to or affected by isolation levels. The latch in question is used with parallel access to tables and indexes, it's not a lock, it's not going to go away with snapshot isolation level.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 2, 2015 at 12:27 pm

    #1816690

    Dear Gail Shaw Sir,

    Thanks a lot for your input. Please help on what i need to do fix these latch error messages. I have attached screenshots in my first post.

  • August 2, 2015 at 1:04 pm

    #1816695

    You got an answer to that on your other thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

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