Upgrade 2005

• sbauer

  SSCommitted

  Points: 1966

  More actions

  April 6, 2006 at 5:13 pm

  #168442

  We just attached a 2000 db to a 2005 db and are having issues with performance.

  EVERYTHING is taking longer and the cpu is at 100%.

  We ran dbcc updateusage and checkdb but nothing came out of those results.

   

  Any help would be greatly appreciated.

   

  Thanks

  Susan

   

• sbauer

  SSCommitted

  Points: 1966

  More actions

  April 6, 2006 at 5:43 pm

  #631381

  We are using the The 64-bit Intel Itanium.

  Any help would be greatly appreciated.

  Thanks

  Susan

   

• cutespn

  SSCommitted

  Points: 1669

  More actions

  April 8, 2006 at 6:29 am

  #631601

  Hi Susan,

  You need to update your statistics and also rebuild your indexes in this case.

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• sbauer

  SSCommitted

  Points: 1966

  More actions

  April 8, 2006 at 10:17 am

  #631615

  right, thatwas the first thing we did, but saw no difference in performance..

  Anything else I could do? or look at?