MSSQLSERVER_17300

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

17300

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

PROC_OUT_OF_SYSTASK_SESSIONS

Message Text

SQL Server 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.

Explanation

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.

User Action

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.

  • Terminate one or more sessions.

  • Increase the maximum number of user connections allowed on the server.

See Also

Reference

sp_configure (Transact-SQL)

sys.dm_exec_sessions (Transact-SQL)

KILL (Transact-SQL)

Concepts

Server Configuration Options (SQL Server)

Configure the user connections Server Configuration Option