Upgrade 8.03 to 9.07

Hi Cheryl,

I'm working with a sister company now going from 8.03.305k up to 9.05.700C (Progress), and hopefully by the end of the year I'll be taking my own company up from 9.04.507A to 9.05.whateveriscurrentthen (SQL).

On our 9.04 box we have both Epicor and SQL installed, this is a physical server with no virtualization. The SQL is currently 2005, and will be upgraded to 2008 during that process. We've never had a problem with server over-utilization. Our server is a Dell T910 with a 300G RAID10 array (8 75G SAS drives) and 64G RAM, 2 6-core Xeon CPUs. I don't think Epicor will EVER be "fast", but I've sure seen it be slow. In my testing so far 9.05 is demonstrably faster than 9.04. My users can't wait.

Ernie Lowell
Diba Industries
moonlighting at Labsphere

--- In vantage@yahoogroups.com, Cheryl Elliott <celliott@...> wrote:
>
> We're looking to upgrade and are wondering if anyone has suggestions for minimal server requirements. We are currently licensed for 39 users and 6 MES and we're looking to migrate from Progress to SQL. Will we require two server - 1 for application and 1 for SQL server?? What version of SQL should we use? How much memory, processors and disk space would we really need to allocate? Epicor's suggestions seem to be more than what we need. We'd like some real-world application advice.
>
> Cheryl Elliott
>
>
>
> [Non-text portions of this message have been removed]
>
We're looking to upgrade and are wondering if anyone has suggestions for minimal server requirements. We are currently licensed for 39 users and 6 MES and we're looking to migrate from Progress to SQL. Will we require two server - 1 for application and 1 for SQL server?? What version of SQL should we use? How much memory, processors and disk space would we really need to allocate? Epicor's suggestions seem to be more than what we need. We'd like some real-world application advice.

Cheryl Elliott



[Non-text portions of this message have been removed]
You can run them on the same server, it's not an uncommon setup. That said,
you need to make sure you provide adequate resources to handle the load.
Epicor's recommendations do tend to have a bit of headroom on them as they
have to account for a wide range of scenarios. A 'twenty user load' can
vary widely between companies. You can probably cut a bit off the top and
get by, but I would definitely get some hardware that will let you upgrade
easily if you find you need more juice.

Your disks will almost certainly be your bottle neck. I'd get as much as IO
as your budget allows. SSDs are cheap/large enough that I wouldn't even
consider running conventional disks. Just make sure you layout your raid
such that you're getting enough bandwidth. These things are fast enough
that you can't just shove six or eight of them on a controller without
checking for bottlenecking.

As far as recommended hardware specs, there have been several threads about
this recently. Search the list and you should find plenty of info. That
said, if you check it out and still have some questions, let us know and
we'll be happy to help.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Sep 5, 2012 at 11:38 AM, Cheryl Elliott
<celliott@...>wrote:

> **
>
>
> We're looking to upgrade and are wondering if anyone has suggestions for
> minimal server requirements. We are currently licensed for 39 users and 6
> MES and we're looking to migrate from Progress to SQL. Will we require two
> server - 1 for application and 1 for SQL server?? What version of SQL
> should we use? How much memory, processors and disk space would we really
> need to allocate? Epicor's suggestions seem to be more than what we need.
> We'd like some real-world application advice.
>
> Cheryl Elliott
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
In addition to what John has added, you may want to look into IO fusions as well. This will help with the speed of some of the applications. It is pricy, but worth it.


Michael Brown
Master Scheduler
D&S Manufacturing
mbrown@...
715-284-5376 Ext. 344
www.dsmfg.com


________________________________
From: Cheryl Elliott <celliott@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, September 5, 2012 10:38 AM
Subject: [Vantage] Upgrade 8.03 to 9.07



Â

We're looking to upgrade and are wondering if anyone has suggestions for minimal server requirements. We are currently licensed for 39 users and 6 MES and we're looking to migrate from Progress to SQL. Will we require two server - 1 for application and 1 for SQL server?? What version of SQL should we use? How much memory, processors and disk space would we really need to allocate? Epicor's suggestions seem to be more than what we need. We'd like some real-world application advice.

Cheryl Elliott

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]