Well, I had gone through SQL BOL. It's informative, and the reason for posting this query is - am from Data Modelling background and currently been projected as Sr DBA to the client. And in the last meeting the guys were discussing about Resource Governor, and are expecting something from me. So, thought of gaining some knowledge asap (which is wrong), and prepare an approach document and submit to client. By doing so, I can buy some time and dig deep into the requirement and work out with a proper solution.