SQL Server Error Msg 17149 – 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.

In this blog post, let’s learn about the error message “17149 – 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.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

17149 – 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.

Reason for the Error

To be update soon…

Solution

To be update soon…