Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan RE: Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

  • September 26, 2013 at 10:01 am

    #1653648

    So while the query is executing on Prod, do you see any blocks? is the query on running state all the time or suspended? do you know what is the wait type if its suspended?