Have an environment that has dozens of SQL instances all running SQL agent jobs for their own maintenance as well as other processes (etl, etc.) but considering a change to consolidate the non-maintenance jobs to a separate sql instance(s). Thinking that having the SQL agent job processing setup on centralized servers would be easier to manage and coordinate job's schedules. Would also plan on using one of these sql agent only instances as the distributor for replication purposes.
Besides licensing concerns what downside would there be to move to such a configuration?
Aucun commentaire:
Enregistrer un commentaire