So we replicate from Live AIX to a DR AIX Server.
We also take a segment of our data to an EDA Server.
Our Live server is a physical AIX Server, our EDA Server is a Windows 2012 VM.
We then send it to an older MS SQL Server running 2008, including Windows 2008 so we are limited to 32GB of memory on the Windows Server.
We are thinking of getitng a new SQL Server license and installing it on a new Win 2016 VM, but should we just buy the license and actually put the SQL Server software on the Win2012 server that is currently running EDA Server and just throw a lot of memory at it? Then we have it all on the one server rather then having to go from EDA Server to SQL Server.
Any thoughts on what’s the best way forward?