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

  • You need to find out what the differences are between test and production. Perhaps you have a bad plan cached on production? Perhaps you have a missing index on one of the 8 references tables? Is the referenced view the same in test and production?

    If you haven't seen it, Erland Sommarskog hosts an excellent utility called SQL trace. It pulls a lot of useful information that may help you troubleshoot the problem. The only thing is that you're going to have to troubleshoot it in production because the problem doesn't exist in test. Anyway, have a look: http://www.sommarskog.se/sqlutil/sqltrace.html

    HTH