-
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
-
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.
-
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 03:27 PM.
lucky
-
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
-
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
-
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.
-
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.
-
Originally Posted by Thomasps
(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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|