When you let SQL Server and SQL Server Agent run for several days, there are many connections with the program name "SQLAgent - Temporary Worker." They are created by "sqlagent.exe," and cannot be closed.

Additionally, you notice that SQLAGENT.EXE shows elevated use of CPU time on one or more processors. Tracking the activity within SQL Server may reveal that the queries against xp_sqlagent_enum_jobs do not return any information within the time-out period.

Fixes a "ConnConnectAndSetCryptoForXpstar failed (0)" error message that occurs when you try to start the SQL Server Agent service from a Remote Desktop session. This issue occurs when the remote session ID is greater than 0.

Fixes a CPU usage issue that occurs when you run a SQL Server Agent job that runs a dynamic SELECT statement in a stored procedure in SQL Server 2008 or SQL Server 2008 R2. This issue causes a long delay when the job runs.

Fixes an issue that occurs when you run SSIS packages that contain Execute Package Tasks. Occurs when you use SQL Server Agent jobs in SQL Server 2012.

Resolves a problem in which a maintenance plan is not replicated to a SQL Server 2012 TSX server. This problem occurs when you try to create a maintenance plan on an MSX server.

After you install SQL Server 2008 SP3, the query optimizer can handle different output values for the same input value from the CRYPT_GEN_RANDOM column.

EXE toont verhoogd gebruik van CPU-tijd op een of meer processors. Wanneer u de activiteit in SQL Server bijhoudt, kunnen de query's voor xp_sqlagent_enum_jobs geen informatie binnen de time-outperiode retourneren.

Cuando permite que SQL Server y el Agente SQL Server se ejecuten durante varios días, hay muchas conexiones con el nombre de programa "SQLAgent-perdedor temporal".

Quando deixa o SQL Server e o SQL Server Agent funcionarem durante vários dias, existem muitas ligações com o nome do programa "SQLAgent - Trabalhador Temporário". São criados por "sqlagent.exe", e não podem ser fechados. O problema foi corrigido pela primeira vez na seguinte atualização cumulativa do SQL Server. Estado.