Script to switch Performace Warehouse and Session Storage
We currently have a Fail-over System with DT Collectors and 1 DT Server, which is an exact replica of the Production System with DT Collectors and 1 DT Server. The primary Production System will communicate to the Performance Warehouse and the Session FOlder. When we perform the fail-over we would like to automatically switch the Fail-over DT Server to continue to write to the same Performance Warehouse, and use the same Session folder. Until the fail-over occurs, the fail-over systems are in-active.
So we need a script that can allow us to switch Performace Warehouse and Session Storage. Any help would be greatly appreciated.
We don't have a SAN. Hence the need for a script.
You should not need any scripts. dT is inherently cluster/failover-unaware (at this point), so you have to make sure that all key elements (config files, storage, etc) are on shared SAN.
So: each dT server (one active, one inactive) would be configured to point at the same PW (same connection string, credentials, etc). The session storage should be on a SAN visible to both servers via the same path. Also, key config files for the dT server needs to be on shared disk as well otherwise you will never sync up well. Same goes for the collectors (their cache, etc needs to be on SAN).
It's up to you to manage the shared nature of all the key elements. If you do that properly, then after failing over to the new servers, everything should "just work".
Rob
