Tuning DW vs. OLTP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Tuning DW vs. OLTP

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    Tuning DW vs. OLTP

    What is the top 5 tuning differentce between tuning a pretty large DW database and pretty large OLTP database?
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    1. memory
    2. disk
    3. cpu
    4. I/O
    5. performance
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Posts
    416
    Jeff I am thinking of Tuning criteria which is different in Datawarehouse env and OLTP environemt. For example one thing I kniw since DW env has lots of FTS then multiple_block_read_count init parametere needs to higher in DW env. These kind of things. Now what is top 5 tuning practice difference?
    An ounce of prevention is worth a pound of cure

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    There is no difference between tuning DW and OLTP.

    You need to first write down acceptance level of performance, and start working towards that.

    Tamil

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