Good Day SSC!
Looking to migrate our 2005 environment into 2012.
-- OLTP box
-- WH1 warehouse box
-- WH2 warehouse box
A log shipping routine moves 3 databases from the OLTP server into read only versions on *each* of the WHx's. Jobs on each WH machine consume the OLTP data using 3 part naming. Things work. This setup is illustrated in the left side of the attached PNG.
We proposed (and have started to develop) a solution in 2012 that would let us run in parallel with production, that introduces the idea of a "data well" server (right side of the PNG). Basically, instead of log shipping to each WH box, we just ship to 1 machine, and the WH's will draw their information from that machine using 4 part naming.
What we're finding is that long running jobs are running even longer in the new setup (the right side of the graphic).
Are we walking down the wrong path here? Before it's too late, how should we be doing this? I know 2012 introduces some fancy new logship/replication options, but I think our network might be the bottleneck right now.
Requirements: Run in parallel, trivial switchover, GET TO 2012 ASAP.