The company that I am working for is looking at doing a data upgrade on a database to go from one version of an application to the next (Axapta 3 to Ax 2009). This process is very IO intensive and with our current setup will take a few days. We currently have a HP Lefthand SAN with 24 450GB 15k disks. We are running the SAN over iSCSI (2x 1gb nics) which limits us to a max through put of about 100MB/s.
We are currently looking for ways to increase the IO performance for the duration of the upgrade. The server that will be running the upgrade will be a HP DL360 G7, which has 8 SAS ports and a HP p410i RAID controller.
We only need about 400GB space for the data and the log-files.
We we thinking about maybe getting 8 SSD's add putting them in the server and setting up a RAID 10 array just for the weekend. I have read that the performance of consumer SSD's degrade when doing lots of write operations. As we only need this solution to work for just one weekend, should I be worried about this if we purchase consumer grade SSD's? Would the Intel X25-M series disks be okay or should we go for the X25-E.