Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

we're planning on running transactional replication of a part of our database for some near-time reporting.

I'm not quite sure which process will run to 'do' the replication, but is it possible to give this process a lower priority then sql server in case sql server has a heavy load, that the replication will not interfear with production crud actions?

Michel

share|improve this question

1 Answer 1

Easiest thing to do is to put the distribution database on the reporting server & have it as a configured as pull subscription to your prod db.
The 2nd option is to tweak the log reader agent parameters so that it does not generate too much overhead. This can affect how behind your reporting is from your prod.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.