SQL Server Errors or Failures from Error: 17149 to Error: 17173

SQLServerF1

 

Error: 17149, Severity: 10, Using the static lock allocation specified in the locks configuration option. Allocated %I64u Lock blocks and %I64u Lock Owner blocks per node. This is an informational message only. No user action is required.
Error: 17150, Severity: 10, Lock partitioning is enabled. This is an informational message only. No user action is required.
Error: 17152, Severity: 10, Node configuration: node %ld: CPU mask: 0x%0*I64x:%u Active CPU mask: 0x%0*I64x:%u. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

Error: 17153, Severity: 10, Processor affinity turned on: node %d, processor mask 0x%0*I64x. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.
Error: 17155, Severity: 10, I/O affinity turned on, processor mask 0x%0*I64x. Disk I/Os will execute on CPUs per affinity I/O mask/affinity64 mask config option. This is an informational message only; no user action is required.
Error: 17156, Severity: 16, initeventlog: Could not initiate the EventLog Service for the key ‘%s’, last error code is %d.
Error: 17158, Severity: 10, The server resumed execution after being idle %d seconds. This is an informational message only. No user action is required.
Error: 17159, Severity: 10, The server is idle. This is an informational message only. No user action is required.

Error: 17161, Severity: 10, SQL Server could not use the NO_BUFFERING option during I/O, because the master file sector size, %d, is incorrect. Move the master file to a drive with a correct sector size.
Error: 17162, Severity: 10, SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
Error: 17163, Severity: 10, SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
Error: 17164, Severity: 10, SQL Server detected %d sockets with %d cores per socket and %d logical processors per socket, %d total logical processors; using %d logical processors based on SQL Server licensing. This is an informational message; no user action is required.
Error: 17165, Severity: 10, The RANU instance is terminating in response to its internal time out. This is an informational message only. No user action is required.
Error: 17166, Severity: 10, Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
Error: 17167, Severity: 10, Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using the minimal configuration option. This is an informational message only. No user action is required.
Error: 17169, Severity: 10, Unable to locate kernel HTTP driver Httpapi.dll in path. SQL Server native HTTP support is not available. Error: 0x%lx Your operating system may not support the kernel HTTP driver.
Error: 17170, Severity: 10, SQL Server native HTTP support is not available. Could not find function entry point ‘%hs’ in %hs. Error 0x%lx. Native HTTP access to SQL Server requires a later version of the operating system.
Error: 17171, Severity: 10, SQL Server native HTTP support failed and will not be available. ‘%hs()’ failed. Error 0x%lx.
Error: 17172, Severity: 16, SNIInitialize() failed with error 0x%lx.
Error: 17173, Severity: 10, Ignoring trace flag %u specified during startup. It is either an invalid trace flag or a trace flag that cannot be specified during server startup.

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 *