- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- HPE EVA Storage
- >
- Re: MSA2012FC Poor Performance
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
тАО07-08-2009 01:39 AM
тАО07-08-2009 01:39 AM
MSA2012FC Poor Performance
Since this device went live we have suffered performance problems where windows indicates requests are not being satisfied by the disk subsystem quick enough and high queues are seen in Perfmon among other counters that normally indicate a disk bottleneck. HP informed me that I can not go by these stats as they do no reflect the true activity on the MSA.
However, the performance displays in the MSA manager indicate figures as low as 1000 I/O's and 3 MB's at the times this is occuring.
HP are adament there is nothing wrong with the device, and the disk array is not being hammered. They asked me to run I/O meter which produced results of around 8000 I/O's and 500MB's on sequential read and write tests.
We have tried our hardest to hammer the array using I/O meter, while our DBA also hammers the disks through SQL to see if we can get the device to log an error to indicate a disk bottleneck but have not been able to do so.
How on earth are you suppost to monitor this device and decide if an array is causing a bottleneck?! Any reccomendations on a third party application would be welcome as HP Support can not give me any answers.
Thanks in advance!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 01:59 AM
тАО07-08-2009 01:59 AM
Re: MSA2012FC Poor Performance
have you updated to the latest windows storport and HBA driver?
Best regards,
Patrick
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 02:01 AM
тАО07-08-2009 02:01 AM
Re: MSA2012FC Poor Performance
I can confirm that I am running all the latest drivers from HP.
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 02:48 AM
тАО07-08-2009 02:48 AM
Re: MSA2012FC Poor Performance
do you have the same problems with fileservices? How many disks are included in the Vdisks on which are the volumes for your SQL reside?
Best regards,
Patrick
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 02:51 AM
тАО07-08-2009 02:51 AM
Re: MSA2012FC Poor Performance
We have just have 11 disks configured in a raid 5, which has 3 virtual disks. One for the quorum, and two for data.
Im aware this isnt the ideal configuration for SQL server, and need to be able to prove the array is not coping so our business can make a decision as to whether another disk shelf will make a difference.
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 03:10 AM
тАО07-08-2009 03:10 AM
Re: MSA2012FC Poor Performance
was the IOmeter run against the same disks as SQL or was it another vdisk and volumes?
SQL is doing smal IOs, the logging operation is small sequential write. RAID 5 is not optimal for such workloads (write penalty and short writes). The long queues can be a result of lots of small IOs.
Can you try a IOMeter run with the following parameters: 8 KB IOs, sequential write with two or four workers?
Best regards,
Patrick
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 04:12 AM
тАО07-08-2009 04:12 AM
Re: MSA2012FC Poor Performance
The partiton sector alignment is set to 64K as per MS reccomendations, and the array has a 64k stripe.
These resulted in the 8000 I/O's and 500Mb's figures.
I can try it with the 8k test. I have 8 3GH'z CPU's in the node. Is it worth increasing the workers to match?
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 04:24 AM
тАО07-08-2009 04:24 AM
Re: MSA2012FC Poor Performance
The 'last queue depth' value on the MSA was 2, and the last sector size read 16.
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 04:25 AM
тАО07-08-2009 04:25 AM
Re: MSA2012FC Poor Performance
the 3 MB/s at 1000 IOPS result in a average IO size of 3 KB. So it's hard for me to belive that the SQL is doing 64 KB.
Best regards,
Patrick
Patrick
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2009 06:06 AM
тАО07-08-2009 06:06 AM
Re: MSA2012FC Poor Performance
I really dont see how this can be done as the snapshot only occurs every 30 seconds, and the device can output any stats to a log file for charting?
Im dont really understand the values the device gives me too well.
Andy