So I have a SQL server 2016 on a Windows Server 2012 instance. We have 140 databases(small to med). So the SQL instance was setup for self replication and in the process we have 140 SQL agent replication jobs. When the server reboots it can handle ~120 replication jobs, then when one is stopped it can not be re-started – it fails – but with no message at all – then says "between retries". In replication monitor – the agent has the red x and or is showing not running. In the event viewer I see logread.exe application crash. I was trying to research to see if there is a cap on the number of agent jobs running. Our memory is good, the disks and CPU usage is low. I have not been part of something of this size before and I am currently out of ideas. My current work around is to have a PowerShell script read the current failures and manually kick off the -Publisher [xxx] -PublisherDB [DbName] -Distributor [xxx] -DistributorSecurityMode 1 -Continuous . That is what makes me think there is a cap on the number of agents because I can run it with out the SQL-Agent. I was thinking maybe I need to change that to more of a scheduler but we have reports run that need timely info. What am I missing? Or am I right in looking to breaking up the job runs?
Sql-server – SQL Server 2016 -number of SQL agent replication jobs(transaction log repl)
sql serversql-server-agenttransactional-replication
Related Question
- Sql-server – Dedicated SQL Server instance for SQL Agent
- SQL Server – Will Transactional Replication Break with Heavy Update/Delete Queries?
- Sql-server – SQL agent jobs hung state (SSIS jobs hung)
- Sql-server – How to determine the last synchronization time for a SQL Server replication subscription
- Sql-server – Migrate replication from SQL Server 2008 R2 to SQL Server 2016 – Old to new hardware
- Sql-server – SQL Server 2016: Bidirectional Transactional Replication using Backup, Do I use/need Snapshot
Best Answer
Weird. Never had that many agent jobs running replication before. Do you have a dedicated distributor, or is it all running form the publisher?