Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning A stored procedure that usually runs fast ran for a long time yesterday RE: A stored procedure that usually runs fast ran for a long time yesterday

  • July 28, 2015 at 4:57 pm

    #1815585

    coolchaitu (7/27/2015)

    Thanks for replying. There is also this "ACCESS_METHODS_SCAN_RANGE_GENERATOR" from the screenshot.Could you please let me know how to deal with these kind of issues and how to resolve these issues.

    LATCH_EX+ACCESS_METHODS_SCAN_RANGE_GENERATOR

    Alex Suprun