[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

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?
0
25112
Asked:
25112
  • 3
2 Solutions
 
25112Author Commented:
especially for sp, is this related to if the parameters are set vs passed in?
0
 
jogosCommented:
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
 
Anthony PerkinsCommented:
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:
thank you.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now