MSSQL: Controlling Resources

To prevent SQL Server taking up all the resource and leaving nothing to other application residing from the VM.

Right, Click Instance - Properties - Memory - Maximum server memory (in MB).

Note: leave the Processor alone unless you understand your system completely. Such as threads of dedication to certain queries.


To prevent applications from taking too many resources. Use Resource Pools.