rray 44280 (6/7/2013)
I'm using log shipping to maintain a failover copy of my main db on a secondary server. I'd like to put our Analysis Services on the secondary. If we have to failover to the secondary then Analysis Services would be turned off until we got things back in normal operation.
It occurs to me that, during normal operation, I could run the nightly ETL jobs against the copy of the db on the secondary, putting everything local on that machine. It should improve performance, reduce execution time and relieve load on the primary instance, yes?
Assesment is correct, sourcing from secondary is not going to have any impact on primary.
Having said that...
1- Make sure business is comfortable and on agreement with the idea of not having Analysis Services up in case of a DR situation.
2- Make sure there is a way to source all the "missed" ETL cycles once DR situation gets back to normal.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.