November 24, 2011 at 1:37 am
Dear All,
I have an issue regarding the procedure tuning. I tuned one procedure which retrieves 6lakh records. Previously it was taken around 8 min to give the results. After tuning that SP it was taken around 2 min 30 sec... means they said it's ok... After 1 week they restored that DB. Again i executed the same procedure, but it giving results some times it is 12 min, 8.30 sec, 5.30, 4.45sec like that...
Previously it was fine. I checked with the code the same code, nothing was changed...
Can anybody please let me know where the issue is , whether it is from Database side (Network traffic or Procedure side.....)
Advance Thanks to All,
Skase
November 24, 2011 at 2:20 am
If the code was not changed, you should check if the physical structures changed. I mean you should look at the indexes and stats on the table(s).
Also, make sure you're not suffering from bad parameter sniffing.
You didn't provide much detail in your question and neither can I in my reply. If you want to investigate this issue further with us, read this article[/url] and post the information required.
Gianluca
-- Gianluca Sartori
November 24, 2011 at 5:22 pm
Thank u ....Gianluca:-)
November 25, 2011 at 12:16 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1211482-360-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply