Resource manager
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Resource manager

  1. #1
    Join Date
    May 2005
    Location
    Michigan
    Posts
    1

    Lightbulb 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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    yes you can use resource manage to give them a percentage of the cpu and it wont kick them off, just limit them to an amount.

    You cant control memory with resource manager, you could do it with some alter sessions through controlling sort areas and the like.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width