SQL Server Errors or Failures from Error: 17128 to Error: 17148

SQLServerF1

 

Error: 17128, Severity: 16, initdata: No memory for kernel buffers.
Error: 17129, Severity: 10, initconfig: Warning: affinity specified is not valid. Defaulting to no affinity. Use ALTER SERVER CONFIGURATION SET PROCESS AFFINITY to configure the system to be compatible with the CPU mask on the system. You can also configure the system based on the n
Error: 17130, Severity: 16, 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.

Error: 17131, Severity: 16, Server startup failed due to insufficient memory for descriptor hash tables. Reduce non-essential memory load or increase system memory.
Error: 17132, Severity: 16, Server startup failed due to insufficient memory for descriptor. Reduce non-essential memory load or increase system memory.
Error: 17133, Severity: 16, Launch of startup procedure ‘%s’ failed.
Error: 17135, Severity: 10, Launched startup procedure ‘%s’.
Error: 17136, Severity: 10, Clearing tempdb database.
Error: 17137, Severity: 10, Starting up database ‘%.*ls’.
Error: 17138, Severity: 16, Unable to allocate enough memory to start ‘%ls’. Reduce non-essential memory load or increase system memory.

Error: 17139, Severity: 10, The SQL Server image %ls was allocated using the large pages option.
Error: 17140, Severity: 16, Could not dispatch SQL Server by Service Control Manager. Operating system error = %s.
Error: 17141, Severity: 16, Could not register Service Control Handler. Operating system error = %s.
Error: 17142, Severity: 16, SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or the Services application in Control Panel.
Error: 17143, Severity: 16, %s: Could not set Service Control Status. Operating system error = %s.
Error: 17144, Severity: 10, SQL Server is not allowing new connections because the Service Control Manager requested a pause. To resume the service, use SQL Computer Manager or the Services application in Control Panel.
Error: 17145, Severity: 10, Service Control Handler received an invalid control code = %d.
Error: 17146, Severity: 10, SQL Server is allowing new connections in response to ‘continue’ request from Service Control Manager. This is an informational message only. No user action is required.
Error: 17147, Severity: 10, SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Error: 17148, Severity: 10, SQL Server is terminating in response to a ‘stop’ request from Service Control Manager. This is an informational message only. No user action is required.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *