We run over 200 users and our database is 14GB in size running on an HP
Proliant with 4 Intel Xeon 3.06 processors and 4 GB of RAM with Windows
Server 2003 and Vantage 6. We did purchase a new server for Vantage 8
for when we upgrade. We too were experiencing a lot of white screens and
slowness with Vantage. We run a RAID environment similar to yours. We
came to find that the bottleneck was in Disk I/O. We purchased a 30GB
RAMSAN which is basically an all memory device that attaches to your
server via SCSI. Our database sits on this RAMSAN and it instantly
eliminated our problems, allowing the server to use more of it's
processor power and memory and not bottlenecking at the disk. It is a
high cost, but well worth it in a bigger environment.
________________________________
From: charles06072006 [mailto:shadow031449@...]
Sent: Monday, February 11, 2008 8:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Anyone out there with 100+ users & 10GB+ db
We don't have nearly that large of a database but I do know if you
are attempting to run that many users with only 4 GB of ram you are
in big trouble. If you look at the Vantage hardware sizing guide you
will see that is really on good for up to about 40 users. With that
size of database you are also doing an enormous amount of paging.
Epicor recommends memory buffers allocated to the database at 1.5
times the size of your database. That means you would need 18 GB
allocated just to the database buffers. Although that is probably
extreme I do know from experience that the more memory (within
reason) you can allocate to the database buffers the better
performance you will get. Of course, that specification is for
Vantage 8.03 but I doubt if there would be a lot of difference for
Vantage 6.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Cliff Drumeller" <cliff@...> wrote:
Proliant with 4 Intel Xeon 3.06 processors and 4 GB of RAM with Windows
Server 2003 and Vantage 6. We did purchase a new server for Vantage 8
for when we upgrade. We too were experiencing a lot of white screens and
slowness with Vantage. We run a RAID environment similar to yours. We
came to find that the bottleneck was in Disk I/O. We purchased a 30GB
RAMSAN which is basically an all memory device that attaches to your
server via SCSI. Our database sits on this RAMSAN and it instantly
eliminated our problems, allowing the server to use more of it's
processor power and memory and not bottlenecking at the disk. It is a
high cost, but well worth it in a bigger environment.
________________________________
From: charles06072006 [mailto:shadow031449@...]
Sent: Monday, February 11, 2008 8:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Anyone out there with 100+ users & 10GB+ db
We don't have nearly that large of a database but I do know if you
are attempting to run that many users with only 4 GB of ram you are
in big trouble. If you look at the Vantage hardware sizing guide you
will see that is really on good for up to about 40 users. With that
size of database you are also doing an enormous amount of paging.
Epicor recommends memory buffers allocated to the database at 1.5
times the size of your database. That means you would need 18 GB
allocated just to the database buffers. Although that is probably
extreme I do know from experience that the more memory (within
reason) you can allocate to the database buffers the better
performance you will get. Of course, that specification is for
Vantage 8.03 but I doubt if there would be a lot of difference for
Vantage 6.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Cliff Drumeller" <cliff@...> wrote:
>having
> I would like to contact other large users out there. We are
> speed issues as we have grown to 144 users and have a 12 GB+database.
> My server is a Compaq ML370 with dual 2.4 Ghz, 4 GB ram dual RaidOne
> arrays ( one for OS and Vantage, One for Vantage DB). RunningVantage 6.
>maintain
> I would like to know what other large users are doing to
> Vantage speed. There are times when users sit for 30 seconds orlonger
> waiting for a new screen to come up. That used to take less than 5this ?
> seconds.
>
> I have ten years of data. Would a purge /dump and reload be
> worthwhile ? What kind of speed increase have others seen from
>[Non-text portions of this message have been removed]
> Cliff Drumeller
> IT Manager
> Mass Precision Sheetmetal, Inc.
> 408 786 0348
> 408 314 7420 Cell
>
>
> [Non-text portions of this message have been removed]
>