This is one of the other similar things, which you can only tell once you have performed some kind of test.
Have you ever wondered, If transactional replication has any overhead on your Production database? and if yes, then how much really?
As transactional replication relies on reading and writing transactional logs, The answer is "YES" :)
You will notice degrade in your write performance if you have transactional replication configured!
In a scenario, where you are hosting distribution database on the separate server, I have seen write performance going bad by even 30% !! Consider a scenario, where you are inserting 100 of thousands of rows as a part of your batch process.You will be better of pausing your replication, If you want to speed up this operation.
Have you ever wondered, If transactional replication has any overhead on your Production database? and if yes, then how much really?
As transactional replication relies on reading and writing transactional logs, The answer is "YES" :)
You will notice degrade in your write performance if you have transactional replication configured!
In a scenario, where you are hosting distribution database on the separate server, I have seen write performance going bad by even 30% !! Consider a scenario, where you are inserting 100 of thousands of rows as a part of your batch process.You will be better of pausing your replication, If you want to speed up this operation.
