Epicor 9 and SSD

Yahoo Archive
1
I agree with Brian, I wouldn't use SSDs for an OS drive in a server. On a workstation maybe to speed up boots, but boot time on servers is rarely an issue. SSDs on a RAID 10 array is spot on. Yes, you're better off with the 15k SAS drives in a RAID1 for boot. Remember a decent conventional array can still beat SSDs in sequential writes, so a separate RAID 10 is a great place for LOG files and your PAGEFILE. These don't have to be screaming SAS drives. I use 7200 rpm SATA here.

An interesting phenomenon has started to take over in the storage world. With the introduction of massive 2 TB drives, the aerial density of the magnetic sectors has a greater influence than raw rotational speed. Basically a 2TB SATA drive can keep pace with a 300GB 15k rpm SAS drive.
Cheers,
Jared

--- In vantage@yahoogroups.com, "Robert" <robert.nupp@...> wrote:
>
> What are your thoughts on using SSD's for the OS partition using a Raid 1 and then a DB partition using a Raid 10? Would I be better off using 15k SAS drives for the OS and then SSD's for the Raid 10?
>
2
Is anyone using Solid State Drives on their database server with their Epicor 9 installation? I am looking to talk to someone who has experience with SSD and/or is currently using them on their Database Server for Epicor 9.
3
Using SSD's for Vantage 8.03
Chris

--- On Tue, 8/31/10, Robert <robert.nupp@...> wrote:

From: Robert <robert.nupp@...>
Subject: [Vantage] Epicor 9 and SSD
To: vantage@yahoogroups.com
Date: Tuesday, August 31, 2010, 5:23 PM
















Â









Is anyone using Solid State Drives on their database server with their Epicor 9 installation? I am looking to talk to someone who has experience with SSD and/or is currently using them on their Database Server for Epicor 9.






























[Non-text portions of this message have been removed]
4
How long have you been using SSD's? Were you using regular disks prior to the SSD's? If so, did you notice any significant increase in performance. What is your setup like (how many drives, server specs, raid, etc...)? Is there any "special" maintenance you need to perform with using the SSD's (Trim function on the drives).

We are in the process of purchasing a new server for our upgrade to Epicor 9 and I would like to go the route of SSD. I would like some insight as to whether the costs are worth it before taking the plunge. Any additional information you can provide would be much appreciated. Thank you.

Robert Nupp

