3:10 "Just switch to log shipping" I realise the question mentions the purpose of having the replicas is for DR, so as you mentioned log shipping would probably be a better approach. If they wish to also use the replicas for read-only purposes, wouldn't using read-scale AG become the better option? With log shipping your data will always be behind in accordance to the log backup schedule, and when log restores happen, users reading the db would get kicked out.
ruclips.net/video/g6fqxTPnDd0/видео.html: I have seen this happen when the proc contains a for loop that does a bunch of stuff for each row returned in a previous query. The painting of the execution plan takes forever and in some instances can blow out memory in SSMS. Imagine a loop that runs 5 queries and has to do this for 200 rows.
3:10 "Just switch to log shipping"
I realise the question mentions the purpose of having the replicas is for DR, so as you mentioned log shipping would probably be a better approach.
If they wish to also use the replicas for read-only purposes, wouldn't using read-scale AG become the better option?
With log shipping your data will always be behind in accordance to the log backup schedule, and when log restores happen, users reading the db would get kicked out.
You’re solving for a problem they don’t have. Don’t add complexity you don’t need. Fair?
hehe, you mentioned the data loading performance guide just 2 months ago, ap3 11, 3rd answer...
It's surprising how good that advice is, and timeless.
ruclips.net/video/g6fqxTPnDd0/видео.html: I have seen this happen when the proc contains a for loop that does a bunch of stuff for each row returned in a previous query. The painting of the execution plan takes forever and in some instances can blow out memory in SSMS. Imagine a loop that runs 5 queries and has to do this for 200 rows.
Absolutely! Totally makes sense, that's a great example.
hahaha 8:10 bananas
Perhaps cut the ones where you find it necessary to criticize the writer of the question next time?
No, those folks do need to hear that kind of answer.
The long time followers come for the salt to season our popcorn