Slower Restored Database

[mwardle]

After restoring a database under a different name to use for testing, it seems to run considerably slower than the original. A number of stored procedures that analyse the data contained therein run take between 2 to 10 times longer in the restored database than they do in the current database. Why is this? Is it fixable? The restored database is what the current one was only a few hours before.

 

[tlbroadbent]

Have you tried updating statistics or reindexing on the new database? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[mwardle]

Auto Update Statistics is on. I just tried DBCC ReIndex on the main index used by the sp, and it seems to be back to speed, indeed slightly faster than the original. Cheers.