Timeline for SQL Server 2016 -number of SQL agent replication jobs(transaction log repl)
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 1, 2020 at 16:30 | comment | added | Mike Petri | You may want to consider adding a dedicated distributor, if you have a standard 2012 license laying around. 2008 might even work in a pinch. We did and it took an incredible amount of load off of the publisher. | |
| Oct 1, 2020 at 12:19 | comment | added | tbear58203 | So everything is running from one dedicated SQL instance with publisher and distributor all on one instance. I am thinking about adding more publishers to handle the load - never seen this many replication jobs all on one server. | |
| Sep 30, 2020 at 22:12 | history | answered | Mike Petri | CC BY-SA 4.0 |