Posted - 09/11/2013 : 13:02:13
We are setting up transactional push replication.
It has ~60 publications and each publication 2 subscribers
This is running on a Windows 2008R2 x64 server and 2008R2 sql server standard x64 w/16gb RAM.
The problem is that with so many publications/subscribes SQL server (or windows) seems to be having problems starting the sync jobs (~120 jobs).
When I restart sql agent sometimes some of the jobs don't start or just hang on "Starting agent...". Sometimes the jobs just stop, or appear to stop
I have googled the hell out of this but the only solution I find is something regarding the desktop heap size memory registry mod. Done that but no luck. The load is insignificant, we are not replicating a lot of data so that shouldn't be the problem (and isn't, latency is very low)
Any bright ideas?
Here are images of the job status: