Printable View
I have a production sql 2000 box with 24 gig of memory running 3rd part app. There is a posting process (takes all the orders and does the math). Before we did the upgrade it was a 15-20 minute process. Nothing has changed, but in the last month it has gone 60-75 minutes. There were also some windows updates applied (win 2003 adv server). I realize looking for the needle in the haystack, but has anyone seen this issue with either the sql sp4 or windows SP for 2003?
With 24 GB of memory you must be using AWE option. SP4 had a problem with AWE, there is a patch available at Microsoft.
Done that, memory is fine
Did you rebuild index or update statistics after applying sp4?
Yes, both are done on weekend
Possible to recompile sps?
Yes is there an issue with this?
To get better plan with up to date statistics.
Do you have any other server on Sp3?. You may want to compare query plan for the task on SP3 and Sp4.
Problem solved, related to indexes. I have a small maintnenance window and had been rebuilding groups of indexes since applying sp4. I finished my last group Sunday, and now the psoting time is back to normal.