- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- Autoraid performance problems with oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2000 12:56 AM
тАО09-07-2000 12:56 AM
Autoraid performance problems with oracle
On this array we have created an Oracle database with a total storage of 35 Gb. The database is spread over two LUNS of 23 Gb each with crossed primary / alternate SCSI controllers. The unallocated space would be about 14 Gb. After creating the database we saw that all the database files are written in RAID 5 and not in RAID 1. When we created it the RAID 0/1 space was a several 100 Mb?s.
Above is a test situation for the porting of one of our applications to HP-UX and Oracle. When we go in production the unallocated space for the autraid would be ? 70 Gb.
The question is now : is there a way to get de databasefiles default written in RAID 0/1 even as the RAID 0/1 space allocated is just a several 100 Mb?s and the write working set is in GB (logprint info)
Please tell what i must do to get a good performance from the start.
Cees Wielink
Netherlands
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2000 06:15 AM
тАО09-07-2000 06:15 AM
Re: Autoraid performance problems with oracle
When we reconfigured our 12H and restored the data the initial raid 0/1 space started at 9Mb (from a previous 25000Mb). This has increased to 22000Mb at present. I have included the script I use to monitor this build-up.
This is what the 12H will do automatically and over which the user has no control. If you want the 12H to start out with a large Raid 0/1 space I suggest you give it something to do (start copying files, fill up the volumes, delete the files again) and you will see Raid 0/1 space grow automatically. Using Logprint you can monitor the Raid 5 to 1 reallocation info to see how it is doing.
Other than this, I know of no other way to 'force the 12H' to go to a specific state. This, in fact, is also what the 12H was designed for, to take that job out of the hands of the administrator. Something, I must admit, is/was not always to my liking.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2000 08:16 PM
тАО09-07-2000 08:16 PM
Re: Autoraid performance problems with oracle
In general the AutoRAID manages the 0/1 space for you. You do not have any control over it. In general the more LUNs the better. Here is some additional info:
Optimizing Performance
Disk array performance is influenced by many factors, some host-related, some related to the configuration
of the disk array itself. Host-related disk array performance issues can typically be identified and corrected
using operating system utilities or third-party applications designed for this purpose.
The following list identifies some of the factors that directly influence disk array performance. Other
factors, such as a rebuild, can temporarily affect array performance.
+ Amount of available RAID 0/1 ? In most cases, the more RAID 0/1 space available, the better the
disk array performance. With enough RAID 0/1 space, the disk array can service all write I/Os from
RAID 0/1, thus allowing an optimum write working set. RAID 0/1 space can be increased by
increasing the amount of unallocated capacity on the disk array.
+ Enabling Active Hot Spare ? With Active Hot Spare enabled, the disk array can recover quickly from
a disk failure without the need for any action on your part. This maintains performance because while
the disk array is operating in non-redundant or critical mode, performance decreases. Active Hot Spare
provides an additional performance benefit because it is used as RAID 0/1 space until a disk fails.
+ Amount of cache DRAM ? Increasing the amount of cache DRAM can alleviate bottlenecks that may
form in the controller data path. This increases the rate at which the disk array can service host I/Os.
+ Proper disk module installation ? Installing the disk modules in the correct slots in the enclosure
distributes the disks across the internal SCSI busses and balances the I/O load properly. Disk modules
should be installed from left-to-right, top-to-bottom.
+ Keep the disk capacity small ? Having twelve disks with smaller capacities will improve the
performance as compared to having twelve disks with larger capacities.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2000 10:50 PM
тАО09-07-2000 10:50 PM
Re: Autoraid performance problems with oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-08-2000 01:04 PM
тАО09-08-2000 01:04 PM
Re: Autoraid performance problems with oracle
I have two AutoRaid 12H's and I have never really been pleased with their performance. It is partially because of the Raid 0/1 and Raid 5 issue and partially because the SCSI bus to the system is FWD/DIFF and the internal SCSI bus is SE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2000 05:04 AM
тАО09-10-2000 05:04 AM
Re: Autoraid performance problems with oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2001 07:22 AM
тАО01-22-2001 07:22 AM
Re: Autoraid performance problems with oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2001 10:15 AM
тАО01-22-2001 10:15 AM
Re: Autoraid performance problems with oracle
Indeed, since it is AUTOraid you do not have control about RAID levels (with an FC-60 or XP, you would have). If you need everything in RAID 0/1 than do not assign more than:
12*18GB minus 1* 18Gb (for hot spare) and take 50% of this= 99Gb to LUNS.
Creating 2+ LUNS in the volumegroup and striping across the LUNS can speed up I/O's.
At this moment your database is in RAID 5, but the autoraid will balance itself (when there's none/few I/O traffic), your database might be in RAID 0/1 in a few days time. The autoraid will try to keep the least accessed data in RAID 5 to get full performance and the most frequent accessed data (which will be in 0/1).
Regards,
Mark