17300

Product

Name

Event ID

17300

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

PROC_OUT_OF_SYSTASK_SESSIONS

Message

Text

was unable to run a new system task, either because there is insufficient

memory or the number of configured sessions exceeds the maximum allowed in the

server. Verify that the server has adequate memory. Use sp_configure with option ‘user

connections’ to check the maximum number of user connections allowed. Use

sys.dm_exec_sessions to check the current number of sessions, including user processes.

An attempt to run a new system task failed because of insufficient memory or because the

number of configured sessions in the server was exceeded.

Verify that the server has enough memory. Verify the current number of system tasks by using

sys.dm_exec_sessions, and verify the configured value of maximum user connections by using

sp_configure.

Perform the following tasks as appropriate:

Add more memory to the server.

ﾉ

Expand table