Scenario 3

A SQL Server process ID (SPID) from the "SQLAgent - Generic Refresher" service is displayed on the database engine server. Additionally, the following job is displayed as running in the input buffer of the SPID:

EXECUTE msdb.dbo.sp_sqlagent_refresh_job

Note The SPID is in the RUNNABLE state and regularly waits for the PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type. Or, the SPID is in a waiting state for the ASYNC_NETWORKIO wait type.

For more information about products or tools that automatically check for this issue in SQL Server, see the following table:

Collapse this tableExpand this table

Rule software

Rule title

Rule description

Product versions against which the rule is evaluated

System Center Advisor

SQL Server agent startup issues with many agent jobs

System Center Advisor checks for the number of jobs on the instance of SQL Server that is enabled. Advisor generates this alert based on this condition. Review and delete the jobs which are enabled and you do not have to have.