Hello Experts,
Question 1:
We need suggestions:
We are planning for an upgrade, following are the current status and results from SolarWinds Upgrade Advisor,
Current Environment:
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
NPM 12.4
NTA 4.5.0
SAM 6.8.0
VMAN 8.4.0
NCM 7.9
DPAIM 11.11
VNQM 4.5.1
Toolset 11.0.7
Target Product Version:
Orion Platform 2019.4
APE’s 2019.4
NPM 2019.4
NTA 2019.4
SAM 2019.4.1
VMAN 2019.4
NCM 2019.4
DPAIM 11.11
VNQM 2019.4
Toolset 2019.4
Status: Success
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?
Question 2:
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.
Question 3:
Are there any other factors that should be taken care of regarding DB optimization done prior to the upgrade/migrations.
Thank you.