We tried SSD's on Citrix first, worked great. Many of our directs went to Citrix because of the speed improvement. Now we're live with SSD's on Epicor Server. They don't speed up everything, like MRP, assume because most of the data in memory already. We're on 9.05.606 SQL-Regular x32 with 48gb RAM and a database size of 16gb.
----- Original Message -----
From: "Zac Jason Woodward" <zac@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, October 11, 2011 1:52 PM
Subject: RE: [Vantage] Dump and Load of a Database
SSD's are great, but costly. It is still not considered mainstream. As for reliability I would only do RAID 10 as they are new enough to the market that there is no proof of longevity. IN theory they can last about 5 years on a heavy load server before the known Read/write issues start to cause it to fail.
For conversions and dump/load I wouldn’t hesitate to use them.
"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com
Creating customer confidence through extraordinary service and experienced industry experts.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Nick
Sent: Tuesday, October 11, 2011 2:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Dump and Load of a Database
Zac, are SSD's the way to go now? That much of a difference?
On Tue, 11 Oct 2011 14:33:36 -0600
Zac Jason Woodward <zac@...<mailto:zac%40ie-corp.com>> wrote:
Purchase 2 solid state drives, raid 0. install everything
on it.
On your existing setup try moving the page file to the
RAID 10 array. You do not want it on the slower drives
that may be hosting the OS.
"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com
Creating customer confidence through extraordinary
service and experienced industry experts.
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of jillschoedel
Sent: Tuesday, October 11, 2011 2:15 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dump and Load of a Database
Hi,
I am currently running a Dump and Load on our Test
Database. It is close to 24 GB in size. This database
usually runs on a server that has one 2 Ghz Quad core
processor and 12 GB of RAM. I have the database spanned
across 3 - 232.89 GB drives and there is 410 GB of free
space on this spanned drive. I thought it would be good to
do the dump and load of this database on a faster server.
The faster server has two 2.66 Ghz Quad core processors
and 32 GB of RAM. I have the database spanned across 8 -
72 GB drives in a RAID 10 and there is 208 GB of free
space on the RAID 10 drive. The Dump and Load seems to be
taking more time to complete the Loading of Data in Step 5
of the Epicor instructions than on the faster server than
the slower server. It seems to be taking 2 1/2 days to do
the Dump and Load of the 24 GB database on either of these
servers. Is this normal? Our LIVE server has 4 - 6 core
processors and 64 GB of RAM. Will it take that long to do
on our LIVE server as well? Does anyone have any
experience with this? Is there anything I can do to speed
this up on any of our servers? Any help or advice would be
wonderful.
Thanks,
Jill Schoedel
Metalworks
(231)845-3148
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1831 / Virus Database: 2090/4546 - Release Date: 10/11/11
[Non-text portions of this message have been removed]