Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SQL behaving strangely on different servers RE: SQL behaving strangely on different servers

  • June 15, 2017 at 3:05 am

    #1946896

    nadersam - Thursday, June 15, 2017 3:01 AM

    GilaMonster - Thursday, June 15, 2017 2:54 AM

    Is it getting blocked by other queries on production?

    I already thought about that reason but i rule it out as those tables are static (no Insert,Update,Delete).

    Then you may want to revisit it as a possible reason, as deletes get blocked by shared locks, which are what read queries take.

    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