Thanks for spending your time to provide this clear explanation. You've saved me many more hours of research.

Thanks for sharing the additional details you uncovered. Our team is currently trying to design a DR method, and I am in the same quandary as you and wondering how...

Did you already check to make sure the indexes on the tables being queried are in place? Did you look at the execution plan?