If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Resource manager

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.