topic Re: Bad performance EVA3000 and SQL2k and Exchange2k server in Disk Enclosures

Bad performance EVA3000 and SQL2k and Exchange2k server

Marc van den Boomen — Fri, 23 Sep 2005 06:36:18 GMT

My SQL server performs bad on a EVA3000. Due to costs we have a RAID5 on the EVA3000 (we know this is giving poor performance), but I have read that you acn align track on the disk with diskpar.exe.
Does anybody know how may sectors are there on a track in the EVA3000 SAN? How can I align my VDISK with diskpar?

Re: Bad performance EVA3000 and SQL2k and Exchange2k server

Stephen Kebbell — Fri, 23 Sep 2005 06:49:07 GMT

Hi Marc,

here's an advisory from HP:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=PSD_OI040301_CW02&prodTypeId=12169&prodSeriesId=377751&locale=en_US

Regards,
Stephen

Re: Bad performance EVA3000 and SQL2k and Exchange2k server

Steven Clementi — Fri, 23 Sep 2005 10:17:09 GMT

Marc:

The default is 63. Make sure you have a backup of the data before using diskpar, unless you do not need the data. Diskpar WILL make your disk useless until you format it again.

Also, make sure you do a FULL format, not a quick format when your done with diskpar.
Exchange tends to work better on drives that have been fully formatted, that is... Exchange Performance is better.

Steven