February 28, 2014 at 5:48 am
Dear All,
I have created stored Procedure which executes 1:20 (mm:ss) in development envioronment.The same Procedure and Table index script every thing promoted to Stage Server there its taking 4 min to Process the same set of logic and same set of records.Both Environment SQL Server 2012 Configured(Microsoft SQL Server Standard (64-bit)).
Even I have tried take back up of my Dev database to Staging and Ran the same procedure its taking 1:20 no change.I have check both Server settings and DB Settings level no issue.
I have take the Query from the Stored Procedure and executed one by one.In the new database the behaviour of the Query is different.Each and every time the Execution plan giving different recommendations.But for the DEV Database restored in the Staging the plan indicating Index Seek.
Kindly give your views in what context i have to check in Database.
Regards
Siva
February 28, 2014 at 8:57 am
As a shot in the dark...have you updated statistics? That could very likely be the issue here. How much data is being affected by this query?
_______________________________________________________________
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