MSSQLSERVER_17130

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

17130

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

INIT_NOLOCKSPACE

Message Text

Not enough memory for the configured number of locks. Attempting to start with a smaller lock hash table, which may impact performance. Contact the database administrator to configure more memory for this instance of the Database Engine.

Explanation

Not enough memory for the desired lock manager hash table size. An attempt will be made to allocate a smaller hash table.

User Action

Check server memory configuration parameters (min/max server memory), check for memory pressures. Provide SQL Server more memory.