Tune Automated Administration Across an Enterprise

Applies to: yesSQL Server (all supported versions) YesAzure SQL Managed Instance


On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

Multiserver administration with Microsoft SQL Server Agent takes advantage of the self-tuning features of SQL Server. Therefore, under normal conditions, additional job tuning is not necessary. However, network loads increase when you run jobs, generate alerts, and notify operators. You can tune automated administration across an enterprise to minimize the network traffic these activities cause.

See Also

Monitoring Performance of the Data Flow Engine