SQL Server Error Msg 10910 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.

In this blog post, let’s learn about the error message “10910 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, 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

10910 – The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all resource pools on scheduler %u to exceed 100 percent. Reduce the value for one or more pools, or change pool affinity, so that the sum is less than or equal to 100.

Reason for the Error

To be update soon…

Solution

To be update soon…