March 12, 2004 at 5:49 pm
To all replication experts
I am looking at a business intelligence project for a client that just implemented several Peoplesoft modules using a SQL Server DB. The production DB is undersized and their IT department is convinced they need a datawarehouse for reporting purposes.
Upon digging a littel deeper, this organization is looking for basic reporting using parameter driven reports for the masses (not only that they need to walk before they run). Therefore, and I plan to propose a replication solution. We have not discussed the frequency for replication but let's assume at least nightly with the possiblity of as often as hourly updates. No data transformation is necessary. I have used SQL Server for many years but I have not previoulsy implemented replication. Questions:
1. I transaction replication the best solution? I'd like to propose a solution that puts the least amount of load on the production DB.
2. I would appreciate any insights and especially any white papers you may have to guide the decision on the type of replication and/or the success of similar projects.
Thank you
Mardy Gazzo
720-260-1208
March 14, 2004 at 11:58 am
I have a similar situation and to lessen the load on the server, we have used the target server as the distributor and publisher. This means all the replication processes run on it and the only extra load on the source server is the reading of the log by the log reader.
March 14, 2004 at 7:36 pm
I agree that moving the distributor will reduce the load, but for the most part the load generated by transactional replication is not huge.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply