By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Effects of a Database restoration.

P: n/a
Hi,

Does a database restoration perform any
update-statistics/defragmentation by default. We observed a marked
improvement in performance when we restored the a database from an high
end machine to a low machine.

Could someone shed some light on this.

Regards,
Thyagarajan Delli.

May 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thyagu (td****@gmail.com) writes:
Does a database restoration perform any
update-statistics/defragmentation by default.
As far as I know, no. Except, that if the MDF is very fragmented on the
source machine, and the target machine has space to accept it as
contiguous, you will see defragmentation on that level.
We observed a marked improvement in performance when we restored the a
database from an high end machine to a low machine.


Maybe the low-end machine has a single CPU? SQL Server sometimes goes
for parallel plans on multi-CPU machines that are not very efficient
at all.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.