MSSQLSERVER_17130

Applies to: SQL Server

Details

Attribute Value
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.