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?
LVL 5
25112Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
so what is the lesson? after every restore, run sp_updatestats?
Yes.
is it only when you are going up a version or even within same version?
Regradless of the version.
0
 
25112Author Commented:
especially for sp, is this related to if the parameters are set vs passed in?
0
 
jogosConnect With a Mentor Commented:
actions on upgrade
- set db to compatiblity-level 90 (sql2005)
- reindex
- update statistics

And there could be other things when new 2K5 instance
- other configuration of memory/disks/tempdb
- full recovery model and not yet a transactionlog backup running
0
 
25112Author Commented:
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?
0
 
25112Author Commented:
thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.