What is Resource Governor in SQL Server ?
The Resource Governor is a feature given by SQL Server to control and allocate CPU and memory resources depending on the priority of applications. Resource Governor will control the allocation of CPU, Memory for the SQL Server Relational Engine Instance.