Re: Best practices for reporting: Replicated servers + data warehouse server??

Can you specify requirements for the reporting data? What would be the
maximum latency involved? I assume that reporting from dw isnt good enough
beacause of the latency...


MC


"Sean Aitken" <sean.aitken@xxxxxxxxx> wrote in message
news:1139858184.012942.18310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Good afternoon,

Lately there has been discussion of what the best practice would be for
enterprise reporting needs. Specifically, we currently have online OLTP
servers for our business apps, as well as a data warehouse server.

A member of our team has suggested that we create a new server farm (or
server) for real time reporting to alleviate the real time reporting
burden off the production servers.

I was looking for any advice or pointers to design a topology that can
support our current real time systems as well as data warehousing
needs, while still minimizing the burden of reporting against our live
production servers.

The mention of replication has come to mind, but I'm not completely
sold on attempting to replicate our production data for the "heck of
it"...

Any thoughts?

Best regards,
-Sean



.

Relevant Pages
Loading