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

Thread: Resource manager

  1. 05-04-2005, 04:41 PM #1
    arunnair
    arunnair is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 05-04-2005, 04:50 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width