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:28 am

    #1946899

    GilaMonster - Thursday, June 15, 2017 3:05 AM

    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.

    Let me please make sure i understand you correctly, do you mean that normal select SQLs cause locks which might be the reason for that slow performance?
    If so could i add with (nolock) to all tables used in my SQL.

    Thanks