SQL Server Replication Agent priority

Posted by Wikser on Server Fault See other posts from Server Fault or by Wikser
Published on 2010-04-02T08:17:31Z Indexed on 2010/04/02 8:23 UTC
Read the original article Hit count: 326

Filed under:
|
|
|

Every hour a server replicates SQL server data with some external web server. During this time, which takes about 2-5minutes, the database seriously slows down. Colleagues, which work with the front end applications of that on another terminal server, even regularly start complaining.

The databases are also synchroniously mirrored (via SQLServer mirroring, no replication) to a third server. Note that 99% of the data is replicated outgoing, so the server should rarely need to update its data.

As the (merge and transactional) replication tasks are not time-critical, I would like to reduce their priority or somehow slow them down, so they don't affect the database performance that much.

How would you implement that?

© Server Fault or respective owner

Related posts about sql-server

Related posts about agent