Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Blocking due to access_methods_scan_range_generator and Latch_Ex RE: Blocking due to access_methods_scan_range_generator and Latch_Ex

  • September 1, 2015 at 5:12 am

    #1823592

    It's normal for sessions in parallel to 'block' each other. Your wait times are all around 15-30 ms. Why is this a problem?

    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