- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- StoreVirtual Storage
- >
- P4000 noob questions
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
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
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-12-2013 06:47 AM - last edited on 09-15-2013 08:00 PM by Liuqing
09-12-2013 06:47 AM - last edited on 09-15-2013 08:00 PM by Liuqing
P4000 noob questions
Hi folks,
We have a 3-node HP DL380 G7 cluster ( ESXi 5.0 ) with attached P4000/iSCSI SAN with basically 2 volumes configured. One is RAID-10 and the other RAID-5 single parity.
We recently moved a SQL app from bare metal ( Dell 2900/Windows 2003/RAID 0+1 or RAID10, not sure which) to a W2003 VM using the RAID-5 device as storage for the SQL DB. We have been getting some "feedback" that there is a perf issue with some of the batch jobs. The answer I'm sure is obvious, move them to RAID-10. However what, if anything, can be done to perhaps improve the RAID-5 performance?
I have seen some articles recommending cached I/O vs Direct, as well as setting the read/write cache to 30-70 or even 20-80. Is this possible on a P4000? If so, where? Additionally, I have seen a recommendation to disable read cache on the LUN itself?!
My suspicion is that there is little that can be done to tune the RAID-5 set further and that the perf hit is simply the nature of the beast.
Any/all feedback and input is greatly appreciated.
Thanks in advance.
BuddyD
P.S. This thread has been moved from Storage > General to HP StoreVirtual Storage / LeftHand.
-HP Forum Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2013 12:20 AM
09-26-2013 12:20 AM
Re: P4000 noob questions
You better move the SQLDB from the Network-RAID 5 to a Network RAID 10 volume.
HP recommends to use Network-RAID 5 only for archive type of data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2013 10:09 AM
09-26-2013 10:09 AM
Re: P4000 noob questions
in addition... how many P4000 nodes do you have? Unless you have MANY, you really won't get much increase in space between NR10 and NR5 and the performance impact from NR5 is huge so other than increquently used static archives you really want to stick with NR10.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2013 08:14 AM
10-29-2013 08:14 AM
Re: P4000 noob questions
Thanks very much, yes I agree the issue is most likely R5.