5.0 Performance Question

Yahoo Archive
1
William

According to Support, our server should be fine, but....

Our server
Dual Pentium Pro 200 MHz
896 MB RAM
6- 9 GB Drives - 3 mirrored sets with Raid Ctrl
Vantage on its own drive - 4 GB Free space
Database size is 1.62 GB
all extents, b1, b2, d1, d2,.. in the same directory
Data - 3 500 MB extents, 1 variable
BI - 1 256 MB extent, 1 variable
8K Block size for DB
-SPIN setting is 1000, have also tried 2000
-B 40000 (320 MB), have also tried 60000
30 Vantage Users

Vantage specs say NT Server with

Windows NT Server 5.0 Service Pack 5 or higher --> SP6a (on all NT Srv, WS)
Windows 2000 Server --> N/A
Pentium 200 or higher --> Dual
200 Pent Pro
128 MB RAM, plus an additional 2 MB of RAM for every user on your
ystem. --> 896 MB
500 MB free disk space.
For optimum performance, Epicor recommends 1 GB of available disk
pace. --> 4 GB
VGA or higher adapter w/color --> OK
3.5" floppy diskette drive --> OK
CD-ROM drive --> OK
RAID level 1, 0 or 10 (RAID 5 is NOT recommended); SCSI class
ontrollers --> RAID 1


Does Progress 9.1 just require that much more power that 8.3? Are these
minimum specs
anywhere close? That last question is what led to my other post yesterday
about
what would you consider minimums or ideals.

Thanks for taking the time to read about my problems, and I hope that by our
going
through them, no one else will.

Tim Care
Electro Chemical Finishing


----- Original Message -----
From: "william" <william@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, July 11, 2001 6:23 PM
Subject: Re: [Vantage] 5.0 Performance Question.....


> What are the specifications of your Server?
>
> In particular:
> If you have multiple processors, what -spin setting are you using?
> How many disks are available, and how are your extents distributed across
them?
> What is your setting for -B?
>
> Tim Care wrote:
>
> > We are still fighting performance issues after a
> > week on 5.0. We have done a dump and load
> > on the database, and thing are getting better.
> >
> > We are seeing general vantage usage at about
> > 15% of processor time. When we start a
> > report builder report (from Report Builder, or
> > from a vantage menu) processor usage spikes
> > and goes to about 50 %, with just the one
> > report running. If multiple people are running
> > reports, we have seen processor usage go
> > to as high as 95%.
> >
> > Does anyone have any suggestions as to what
> > we can do, look for, etc, to try to eliminate this
> > report builder problem. Telling the users not
> > to run reports is obviously not an option.
> >
> > It seems we've done everything support knows
> > about, and are now on our own. Any help would
> > be greatly appreciated.
> >
> > Tim Care
> > Electro Chemical Finishing
> >
> > To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
2
We are still fighting performance issues after a
week on 5.0. We have done a dump and load
on the database, and thing are getting better.

We are seeing general vantage usage at about
15% of processor time. When we start a
report builder report (from Report Builder, or
from a vantage menu) processor usage spikes
and goes to about 50 %, with just the one
report running. If multiple people are running
reports, we have seen processor usage go
to as high as 95%.

Does anyone have any suggestions as to what
we can do, look for, etc, to try to eliminate this
report builder problem. Telling the users not
to run reports is obviously not an option.

It seems we've done everything support knows
about, and are now on our own. Any help would
be greatly appreciated.

Tim Care
Electro Chemical Finishing
3
Tim,

Exactly what are you doing with a dump and load? Is that a purge?

Steve

-----Original Message-----
From: Tim Care [SMTP:ecfmis@...]
Sent: Wednesday, July 11, 2001 9:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 5.0 Performance Question.....

We are still fighting performance issues after a
week on 5.0. We have done a dump and load
on the database, and thing are getting better.

We are seeing general vantage usage at about
15% of processor time. When we start a
report builder report (from Report Builder, or
from a vantage menu) processor usage spikes
and goes to about 50 %, with just the one
report running. If multiple people are running
reports, we have seen processor usage go
to as high as 95%.

Does anyone have any suggestions as to what
we can do, look for, etc, to try to eliminate this
report builder problem. Telling the users not
to run reports is obviously not an option.

It seems we've done everything support knows
about, and are now on our own. Any help would
be greatly appreciated.

Tim Care
Electro Chemical Finishing


To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
4
A basic description of dump and load:
Takes all data out of existing database, makes acii
files from it, reloads it into a new, empty database.
Then you reindex, run a vantage conversion, and you
are done.

