Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhofing
Starting Member
15 Posts |
 Posted - 2003-03-24 : 13:43:09
|
| Hello, we will be implementing Transactional replication to replicate the production database to a reporting server (the reporting server will be read only). I would like to know if there is a general value for performance impact that I can use as a rough guideline.I realize there are many variables that will impact performance and only testing can give a true picture but if I could get a ball park figure this would be give me a good place to start.Thanks everyone!Ric |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-03-24 : 14:15:10
|
ummm...why are you using Transactional Replication, and not Snapshot replication? If the minimum data-latency (i.e. how old is the data that the boss can tolerate  ) is in hours rather than in seconds, you might be much better off using Snapshot replication. Replication each transaction will slow down transactions, and hogs resources. If the report-users are willing to work with data that is a couple of hours old, you might not need transaction replication.OS |
 |
|
|
|
|
|
Easy replication performance question