Currently, doing enterprise database maintenance is cumbersome. Even if it's just simply adding a field to an existing feature class, it could take an hour because of everything you have to do to make maintenance possible. In ArcGIS Pro you have to stop connections and then clear connections, but you also have to remove privileges (except administrator) to make sure no one connects (we have many services that reconnect automatically every few seconds) when you subsequently have to allow connections because in ArcGIS Pro you have to be able to make more than one administrator connection (and that won't work if the connections are stopped).
Ideally, there would be a "Maintenance Mode" that an administrator could go into to perform maintenance that would automatically do these things on the fly. And perhaps, exiting maintenance mode would put everything back the way it was.
This would be helpful since we are already having to do maintenance after hours so we don't take down our GIS during business hours.
I'll probably end up creating this in python when I have time but we can't be the only shop with this issue.
