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

  • August 3, 2015 at 6:44 am

    #1816781

    Gail Shaw Sir,

    I have attached screenshot. The process ID are frequently changing and its LATCH_EX and ACCESS_METHODS_SCAN_GENERATOR. In this case, please advice on what to do to fix and prevent