July 10, 2013 at 4:43 pm
Hi Experts,
I have a Store Procedure which is running slow in Prod but running fine in Stage. I have rebuild the index and updates Statistics but there was no difference in Prod.
When I am passing the 'H' Value in Store Procedure its taking 1 Hour and 30 min in Prod and in Stage its taking 11 min
I checked the Server configuration Stage is running on 3 Ghz and Prod is 2 Ghz I don't its a Server Problem we moved from a 4.71 environment to a 5.01 environment but nothing was changed in DBs I am attaching the store proc if anyone can help I will appreciate it . Thanks
July 10, 2013 at 5:03 pm
To get better help on performance problems, please read the following article. I'm sure someone around here will help you to solve the problem.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2013 at 7:14 am
You should take a look at Gail's blog post about multiple execution paths. It will explain why you sometimes see horrible performance and for other parameters you don't.
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply