Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Unanswered: Please Help with creating rules using MoreVRP

    Hi.

    My company has purchased a new product called MoreVRP that allows us (the dba's) to allocate resources to a specific transaction in the Database.

    We have a DataWarehouse system with lots of CPU and IO bottlenecks due to ETL processes and reports. Does anyone have any experience with MoreVRP in a DW environment and can help me with defining efficient rules?

    Thank you in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Some sales critter sold some body a "silver bullet".

    Ready, Fire, Aim.

    I doubt that MoreVRP knows how to write efficient SQL; which is the only thing that can make a significant difference.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    MoreVRP is a product (according to the net) that adjusts execution priorities to allow more CPU cycles to selected processes so that your desired processos will run faster.

    see http://www.more-resource.com/index.html
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If a process is I/O bound, changing CPU priority will have little impact on elapsed run time.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2007
    Posts
    2
    Using this application i can control IO/CPU consumption per transaction.
    they have a link to video of this on their website -> Demo Video. It works pretty well and is actually quite useful for us.

    I have mainly used the Ad-hoc control up until now, but i wanted to build constant rules.

    thanks again to any helpers...

Posting Permissions

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