Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question

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


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.