• Another thing to look at the database character set and collation. Make sure they are all the same. There 'can' be problems if you move a database with a different character set/database collation to another one. The reason is if there are a lot of queries hitting that database that does a lot of sorting in TEMP DB and the collation is different from the application db and TEMPDB. It can work but you need to test and verify this before you go live.

    Also, if you are consolidating make sure the new server has enough memory too. Example, if you have 5 servers with 4 gig of memory each that is a total of 20 gig of memory. Don't put all of these dbs onto one server with 6 gig of memory and expect the same performance.