this is some kind of "what would you do" question.
There's a one box installation of a repository system with IIS, a worker engine and SQL Server. Now there's the request to split the system and put the database onto an existing SQL server to free up the license on the 1st one.
So, what would you check to find out if you can place the database on another sql server which already exits in your environment?Regards Dirk
asked Sep 24 '12 at 11:24 AM in Default
answered Sep 24 '12 at 12:26 PM
Check SQL Server versions and editions. If they differ, check that you don't use code or functionality which won't work on the new machine (compression etc) Look at network infrastructure between the two machines is good enough to handle the throughput between app and DB. Look to see that the DB machine has enough memory and disk. If you want to be sure that the DB gets enough dedicated memory you might want to put it in its own instance.
answered Sep 24 '12 at 11:36 AM
In addition to @Magnus excellent set of checks, I'd want to be sure of the existing transaction load on that other server and what the anticipated load of the database you're moving will be (what it is currently). This could be a major problem, depending.
answered Sep 24 '12 at 11:48 AM
Grant Fritchey ♦♦