25112
asked on
performance when version is upgraded..
when an app is moved from 2k to 2k5, its performance comes to a halt.. (did a backup/restore).. what spots could the trouble be?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it is already on 90.
glad you mentioned something about the backups.. it is goofy.. we are automatically taking tlb but not full backups.. but i put on simple .. (we were able to afford that) that did not fix it either..
i ran sp_updatestats and that has fixed it..
so what is the lesson? after every restore, run sp_updatestats? is it only when you are going up a version or even within same version?
glad you mentioned something about the backups.. it is goofy.. we are automatically taking tlb but not full backups.. but i put on simple .. (we were able to afford that) that did not fix it either..
i ran sp_updatestats and that has fixed it..
so what is the lesson? after every restore, run sp_updatestats? is it only when you are going up a version or even within same version?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you.
ASKER