See how Resource Governor can help you 'in action' in managing SQL Server resources?
As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption.
It will enable you to specify limits on the amount of CPU and memory that incoming application requests can use and it is configurable in SQL Server Management Studio by using TSQL statements or by using Object Explorer (for GUI users). Before that have a sneak preview on the concepts by referring to Resource Governor Concepts, also how you can do Resource Governor Monitoring with Resource Governor Workload Management Scenarios.
Recently Andrew Fryer posted about see the Resource Governor in action and I recommend to review Resource Governor How-to Topics within the books online that can help you to test the same within your environment.