Raid5 will kill the speed of any database, write speeds on raid5 are too slow. We run Vantage on a server with the system partition setup as a mirrored set, database and vantage app files located on a raid10 array. using a higher number of drives in a raid10 array will increase performance. our system runs great
--- In vantage@yahoogroups.com, "randyduly" <randy.duly@...> wrote:
>
> Hi -
>
> You mentioned RAID-5 at the beginning of your email. Everything I read said don't use RAID-5 because of performance issues. Use RAID-10 instead. Are you using RAID-5 anywhere?
>
> --- In vantage@yahoogroups.com, "mseal" <mseal@> wrote:
> >
> > Over the last month we have been working on optimizing Vantage in every way possible.
> > Wanted to share with all our findings and hear from others if there are any other suggestions.
> > Would be nice if Epicor continued to test and publish all aspects related to performance tuning as many of us complain about the issue but don't receive much help.
> >
> > First our environment:
> > Vantage 803.404B – over 80 regular + MES licenses
> > MS-SQL dB (2005)
> > VMWare (ESX 4.0)
> > Cluster of Dell servers (1950) with 2 X Quad core and plenty of memory
> > EMC SAN configuration has 3 storage levels – RAID-10 RAID5 on 15K SAS and RAID5 on SATA drives with 3 full shelves of drives to spread drive/spindle load.
> >
> > Epicor application server on Windows 2003 Enterprise with 8Gb
> > SQL on 2003 STD addition
> >
> > In general we were not happy with system performance starting with Print Preview to night processes (MRP/PO Gen ..) to regular transactions.
> > We evaluated client, server and systems to come up with best possible performance.
> > After applying all changes we have realized a cut in the time to perform different processes and transactions form 25% to over 80%
> > Here are the area we reviewed and the we found helpful – I have marked (*) the ones most beneficial
> >
> > Client Computers:
> > 1 – ensure AV does not scan Client folder
> > 2 – change system monitor settings – this may increase print preview performance by 50%
> > 3 – set all users to `can suspend' - help eliminate client disconnects
> > 4 – set all NICs to no power off - help eliminate client disconnects
> > 5 – min memory – 2Gb
> > 6 – difrag HD
> >
> > SQL server:
> > 1 – move tempdb to RAID10
> > 2 – don't scan MDF & LDF files (SQL)
> > 3 – consider RAW device mapping (VMWare)
> > 4 – move SQL to 64-bit server and OS to 64-bit ***
> > 5 – move server to latest CPU ***
> > 6 – verify SQL index optimization
> >
> > Application server:
> > 1 - Setup with separate print server **
> > 2 - Upgrade to 803.409
> > 4 –Move app server on 64-bit *
> >
> > Chipset tested Xeon X5355 2.66Ghz and Xeon X5570 2.9Ghz
> >
> >
> > If you want to know anything else regarding this study please post here
> > Thanks
> > Motty
> >
>