partitioned tables on SAn drives
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: partitioned tables on SAn drives

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    partitioned tables on SAn drives

    We've recently purchased new servers with SAN drives as auxiliary storage in addition to auxilary storage on server.
    Question is:
    will table and index partitioning be of any use if RAID 5 is implemented??
    lucky

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    You partition either to help query performance or help during purge processes.

    Why would RAID 5 storage have any impact on that?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    my issue is query performance.
    see:
    1. if v use a 4 disk RAID 5, 3 of them will keep data blocks n 1 will be parity(distributed) block.
    2. i make 4 partitions of a table. if i dont use RAID structure, then i cud have reduced I/O by allocating 4 partitions to 4 diff tablespaces(datafiles corresponding to each tablespace could be kept on a diff disk).
    3. same 4 partitions of a table with RAID 5 structure..Wen all data is striped, then we cant assure dat queries specific to 1 partiton will access only 1 disk. Thus wen queries corresponding to each partition execute simultaneously, there may be contention for disk controller, thus affecting the query performance.
    Last edited by mahajanakhil198; 03-07-2009 at 02:27 PM.
    lucky

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you only have a finite number of disk controllers anyway

    do you really understand RAID, and how it has no impact the way you can setup your database

  5. #5
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    yes i do understand RAID but I dont know how RAID affects database setup in anyway..
    As I thought it cud have an impact on performance of queries on partitioned objects in my previous post in this thread. So, dont know much abt its impact on partitoned tables , but it is recommended by oracle too dat it is generally not a good idea to have redologs on striped disks that use RAID 5.
    lucky

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I'm not following what could be the relationship in between redologs and partitioned tables.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Just some 'tips' won't work when come to database implementation. You should know everything from Oracle, System, OS to application. Otherwise you will be creating bottlenecks in one or other place. I saw one application which was working faster in a normal PC but failed to achieve the same performnace in a high end server (interestingly the server was installed by the Vendor, one of the global gaint the market!) just because of RAID-5 and lower RAID Controller memory along with smaller stripe size.

    So, "I don't know " will lead to another round of end user performance complaints. Grab DBAs / Application Architects/ SYS Admin and discuss with them. Good luck.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Quote Originally Posted by Thomasps View Post
    (interestingly the server was installed by the Vendor, one of the global gaint the market!)
    i can smell whom you may be hinting at :-)
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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