SQL Server Error Msg 8657 – Could not get the memory grant of %I64d KB because it exceeds the maximum configuration limit in workload group ‘%ls’ (%ld) and resource pool ‘%ls’ (%ld).  Contact the server administrator to increase the memory usage limit.

In this blog post, let’s learn about the error message “8657 – Could not get the memory grant of %I64d KB because it exceeds the maximum configuration limit in workload group ‘%ls’ (%ld) and resource pool ‘%ls’ (%ld).  Contact the server administrator to increase the memory usage limit.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8657 – Could not get the memory grant of %I64d KB because it exceeds the maximum configuration limit in workload group ‘%ls’ (%ld) and resource pool ‘%ls’ (%ld).  Contact the server administrator to increase the memory usage limit.

Reason for the Error

To be update soon…

Solution

To be update soon…