SQL Server Error Msg 10927 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all workload groups using resource pool ‘%.*ls’ to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.

In this blog post, let’s learn about the error message “10927 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all workload groups using resource pool ‘%.*ls’ to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

10927 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all workload groups using resource pool ‘%.*ls’ to exceed 100 percent. Reduce the value or modify other workload groups so that the sum is less than or equal to 100.

Reason for the Error

To be update soon…

Solution

To be update soon…