I realize that documentation highly suggests using a offline copy, but curious if anyone has more real world usage how critical that is?
We have under 12,000 devices and a dedicated SQL server that is sufficiently performant, and can increase specs if required.
We also use DSA, which seems to also not be recommended as an option.
It’s not saying much, but I have a Dev instance that’s been ETLing for several years off the live DB, but it’s virtually unused environment as it’s just for testing with under 20 clients. We’re looking to finally setup the Prod instance.