Starting with SQL Server 2008, a new feature called Resource Governor is introduced in the SQL Server family. The Resource Governor gives you the ability to allocate Processor and Memory resources to a specific workload. These resource limits can even