• Grant Fritchey (7/3/2015)


    If the execution plans are the same then it's likely down to resources. Take a look at the waits statistics before and after the run in order to determine the waits that the query experiences in the development environment. That will give you a very strong indication of where the likely bottleneck is.

    can you guide me how to do that ?