February 4, 2010 at 8:58 am
Stored Procedure which is optimized taking around 3 mins in dev server where as its taking around 12 mins in Production server. The server configuration in terms of hardware and sql server were same in both servers. What will be the cause for this different execution times and what will be the resolution?
Appreciate help.
February 4, 2010 at 11:41 am
Did you by any chance look at the execution plan? There are lots of reasons why the performance could differ between your test and production.
Do you take care of statistics on your tables in Production?
-Roy
February 5, 2010 at 7:52 am
Roy, as usual, has hit on the most common culprit, statistics. You could also check the cost threshold for parallelism and max degree of parallelism settings, it may be that one server is parallelizing (sometimes good, sometimes bad) and the other isn't. You can't know until you check the execution plan.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply