SQL Server Agent is taking long time to start

  SQL Server Agent might take long time to start because of slow communications with Certificate Authorities.   If you enable verbose logging for SQL Server agent (-v) and look at the SQL Server agent log you will notice that ‘ANALYSISQUERY’ subsystem has taken long time to long 2012-02-15 15:42:42 – ? [124] Subsystem ‘QueueReader’…


SQL Agent MaxWorkerThreads and Agent subsystem

    In SQL Server Agent Execution of each supported job step is handled by a subsystem. Except for TSQL steps, each subsystem is handled by an external .dll file that is loaded into SQL Agent’s process at startup. Each subsystem takes information about the job step to execute and interprets it according to its…

2