It was a nightmare when DBA has to keep an eye on resource utilization, thanks to Resource Governor which provides control of resources on finger tips.

Resource Governor or RG is SQL Server 2008's new feature through which one can easily manage system resources like CPU, I/O. With RG you can define resource limits, priorities and enable consistent performance.

By executing this statement you can limit the percentage usage CPU utilization for certain SQL Server group to 50.

ALTER WORKLOAD GROUP grpDev WITH ( MAX_CPU_PERCENT = 50 )

You can also try and see how easy it is to manage the system resources, but only if you have the latest CTP.

You can only execute this command on the latest CTP, if you've not downloaded yet then do so.

Bandagi!