June 13, 2007 at 7:18 am
Hello,
I am new writting in this forum. My problem is that I have a DB in a SQL 2000. I am chaging to a new server with more memory, and better disks. To change the server I take a backup of the SQL 2000 server and restore it in the new server with SQL 2005. The problem is that after restoring in the new server, the database goes really slow, even worst than in the old server. I don't know if this is normal, and performance will be better after some days or I have to do something after restoeing the DB in the new server. ¿Can anybody tell me something about this?, Any recommendation or whatever...
Thanks a lot for your help.
Luis.
June 13, 2007 at 7:40 am
You can wait for few days. Might be to get updated stats and few more. But this should never be a problem with restoration. Did u change the compatability level.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 13, 2007 at 7:47 am
Hi Sugesh,
First of all thanks for your quick answer. No, i didn't change the compatibility level. I am going to do it and also someone has told me to force and update of stats. Do you think that force the update should be usefull?
Thanks again for your help.
Luis.
June 13, 2007 at 7:51 am
Change the compatability level. But remember that some TSQL commands are not supported in level 90. check for this site to find the desupported. Then its better that you update the statistics as of now after restoration. Also in sql 2005 you can check how your memory is being used with dynamic management views. see if enough memory is allocated for server and database.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 13, 2007 at 7:59 am
Ok, today I am going to restore a new backup. Then I will do the things you has told me and I will let you know if things go better.
Thanks a lot.
Luis.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply