I am trying to migrate Mysql Database which is hosted on Linux to SQL Server. So as starting point i am thinking to go with same configuration as Linux box(CPU, RAM etc).
However, I agree with SQL Server we have (in memory tables etc). That would need more memory. But i was thinking do the migration first to SQL Server and run the systems with same configuration as today, Wait few months and then implement in memory tables and other features as needed, so that way it would be easily identified where the resources is needed? Any inputs on this? Thanks in Advance!