We are seeing much slower performance in production vs. QA when running the same queries with basically the same data. We have run traces with a DBA for both QA and production. The traces don't show any issues with any of the queries. However, I noticed there is a 0.033 delay between the end of most tasks and the start of the next task in the production traces. I don’t see this same delay in the QA traces. What could be causing this delay in production? What can be done on the server to reduce this lag time between the end and start of tasks? This is resulting in a significant delay for the users – up to 50 seconds. Thanks.
Below is an excerpt from the production trace. Notice the .033 delay between start and end times for most tasks
Below is an excerpt from the QA trace. There is not a .033 delay between start and end times