Performance Tuning Story to Share

Yahoo Archive
1
Quoting from the Sysadmin Reference Manual -spin entry:

" On mutli-processor machines, try a value of 2,000. If this causes too much CPU usage, reduce the value. If you have many fast processors, a value as high as 10,000 might be effective".

There is also a note on how to evaluate -spin values using promon (to long to quote here).

HTH.

"Winter, Patrick" wrote:

> I'm not sure where 2 came from, the processors are 550mhz, I'm having Jay
> Erickson look at my database log file for other improvements, thanks for
> pointing this out.
>
> Patrick J. Winter
> Information Services Manager
> sSc Specialty Screw Corporation
> Vantage 4.00.901
>
> -----Original Message-----
> From: William Colls [mailto:william@...]
> Sent: Tuesday, November 21, 2000 10:35 AM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Performance Tuning Story to Share
>
> How did you arrive at a value of 2 for the -spin parameter? How fast are
> your processors?
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
2
I converted to Morocco a couple of weeks ago. My system slowed down. I
noticed a 4 to 7 second delay when loading data entry screens. Under Rio I
had no noticeable delay.

Hardware:
Dell 2300 Server, Duel Pent III Processors, 512mb RAM, duel 18gb drives
Mirrored.
C: drive was 4gb for the Operating System. (NT 4)
D: drive was 16gb for Vantage.
Nothing else was running on this server.

I also added the "- Spin 2" parameter which I had not used under RIO so I
was hoping for a performance gain.
I had my "- B" parameter set to 30000 (120mb) under Rio and increased it to
60000 (240mb) under Morocco but still had a delay when loading job entry,
order entry, quote entry, etc...

My solution after many many other attempts was:
Under Control Panel/System/Performance/Virtual Memory
The original configuration for the systems was:
C: minimum 512 / Maximum 1024
D: blank

I changed D: drive to the same as C: Drive
C: minimum 512 / Maximum 1024
D: minimum 512 / Maximum 1024

Now performance is as good as what I had running RIO.
By the way six of my shop floor data stations are 60mhz, 32mb RAM, Win98.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 4.00.901
3
How did you arrive at a value of 2 for the -spin parameter? How fast are your processors?

"Winter, Patrick" wrote:

> I converted to Morocco a couple of weeks ago. My system slowed down. I
> noticed a 4 to 7 second delay when loading data entry screens. Under Rio I
> had no noticeable delay.
>
> Hardware:
> Dell 2300 Server, Duel Pent III Processors, 512mb RAM, duel 18gb drives
> Mirrored.
> C: drive was 4gb for the Operating System. (NT 4)
> D: drive was 16gb for Vantage.
> Nothing else was running on this server.
>
> I also added the "- Spin 2" parameter which I had not used under RIO so I
> was hoping for a performance gain.
> I had my "- B" parameter set to 30000 (120mb) under Rio and increased it to
> 60000 (240mb) under Morocco but still had a delay when loading job entry,
> order entry, quote entry, etc...
>
> My solution after many many other attempts was:
> Under Control Panel/System/Performance/Virtual Memory
> The original configuration for the systems was:
> C: minimum 512 / Maximum 1024
> D: blank
>
> I changed D: drive to the same as C: Drive
> C: minimum 512 / Maximum 1024
> D: minimum 512 / Maximum 1024
>
> Now performance is as good as what I had running RIO.
> By the way six of my shop floor data stations are 60mhz, 32mb RAM, Win98.
>
> Patrick J. Winter
> Information Services Manager
> sSc Specialty Screw Corporation
> Vantage 4.00.901
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
4
I'm not sure where 2 came from, the processors are 550mhz, I'm having Jay
Erickson look at my database log file for other improvements, thanks for
pointing this out.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 4.00.901

-----Original Message-----
From: William Colls [mailto:william@...]
Sent: Tuesday, November 21, 2000 10:35 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Performance Tuning Story to Share


How did you arrive at a value of 2 for the -spin parameter? How fast are
your processors?