--- In vantage@yahoogroups.com, xorone <xorone@...> wrote:
>
> Using SSD's for Vantage 8.03
> Chris
>
> --- On Tue, 8/31/10, Robert <robert.nupp@...> wrote:
>
> From: Robert <robert.nupp@...>
> Subject: [Vantage] Epicor 9 and SSD
> To: vantage@yahoogroups.com
> Date: Tuesday, August 31, 2010, 5:23 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ÂÂ
>
>
>
>
>
>
>
>
>
> Is anyone using Solid State Drives on their database server with their Epicor 9 installation? I am looking to talk to someone who has experience with SSD and/or is currently using them on their Database Server for Epicor 9.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Also using SSD on 8.03.408b. Absolutely worth the cost! I have 8 Intel X25-E SLC based 64GB drives on an Adaptec 5805 controller configured in RAID 10. Only the DB data files live there. I have a separate conventional disk RAID 10 array for the DB log files and TempDB (I think Progress equivalent is .B1 file, but don't hold me to that). OS drives are two WDC Velociraptors in RAID1.

If I were to do it again today I would probably go with a PCI Express based SSD. FusionIO is the vendor that innovated here first, and offers SLC and MLC based flavors. You pay a premium for those guys. Other vendors like OCZ have come out with more affordable versions. You can start to touch those in the $1100 range last I looked.

If you go with SATA drives, the current king of the hill in the performance department is the Micron P300 series. Intel is expected to ship SandForce based SSDs (which will probably nudge out the Microns) in Q1 2011. SSDs do wear out, but that is not realistically a concern if you treat them right and don't unnecessarily overabuse them. For example, don't put the OS page file on the SSD. I also encourage SLC over MLC, but MLC has made some tremendous strides in the last few months.

Here's a very technical write up I did on SSDs a while back.
http://tech.groups.yahoo.com/group/vantage/message/86114
Cheers,
Jared
6
Just came across this article. Targeted more at PC desktop enthusiast's, but an interesting read.
http://www.tomshardware.com/reviews/windows-7-ssd-trim,2705.html
7
What are your thoughts on using SSD's for the OS partition using a Raid 1 and then a DB partition using a Raid 10? Would I be better off using 15k SAS drives for the OS and then SSD's for the Raid 10?

--- In vantage@yahoogroups.com, "k99ja04" <jallmond@...> wrote:
>
> Also using SSD on 8.03.408b. Absolutely worth the cost! I have 8 Intel X25-E SLC based 64GB drives on an Adaptec 5805 controller configured in RAID 10. Only the DB data files live there. I have a separate conventional disk RAID 10 array for the DB log files and TempDB (I think Progress equivalent is .B1 file, but don't hold me to that). OS drives are two WDC Velociraptors in RAID1.
>
> If I were to do it again today I would probably go with a PCI Express based SSD. FusionIO is the vendor that innovated here first, and offers SLC and MLC based flavors. You pay a premium for those guys. Other vendors like OCZ have come out with more affordable versions. You can start to touch those in the $1100 range last I looked.
>
> If you go with SATA drives, the current king of the hill in the performance department is the Micron P300 series. Intel is expected to ship SandForce based SSDs (which will probably nudge out the Microns) in Q1 2011. SSDs do wear out, but that is not realistically a concern if you treat them right and don't unnecessarily overabuse them. For example, don't put the OS page file on the SSD. I also encourage SLC over MLC, but MLC has made some tremendous strides in the last few months.
>
> Here's a very technical write up I did on SSDs a while back.
> http://tech.groups.yahoo.com/group/vantage/message/86114
> Cheers,
> Jared
>
8
I can't see why you'd want SSD for OS drives. Once the system has
booted the OS partition shouldn't see a lot of I/O.

Folks often put the pagefile on the boot drive as well, and you
wouldn't want a pagefile on the SSD drive because of wear issues as
Robert noted below.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert
Sent: Thursday, September 02, 2010 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 and SSD

What are your thoughts on using SSD's for the OS partition using a Raid
1 and then a DB partition using a Raid 10? Would I be better off using
15k SAS drives for the OS and then SSD's for the Raid 10?

--- In vantage@yahoogroups.com, "k99ja04" <jallmond@...> wrote:
>
> Also using SSD on 8.03.408b. Absolutely worth the cost! I have 8
Intel X25-E SLC based 64GB drives on an Adaptec 5805 controller
configured in RAID 10. Only the DB data files live there. I have a
separate conventional disk RAID 10 array for the DB log files and TempDB
(I think Progress equivalent is .B1 file, but don't hold me to that).
OS drives are two WDC Velociraptors in RAID1.
>
> If I were to do it again today I would probably go with a PCI Express
based SSD. FusionIO is the vendor that innovated here first, and offers
SLC and MLC based flavors. You pay a premium for those guys. Other
vendors like OCZ have come out with more affordable versions. You can
start to touch those in the $1100 range last I looked.
>
> If you go with SATA drives, the current king of the hill in the
performance department is the Micron P300 series. Intel is expected to
ship SandForce based SSDs (which will probably nudge out the Microns) in
Q1 2011. SSDs do wear out, but that is not realistically a concern if
you treat them right and don't unnecessarily overabuse them. For
example, don't put the OS page file on the SSD. I also encourage SLC
over MLC, but MLC has made some tremendous strides in the last few
months.
>
> Here's a very technical write up I did on SSDs a while back.
> http://tech.groups.yahoo.com/group/vantage/message/86114
> Cheers,
> Jared
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links