 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / March 2006Best practices for reporting: Replicated servers + data warehouse server??
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 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 > Good afternoon, > [quoted text clipped - 19 lines] > Best regards, > -Sean Good morning MC, There aren't any real specific requirements at this time. But, we do have the need to ensure that real time reporting doesn't impact production systems. Apparently, there are some applications that have caused problems against performance of real time systems with some reports. I'm more of less just looking for some existing topology patterns that have been proven to satisfy the needs of the business. Our organization has about 2000 employees all over the world, and we have many systems in place, SQL Server as well as Oracle. My personal feeling is that any real time reporting be designed with performance in mind and anything else should pull from the data warehouse, with the granularity as designed into the reporting and model requirements. I wish I had a good case example, but my main motivation for approaching this issue is that another developer on our team made a proposal to actuall replicate the entire prod environment for all real time reporting. I'm having a hard time buying into that idea. Thanks for any insight! Cheers! -Sean Hi Sean, sure......there are some useful books to read on my beginners page. http://www.peternolan.com/Beginners/tabid/140/Default.aspx The best book on architecture is the Corporate Information Factory book by Bill et al. http://www.amazon.com/exec/obidos/ASIN/0471399612/qid=1035458099/sr=2-3/ref=sr_2 _3/103-5700697-6194236 Though for some reason Amazons links are not working at the moment. CIF is a well defined and well articulated architecture for designers to take into consideration when building end to end Information Infrastructure for sizable companies. Well worth reading... Peter Thank you very much Peter! I'll be checking them out today! Cheers! -Sean I have used built in SQL replication to replicate data at a few companies. I think its a great solution. > Good afternoon, > [quoted text clipped - 19 lines] > Best regards, > -Sean Was this for handling reporting needs?... Or in general. Personally, i think replication is a fine technology that works well (as long as you don't do something to break the schema or replication). But, I'm seeking advice from a corporate warehousing perspective. Also, I was hoping for some good online reference that wouldn't require me to pony up $50. :) Maybe I can convince my employer.. Cheers! -Sean For reporting. > Was this for handling reporting needs?... Or in general. Personally, i > think replication is a fine technology that works well (as long as you [quoted text clipped - 6 lines] > Cheers! > -Sean Hi Sean, lots of sites publish good materials...if you register on bill inmons site http://www.inmoncif.com/home/ you can download a lot of freebies....but you can hardly complain about the fact that for about USD500 you can now buy 8-10 very good books on BI as a small reference library.....that's about half a day of a junior consultants time from any sizable consulting company....very, very, very cheap... ;-) Peter Very true. very true indeed. Thanks for the link, btw! Unfortunately, I don't have the resources to personally dive into the investment.. I think I can convince my employer though. :) My interest in datawarehousing and this kind of enterprise design is passive, but I am very interested in learning as much as I can to help our team. Again, thank you!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.