database migration

• sagar.dhanawade

  Valued Member

  Points: 60

  More actions

  June 23, 2009 at 3:50 am

  #207452

  we have done the migration of database from sql server 2000 to 2005 🙂 but problem is that, comparatively new db server is low in performance than old db server, though the structure is same of db and tables, do i need to do anything which wil give me better performance then earlier db sever.

• hi_abhay78

  SSCertifiable

  Points: 6265

  More actions

  June 23, 2009 at 4:13 am

  #1013813

  -> sp_msforeachdb "DBCC updateusage('?')"

  -> rebuild all the indexes

  -> update stats of all the tables :EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' <-- you can specify the sampling if you need it

  Abhay Chaudhary
  Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)