I have a requirement to limit the resources used by Database users so that I can limit the resource crunch faced by online users when heavy reports are run in our production database. I am planning to create 2 users and each will exclusively handle the report requests and online requests. The report request users must be limited to use 50 percent of the CPU and only 1 GB RAM. Can I achive this through the resource manager. I want the process to run at 50 percent CPU , not to stop when 50 percent is reached. Any help will be greatly appreciated.