I wanted to get a second opinion on something, this weekend I need to do a deployment to 2 databases which are part of an always on availability group. The deployments are going to cause a table rebuild of some tables, the largest of which is 61GB
So I know that the work is going to have to done on the primary and also the replica, thats how it goes but I wondered if there were
any tricks that may speed things up.
I did entertain the idea of suspending the always on, do the deployment then re-enable it but I think all I'm doing there is moving the wait for the replica down to the end, its still going to have to do it, so probably not worth it.
So does anyone have any ideas on how I can speed things up, or am I just best waiting for it to do its thing? Also is there a way to monitor the progress/status of the AG in more detail than the GUI gives me.