We need suggestions:
We are planning for an upgrade, following are the current status and results from SolarWinds Upgrade Advisor,
Orion Server MPE, MS Windows Server 2016, .NET 4.8
DB Server, MS Windows Server 2012 R2, SQL Server 2016 SP2
APE Server, MS Windows Server 2016, .NET 4.8
Product Upgrade Advisor results:
Selected Current Product Versions:
Orion Platform 2018.4 SP3
APE’s 2018.4 SP3
Target Product Version:
Orion Platform 2019.4
Kindly suggest, Can we proceed with Database: MS SQL Server 2016 SP2, and
Operating System: MS Windows Server 2012 R2 in our environment and leave as it, or should we need to upgrade Database OS Windows Server 2012 R2 to 2016 or later before performing an upgrade.
And if we really need to upgrade DB,s OS, then what is the best way, in-place up-gradation or migration?
If we want a DB server in a virtual environment, then what will be the requirements for this case (Hardware, CPU, Memory, Disk or I/O requirements, etc) according to our environment. Or if anyone has a link for documentation or requirements from SolarWinds.
Are there any other factors that should be taken care of regarding DB optimization done prior to the upgrade/migrations.