Upgrade or New Build? Any suggestions? Does anyone have any gotchas or war stories to share about this process?
We have a 2012 instance in Prod that has both OLTP and OLAP databases. We are creating two instances, one to be dedicated to each of those tasks. The OLAP instance is a new build, however to minimize end-user down time we are considering an upgrade for the instance that will house the OLAP databases.
I'm looking for general recommendations that go beyond what I'm reading in the Microsoft docs.