In talking with support, we ran a DBAnalysis, that
indicated that many of our tables were highly
"scattered" (fragmented). Doing the dump and load
reduced our scatter factor, slightly reduced our DB size,
and allowed us to move from 4k block size to 8k block
size in our db.

Support has a dump and load kit available. Just be
warned that custom programming tables need to be
readded, or configured into the file definitions.

If you have any more questions, let me know.

----- Original Message -----
From: "Steve Wirtz" <SWirtz@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, July 11, 2001 9:43 AM
Subject: RE: [Vantage] 5.0 Performance Question.....


> Tim,
>
> Exactly what are you doing with a dump and load? Is that a purge?
>
> Steve
>
> -----Original Message-----
> From: Tim Care [SMTP:ecfmis@...]
> Sent: Wednesday, July 11, 2001 9:12 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 5.0 Performance Question.....
>
> We are still fighting performance issues after a
> week on 5.0. We have done a dump and load
> on the database, and thing are getting better.
>
> We are seeing general vantage usage at about
> 15% of processor time. When we start a
> report builder report (from Report Builder, or
> from a vantage menu) processor usage spikes
> and goes to about 50 %, with just the one
> report running. If multiple people are running
> reports, we have seen processor usage go
> to as high as 95%.
>
> Does anyone have any suggestions as to what
> we can do, look for, etc, to try to eliminate this
> report builder problem. Telling the users not
> to run reports is obviously not an option.
>
> It seems we've done everything support knows
> about, and are now on our own. Any help would
> be greatly appreciated.
>
> Tim Care
> Electro Chemical Finishing
>
>
> To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
5
Tim,

Thanks for the info. We just went live with 5.0 on Monday. It looks
like this might help us.

Steve

-----Original Message-----
From: Tim Care [SMTP:ecfmis@...]
Sent: Wednesday, July 11, 2001 9:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.0 Performance Question.....

A basic description of dump and load:
Takes all data out of existing database, makes acii
files from it, reloads it into a new, empty database.
Then you reindex, run a vantage conversion, and you
are done.

In talking with support, we ran a DBAnalysis, that
indicated that many of our tables were highly
"scattered" (fragmented). Doing the dump and load
reduced our scatter factor, slightly reduced our DB size,
and allowed us to move from 4k block size to 8k block
size in our db.

Support has a dump and load kit available. Just be
warned that custom programming tables need to be
readded, or configured into the file definitions.

If you have any more questions, let me know.

----- Original Message -----
From: "Steve Wirtz" <SWirtz@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, July 11, 2001 9:43 AM
Subject: RE: [Vantage] 5.0 Performance Question.....


> Tim,
>
> Exactly what are you doing with a dump and load? Is that a
purge?
>
> Steve
>
> -----Original Message-----
> From: Tim Care [SMTP:ecfmis@...]
> Sent: Wednesday, July 11, 2001 9:12 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] 5.0 Performance Question.....
>
> We are still fighting performance issues after a
> week on 5.0. We have done a dump and load
> on the database, and thing are getting better.
>
> We are seeing general vantage usage at about
> 15% of processor time. When we start a
> report builder report (from Report Builder, or
> from a vantage menu) processor usage spikes
> and goes to about 50 %, with just the one
> report running. If multiple people are running
> reports, we have seen processor usage go
> to as high as 95%.
>
> Does anyone have any suggestions as to what
> we can do, look for, etc, to try to eliminate this
> report builder problem. Telling the users not
> to run reports is obviously not an option.
>
> It seems we've done everything support knows
> about, and are now on our own. Any help would
> be greatly appreciated.
>
> Tim Care
> Electro Chemical Finishing
>
>
> To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must
have
> already linked your email address to a yahoo id to enable
access.
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> To access the Files Section of our Yahoo!Group for Report
Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must
have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>


To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
6
What are the specifications of your Server?

In particular:
If you have multiple processors, what -spin setting are you using?
How many disks are available, and how are your extents distributed across them?
What is your setting for -B?

Tim Care wrote:

> We are still fighting performance issues after a
> week on 5.0. We have done a dump and load
> on the database, and thing are getting better.
>
> We are seeing general vantage usage at about
> 15% of processor time. When we start a
> report builder report (from Report Builder, or
> from a vantage menu) processor usage spikes
> and goes to about 50 %, with just the one
> report running. If multiple people are running
> reports, we have seen processor usage go
> to as high as 95%.
>
> Does anyone have any suggestions as to what
> we can do, look for, etc, to try to eliminate this
> report builder problem. Telling the users not
> to run reports is obviously not an option.
>
> It seems we've done everything support knows
> about, and are now on our own. Any help would
> be greatly appreciated.
>
> Tim Care
> Electro Chemical Finishing
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/