DB Buffer size Blank Title 76286

Just one follow up note on this. Most Vantage databases are either 4k or 8k block sizes.

An important note about this. You can change the block size of the database from 4k to 8k, however, it is highly recommended (not required) that you keep the same block size as the underlying disk partition (when you formatted your drive you had an option for specifying the block size, the default is 4k.) If you change the database to an 8k block size you may run the risk of data loss in the event of a power loss (insert technical jargon here about pages writing to different tracks, etc. etc..).

Changing the block size above 8k will mostly likely not increase your performance, mainly due to the aforementioned blocks in the buffer limitation, and the fact that Vantage is a small transaction-based application increasing it too much may leave you worse off than you started.

You will also have to create a new database as you cannot modify the block size to an existing database - which, as you can guess, would require a dump and load.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason@...>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jason Claggett
Sent: Wednesday, April 08, 2009 9:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Buffer size





What version is everyone running? I do know that with 8.00 - using OpenEdge 10.0b - you could go above the 100,000 threshold and use up the memory. Starting in 8.03 and the use of 10.1b from OpenEdge the 100,000 barrier became an issue. The 100,000 barrier is for databases with an 8k block size and the 200,000 barrier is with databases with 4k block sizes. This is actually an OpenEdge limitation with shared memory. Because OpenEdge does not come in a 64-bit version for Windows, then you will never be able to use more than 2GB for the entire application. Below is the official description of the problem and "fix" from the Progress knowledge base:
Cause:
Changes to internal architecture of the 10.1B client code and 10.1B database internals have changed the memory requirements and some functional limits for many executables.
In 10.1Bx the client will most likely only be able to connect in shared memory to a database whose total allocated shared memory is around 1.4 Gig of RAM (or less).
Depending on parameters used to start the database the following are the values typical for -B dependent on database blocksize:
DB Blocksize Approximate limit for -B value which
will allow shared memory connection
1k 1400000
2k 700000
4k 350000
8k 175000

These numbers are largely approximations.
Changes to .dll versions within a system may increase or lower these suggested values.
Changes to some startup parameters which affect shared memory such as -B, -L, -Mxs, -shmsegsize, et al. will likely alter the above limits.

Though the database may be able to startup with values higher than those listed above, the client requires a much larger heap size in 10.1B compared to earlier versions and this added memory usage lowers the total memory that the client can attach to and still be within the addressable 32-bit memory limit for a client executable on Windows.
Fixes:
Consider reducing the -B for the database startup. A good starting point is to reduce the prior value by 10%.

This is for Windows operating systems. OpenEdge 10.1b does not currently have a 64-bit version for Windows. I hear that's in the works.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason%402wtech.com><mailto:jason@...<mailto:jason%402wtech.com>>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Late, Travis
Sent: Monday, April 06, 2009 4:19 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: DB Buffer size

They couldn't give me an explanation. When I asked why I should lower it
they sent me the db tuning guide. They are completely contradicting
themselves with this one. Still holding steady at 11GB. I'll see where I
am at by the end of tomorrow. Hopefully not maxed out at 16GB.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of Paul
Sent: Monday, April 06, 2009 3:07 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Buffer size

Why did they tell you to lower the number?

My server is a 32 bit so I'm thinking that is why I'm not able to go
past the 95 thousand.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...<mailto:tlate@...>> wrote:
>
> I currently have our Live DB running at 180,000. We have Windows
Server
> 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
now
> we have 16GB.
>
>
>
> Our server currently says it's using 11GB of RAM and rising. I'm
baffled
> by this, but never monitored it this closely at my past jobs. I'm not
> going to lower the buffer size like support suggested. That honestly
> makes no sense to me. I was always taught the more of you DB you can
> store in RAM the better off you will be.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Paul
> Sent: Monday, April 06, 2009 2:15 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> Here's my experience: I talked to support a while ago on how to
increase
> Vantage/database performance. They sent me a pdf file that had
> explanations of the settings in the progress explorer tool as well as
> other options.
>
> One of them was about the buffer size you mentioned. I found that I
> can't go beyond the 100000 mark in that number (don't know the exact
> number, currently have it set at 95 thousand), even though I have
plenty
> of memory to spare (also 12gb running a enterprise 2003 server). I
found
> the 100,000 mark because every time I would go up that high the
> appserver wouldn't start and I couldn't log into Vantage. The document
> suggested had a chart of numbers and their actual mb in ram usage
> results.
>
> Whiel working on the test server (seperate hardware from live server)
> its performance was incredibly lame, so I decided to follow the
document
> which prompted me to call support to ask them about this.
>
> I talked to support about this last week and they confirmed that the
> appservers don't support the memory usage above 80 to 90 thousand
> (support wasn't able to give me an exact number).
>
> Did your Vantage still work above 100,000?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

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



[Non-text portions of this message have been removed]
We are on Progress Vantage 8.03.405A. We just went live 2 weeks ago. The
server that we are running is using all 12GB of RAM that we supplied it
with, which does not seem right. I am being told by support to lower the
#Blocks in DB buffer from 180000 to 80000. Does this sound like a
setting that should really be lowered. I thought that you get better
performance the more of the DB that you store in RAM. Below is our specs
of what we have now. I'd like to hear some advice from similar sized
companies with a similar sized server or anyone else who knows something
about this.





Vantage Users

60 Regular Users

30 MES Users



ODBC Users

1



Vantage Server Specs

HP DL180 G5 Duo Quad Core Xeon E5420 2.5 GHz

12GB RAM

Windows Server 2003 R2 Standard x64 Edition



Citrix Servers

All of our users connect to Vantage through Citrix

We have 3 HP DL180 Duo Quad Core Xeon E5420 2.5 GHz

4GB RAM in each server

Windows Server 2003 R2 Standard



Thanks,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]
What are your .pf file settings specifically for -Bt this is in the
mfgsys803\server\config folder

How many environments are running at the same time, train test live etc?

What is the distribution of your ram on the server - is service connect
/ sql also installed on this

I presume you are running Progress and not SQL.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: 03 April 2009 14:01
To: vantage@yahoogroups.com
Subject: [Vantage] DB Buffer size



We are on Progress Vantage 8.03.405A. We just went live 2 weeks ago. The
server that we are running is using all 12GB of RAM that we supplied it
with, which does not seem right. I am being told by support to lower the
#Blocks in DB buffer from 180000 to 80000. Does this sound like a
setting that should really be lowered. I thought that you get better
performance the more of the DB that you store in RAM. Below is our specs
of what we have now. I'd like to hear some advice from similar sized
companies with a similar sized server or anyone else who knows something
about this.

Vantage Users

60 Regular Users

30 MES Users

ODBC Users

1

Vantage Server Specs

HP DL180 G5 Duo Quad Core Xeon E5420 2.5 GHz

12GB RAM

Windows Server 2003 R2 Standard x64 Edition

Citrix Servers

All of our users connect to Vantage through Citrix

We have 3 HP DL180 Duo Quad Core Xeon E5420 2.5 GHz

4GB RAM in each server

Windows Server 2003 R2 Standard

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

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





[Non-text portions of this message have been removed]
Its set to 1024. We are only running our live db. The only application
we have installed on the server is Vantage. We use progress. When I look
at all the processes using the RAM it doesn't add up to 12 GB, but when
I check performance it shows that all 12 GB is being used. Could there
be a hidden process running that will not show?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Edginton
Sent: Friday, April 03, 2009 8:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Buffer size



What are your .pf file settings specifically for -Bt this is in the
mfgsys803\server\config folder

How many environments are running at the same time, train test live etc?

What is the distribution of your ram on the server - is service connect
/ sql also installed on this

I presume you are running Progress and not SQL.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: 03 April 2009 14:01
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Buffer size

We are on Progress Vantage 8.03.405A. We just went live 2 weeks ago. The
server that we are running is using all 12GB of RAM that we supplied it
with, which does not seem right. I am being told by support to lower the
#Blocks in DB buffer from 180000 to 80000. Does this sound like a
setting that should really be lowered. I thought that you get better
performance the more of the DB that you store in RAM. Below is our specs
of what we have now. I'd like to hear some advice from similar sized
companies with a similar sized server or anyone else who knows something
about this.

Vantage Users

60 Regular Users

30 MES Users

ODBC Users

1

Vantage Server Specs

HP DL180 G5 Duo Quad Core Xeon E5420 2.5 GHz

12GB RAM

Windows Server 2003 R2 Standard x64 Edition

Citrix Servers

All of our users connect to Vantage through Citrix

We have 3 HP DL180 Duo Quad Core Xeon E5420 2.5 GHz

4GB RAM in each server

Windows Server 2003 R2 Standard

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

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

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





[Non-text portions of this message have been removed]
When the appserver and databases are stopped what is your ram usage.

How many appservers are active?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: 03 April 2009 14:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Buffer size



Its set to 1024. We are only running our live db. The only application
we have installed on the server is Vantage. We use progress. When I look
at all the processes using the RAM it doesn't add up to 12 GB, but when
I check performance it shows that all 12 GB is being used. Could there
be a hidden process running that will not show?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Stephen Edginton
Sent: Friday, April 03, 2009 8:30 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Buffer size

What are your .pf file settings specifically for -Bt this is in the
mfgsys803\server\config folder

How many environments are running at the same time, train test live etc?

What is the distribution of your ram on the server - is service connect
/ sql also installed on this

I presume you are running Progress and not SQL.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: 03 April 2009 14:01
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Buffer size

We are on Progress Vantage 8.03.405A. We just went live 2 weeks ago. The
server that we are running is using all 12GB of RAM that we supplied it
with, which does not seem right. I am being told by support to lower the
#Blocks in DB buffer from 180000 to 80000. Does this sound like a
setting that should really be lowered. I thought that you get better
performance the more of the DB that you store in RAM. Below is our specs
of what we have now. I'd like to hear some advice from similar sized
companies with a similar sized server or anyone else who knows something
about this.

Vantage Users

60 Regular Users

30 MES Users

ODBC Users

1

Vantage Server Specs

HP DL180 G5 Duo Quad Core Xeon E5420 2.5 GHz

12GB RAM

Windows Server 2003 R2 Standard x64 Edition

Citrix Servers

All of our users connect to Vantage through Citrix

We have 3 HP DL180 Duo Quad Core Xeon E5420 2.5 GHz

4GB RAM in each server

Windows Server 2003 R2 Standard

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062







[Non-text portions of this message have been removed]
I'll test that our this weekend to see how many are running.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Edginton
Sent: Friday, April 03, 2009 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] DB Buffer size



When the appserver and databases are stopped what is your ram usage.

How many appservers are active?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: 03 April 2009 14:52
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Buffer size

Its set to 1024. We are only running our live db. The only application
we have installed on the server is Vantage. We use progress. When I look
at all the processes using the RAM it doesn't add up to 12 GB, but when
I check performance it shows that all 12 GB is being used. Could there
be a hidden process running that will not show?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Stephen Edginton
Sent: Friday, April 03, 2009 8:30 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] DB Buffer size

What are your .pf file settings specifically for -Bt this is in the
mfgsys803\server\config folder

How many environments are running at the same time, train test live etc?

What is the distribution of your ram on the server - is service connect
/ sql also installed on this

I presume you are running Progress and not SQL.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: 03 April 2009 14:01
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] DB Buffer size

We are on Progress Vantage 8.03.405A. We just went live 2 weeks ago. The
server that we are running is using all 12GB of RAM that we supplied it
with, which does not seem right. I am being told by support to lower the
#Blocks in DB buffer from 180000 to 80000. Does this sound like a
setting that should really be lowered. I thought that you get better
performance the more of the DB that you store in RAM. Below is our specs
of what we have now. I'd like to hear some advice from similar sized
companies with a similar sized server or anyone else who knows something
about this.

Vantage Users

60 Regular Users

30 MES Users

ODBC Users

1

Vantage Server Specs

HP DL180 G5 Duo Quad Core Xeon E5420 2.5 GHz

12GB RAM

Windows Server 2003 R2 Standard x64 Edition

Citrix Servers

All of our users connect to Vantage through Citrix

We have 3 HP DL180 Duo Quad Core Xeon E5420 2.5 GHz

4GB RAM in each server

Windows Server 2003 R2 Standard

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

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





[Non-text portions of this message have been removed]
Here's my experience: I talked to support a while ago on how to increase Vantage/database performance. They sent me a pdf file that had explanations of the settings in the progress explorer tool as well as other options.

One of them was about the buffer size you mentioned. I found that I can't go beyond the 100000 mark in that number (don't know the exact number, currently have it set at 95 thousand), even though I have plenty of memory to spare (also 12gb running a enterprise 2003 server). I found the 100,000 mark because every time I would go up that high the appserver wouldn't start and I couldn't log into Vantage. The document suggested had a chart of numbers and their actual mb in ram usage results.

Whiel working on the test server (seperate hardware from live server) its performance was incredibly lame, so I decided to follow the document which prompted me to call support to ask them about this.

I talked to support about this last week and they confirmed that the appservers don't support the memory usage above 80 to 90 thousand (support wasn't able to give me an exact number).

Did your Vantage still work above 100,000?
I currently have our Live DB running at 180,000. We have Windows Server
2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so now
we have 16GB.



Our server currently says it's using 11GB of RAM and rising. I'm baffled
by this, but never monitored it this closely at my past jobs. I'm not
going to lower the buffer size like support suggested. That honestly
makes no sense to me. I was always taught the more of you DB you can
store in RAM the better off you will be.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul
Sent: Monday, April 06, 2009 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DB Buffer size



Here's my experience: I talked to support a while ago on how to increase
Vantage/database performance. They sent me a pdf file that had
explanations of the settings in the progress explorer tool as well as
other options.

One of them was about the buffer size you mentioned. I found that I
can't go beyond the 100000 mark in that number (don't know the exact
number, currently have it set at 95 thousand), even though I have plenty
of memory to spare (also 12gb running a enterprise 2003 server). I found
the 100,000 mark because every time I would go up that high the
appserver wouldn't start and I couldn't log into Vantage. The document
suggested had a chart of numbers and their actual mb in ram usage
results.

Whiel working on the test server (seperate hardware from live server)
its performance was incredibly lame, so I decided to follow the document
which prompted me to call support to ask them about this.

I talked to support about this last week and they confirmed that the
appservers don't support the memory usage above 80 to 90 thousand
(support wasn't able to give me an exact number).

Did your Vantage still work above 100,000?





[Non-text portions of this message have been removed]
Why did they tell you to lower the number?

My server is a 32 bit so I'm thinking that is why I'm not able to go past the 95 thousand.

--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> I currently have our Live DB running at 180,000. We have Windows Server
> 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so now
> we have 16GB.
>
>
>
> Our server currently says it's using 11GB of RAM and rising. I'm baffled
> by this, but never monitored it this closely at my past jobs. I'm not
> going to lower the buffer size like support suggested. That honestly
> makes no sense to me. I was always taught the more of you DB you can
> store in RAM the better off you will be.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Paul
> Sent: Monday, April 06, 2009 2:15 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> Here's my experience: I talked to support a while ago on how to increase
> Vantage/database performance. They sent me a pdf file that had
> explanations of the settings in the progress explorer tool as well as
> other options.
>
> One of them was about the buffer size you mentioned. I found that I
> can't go beyond the 100000 mark in that number (don't know the exact
> number, currently have it set at 95 thousand), even though I have plenty
> of memory to spare (also 12gb running a enterprise 2003 server). I found
> the 100,000 mark because every time I would go up that high the
> appserver wouldn't start and I couldn't log into Vantage. The document
> suggested had a chart of numbers and their actual mb in ram usage
> results.
>
> Whiel working on the test server (seperate hardware from live server)
> its performance was incredibly lame, so I decided to follow the document
> which prompted me to call support to ask them about this.
>
> I talked to support about this last week and they confirmed that the
> appservers don't support the memory usage above 80 to 90 thousand
> (support wasn't able to give me an exact number).
>
> Did your Vantage still work above 100,000?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
They couldn't give me an explanation. When I asked why I should lower it
they sent me the db tuning guide. They are completely contradicting
themselves with this one. Still holding steady at 11GB. I'll see where I
am at by the end of tomorrow. Hopefully not maxed out at 16GB.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul
Sent: Monday, April 06, 2009 3:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DB Buffer size



Why did they tell you to lower the number?

My server is a 32 bit so I'm thinking that is why I'm not able to go
past the 95 thousand.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...> wrote:
>
> I currently have our Live DB running at 180,000. We have Windows
Server
> 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
now
> we have 16GB.
>
>
>
> Our server currently says it's using 11GB of RAM and rising. I'm
baffled
> by this, but never monitored it this closely at my past jobs. I'm not
> going to lower the buffer size like support suggested. That honestly
> makes no sense to me. I was always taught the more of you DB you can
> store in RAM the better off you will be.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Paul
> Sent: Monday, April 06, 2009 2:15 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> Here's my experience: I talked to support a while ago on how to
increase
> Vantage/database performance. They sent me a pdf file that had
> explanations of the settings in the progress explorer tool as well as
> other options.
>
> One of them was about the buffer size you mentioned. I found that I
> can't go beyond the 100000 mark in that number (don't know the exact
> number, currently have it set at 95 thousand), even though I have
plenty
> of memory to spare (also 12gb running a enterprise 2003 server). I
found
> the 100,000 mark because every time I would go up that high the
> appserver wouldn't start and I couldn't log into Vantage. The document
> suggested had a chart of numbers and their actual mb in ram usage
> results.
>
> Whiel working on the test server (seperate hardware from live server)
> its performance was incredibly lame, so I decided to follow the
document
> which prompted me to call support to ask them about this.
>
> I talked to support about this last week and they confirmed that the
> appservers don't support the memory usage above 80 to 90 thousand
> (support wasn't able to give me an exact number).
>
> Did your Vantage still work above 100,000?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
The number of buffer blocks you can use depends on the blocksize of the db. We are using an 8k blocksize and 95K buffer blocks - if you had the default 4K blocksize db that would be equivalent to 190K buffer blocks

If you exceed the 'magic' buffer blocksize, you will get errors in the appserver logs indicating that the appserver could not connect to shared memory.

Now support blames the issue on Microsoft not being able to work with more than 2 gig of memory assigned to a single process. 95K blocks on an 8K db only equates to 'around' 760 Meg of memory allocated to db buffer - so go figure.......

--- In vantage@yahoogroups.com, "Paul" <chaosavy@...> wrote:
>
> Why did they tell you to lower the number?
>
> My server is a 32 bit so I'm thinking that is why I'm not able to go past the 95 thousand.
>
> --- In vantage@yahoogroups.com, "Late, Travis" <tlate@> wrote:
> >
> > I currently have our Live DB running at 180,000. We have Windows Server
> > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so now
> > we have 16GB.
> >
> >
> >
> > Our server currently says it's using 11GB of RAM and rising. I'm baffled
> > by this, but never monitored it this closely at my past jobs. I'm not
> > going to lower the buffer size like support suggested. That honestly
> > makes no sense to me. I was always taught the more of you DB you can
> > store in RAM the better off you will be.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Paul
> > Sent: Monday, April 06, 2009 2:15 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: DB Buffer size
> >
> >
> >
> > Here's my experience: I talked to support a while ago on how to increase
> > Vantage/database performance. They sent me a pdf file that had
> > explanations of the settings in the progress explorer tool as well as
> > other options.
> >
> > One of them was about the buffer size you mentioned. I found that I
> > can't go beyond the 100000 mark in that number (don't know the exact
> > number, currently have it set at 95 thousand), even though I have plenty
> > of memory to spare (also 12gb running a enterprise 2003 server). I found
> > the 100,000 mark because every time I would go up that high the
> > appserver wouldn't start and I couldn't log into Vantage. The document
> > suggested had a chart of numbers and their actual mb in ram usage
> > results.
> >
> > Whiel working on the test server (seperate hardware from live server)
> > its performance was incredibly lame, so I decided to follow the document
> > which prompted me to call support to ask them about this.
> >
> > I talked to support about this last week and they confirmed that the
> > appservers don't support the memory usage above 80 to 90 thousand
> > (support wasn't able to give me an exact number).
> >
> > Did your Vantage still work above 100,000?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Can anyone go on their Vantage Server and tell me what they have set
under: Right click on my computer>Properties> Advanced Tab>Performance
>Settings>Advanced. Then under memory usage what do you have checked? I
have System Cache and not Programs checked. Could this be my problem? If
a few of you could check out your server and let me know what you see
I'd appreciate it.



Thanks,

Travis



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Monday, April 06, 2009 6:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DB Buffer size



The number of buffer blocks you can use depends on the blocksize of the
db. We are using an 8k blocksize and 95K buffer blocks - if you had the
default 4K blocksize db that would be equivalent to 190K buffer blocks

If you exceed the 'magic' buffer blocksize, you will get errors in the
appserver logs indicating that the appserver could not connect to shared
memory.

Now support blames the issue on Microsoft not being able to work with
more than 2 gig of memory assigned to a single process. 95K blocks on an
8K db only equates to 'around' 760 Meg of memory allocated to db buffer
- so go figure.......

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Paul" <chaosavy@...> wrote:
>
> Why did they tell you to lower the number?
>
> My server is a 32 bit so I'm thinking that is why I'm not able to go
past the 95 thousand.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@> wrote:
> >
> > I currently have our Live DB running at 180,000. We have Windows
Server
> > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
now
> > we have 16GB.
> >
> >
> >
> > Our server currently says it's using 11GB of RAM and rising. I'm
baffled
> > by this, but never monitored it this closely at my past jobs. I'm
not
> > going to lower the buffer size like support suggested. That honestly
> > makes no sense to me. I was always taught the more of you DB you can
> > store in RAM the better off you will be.
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of Paul
> > Sent: Monday, April 06, 2009 2:15 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: DB Buffer size
> >
> >
> >
> > Here's my experience: I talked to support a while ago on how to
increase
> > Vantage/database performance. They sent me a pdf file that had
> > explanations of the settings in the progress explorer tool as well
as
> > other options.
> >
> > One of them was about the buffer size you mentioned. I found that I
> > can't go beyond the 100000 mark in that number (don't know the exact
> > number, currently have it set at 95 thousand), even though I have
plenty
> > of memory to spare (also 12gb running a enterprise 2003 server). I
found
> > the 100,000 mark because every time I would go up that high the
> > appserver wouldn't start and I couldn't log into Vantage. The
document
> > suggested had a chart of numbers and their actual mb in ram usage
> > results.
> >
> > Whiel working on the test server (seperate hardware from live
server)
> > its performance was incredibly lame, so I decided to follow the
document
> > which prompted me to call support to ask them about this.
> >
> > I talked to support about this last week and they confirmed that the
> > appservers don't support the memory usage above 80 to 90 thousand
> > (support wasn't able to give me an exact number).
> >
> > Did your Vantage still work above 100,000?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
On the top setting, I have Background and on the bottom one I have system
checked. Our performance seems to be Ok. I have the memory set to be a
static number which is 3 times the RAM.

Jeff



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Late, Travis
Sent: Monday, April 06, 2009 7:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Buffer size



Can anyone go on their Vantage Server and tell me what they have set
under: Right click on my computer>Properties> Advanced Tab>Performance
>Settings>Advanced. Then under memory usage what do you have checked? I
have System Cache and not Programs checked. Could this be my problem? If
a few of you could check out your server and let me know what you see
I'd appreciate it.

Thanks,

Travis

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of bw2868bond
Sent: Monday, April 06, 2009 6:11 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Buffer size

The number of buffer blocks you can use depends on the blocksize of the
db. We are using an 8k blocksize and 95K buffer blocks - if you had the
default 4K blocksize db that would be equivalent to 190K buffer blocks

If you exceed the 'magic' buffer blocksize, you will get errors in the
appserver logs indicating that the appserver could not connect to shared
memory.

Now support blames the issue on Microsoft not being able to work with
more than 2 gig of memory assigned to a single process. 95K blocks on an
8K db only equates to 'around' 760 Meg of memory allocated to db buffer
- so go figure.......

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Paul" <chaosavy@...> wrote:
>
> Why did they tell you to lower the number?
>
> My server is a 32 bit so I'm thinking that is why I'm not able to go
past the 95 thousand.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@> wrote:
> >
> > I currently have our Live DB running at 180,000. We have Windows
Server
> > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
now
> > we have 16GB.
> >
> >
> >
> > Our server currently says it's using 11GB of RAM and rising. I'm
baffled
> > by this, but never monitored it this closely at my past jobs. I'm
not
> > going to lower the buffer size like support suggested. That honestly
> > makes no sense to me. I was always taught the more of you DB you can
> > store in RAM the better off you will be.
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of Paul
> > Sent: Monday, April 06, 2009 2:15 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: DB Buffer size
> >
> >
> >
> > Here's my experience: I talked to support a while ago on how to
increase
> > Vantage/database performance. They sent me a pdf file that had
> > explanations of the settings in the progress explorer tool as well
as
> > other options.
> >
> > One of them was about the buffer size you mentioned. I found that I
> > can't go beyond the 100000 mark in that number (don't know the exact
> > number, currently have it set at 95 thousand), even though I have
plenty
> > of memory to spare (also 12gb running a enterprise 2003 server). I
found
> > the 100,000 mark because every time I would go up that high the
> > appserver wouldn't start and I couldn't log into Vantage. The
document
> > suggested had a chart of numbers and their actual mb in ram usage
> > results.
> >
> > Whiel working on the test server (seperate hardware from live
server)
> > its performance was incredibly lame, so I decided to follow the
document
> > which prompted me to call support to ask them about this.
> >
> > I talked to support about this last week and they confirmed that the
> > appservers don't support the memory usage above 80 to 90 thousand
> > (support wasn't able to give me an exact number).
> >
> > Did your Vantage still work above 100,000?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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





[Non-text portions of this message have been removed]
I have Programs checked.


--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> Can anyone go on their Vantage Server and tell me what they have set
> under: Right click on my computer>Properties> Advanced Tab>Performance
> >Settings>Advanced. Then under memory usage what do you have checked? I
> have System Cache and not Programs checked. Could this be my problem? If
> a few of you could check out your server and let me know what you see
> I'd appreciate it.
>
>
>
> Thanks,
>
> Travis
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of bw2868bond
> Sent: Monday, April 06, 2009 6:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> The number of buffer blocks you can use depends on the blocksize of the
> db. We are using an 8k blocksize and 95K buffer blocks - if you had the
> default 4K blocksize db that would be equivalent to 190K buffer blocks
>
> If you exceed the 'magic' buffer blocksize, you will get errors in the
> appserver logs indicating that the appserver could not connect to shared
> memory.
>
> Now support blames the issue on Microsoft not being able to work with
> more than 2 gig of memory assigned to a single process. 95K blocks on an
> 8K db only equates to 'around' 760 Meg of memory allocated to db buffer
> - so go figure.......
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Paul" <chaosavy@> wrote:
> >
> > Why did they tell you to lower the number?
> >
> > My server is a 32 bit so I'm thinking that is why I'm not able to go
> past the 95 thousand.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Late, Travis" <tlate@> wrote:
> > >
> > > I currently have our Live DB running at 180,000. We have Windows
> Server
> > > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
> now
> > > we have 16GB.
> > >
> > >
> > >
> > > Our server currently says it's using 11GB of RAM and rising. I'm
> baffled
> > > by this, but never monitored it this closely at my past jobs. I'm
> not
> > > going to lower the buffer size like support suggested. That honestly
> > > makes no sense to me. I was always taught the more of you DB you can
> > > store in RAM the better off you will be.
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of Paul
> > > Sent: Monday, April 06, 2009 2:15 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: DB Buffer size
> > >
> > >
> > >
> > > Here's my experience: I talked to support a while ago on how to
> increase
> > > Vantage/database performance. They sent me a pdf file that had
> > > explanations of the settings in the progress explorer tool as well
> as
> > > other options.
> > >
> > > One of them was about the buffer size you mentioned. I found that I
> > > can't go beyond the 100000 mark in that number (don't know the exact
> > > number, currently have it set at 95 thousand), even though I have
> plenty
> > > of memory to spare (also 12gb running a enterprise 2003 server). I
> found
> > > the 100,000 mark because every time I would go up that high the
> > > appserver wouldn't start and I couldn't log into Vantage. The
> document
> > > suggested had a chart of numbers and their actual mb in ram usage
> > > results.
> > >
> > > Whiel working on the test server (seperate hardware from live
> server)
> > > its performance was incredibly lame, so I decided to follow the
> document
> > > which prompted me to call support to ask them about this.
> > >
> > > I talked to support about this last week and they confirmed that the
> > > appservers don't support the memory usage above 80 to 90 thousand
> > > (support wasn't able to give me an exact number).
> > >
> > > Did your Vantage still work above 100,000?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
How is the performance using that setting? Are you on Progress or SQL?

We are using SQL.

Jeff



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
abcdefgsaga
Sent: Tuesday, April 07, 2009 8:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: DB Buffer size



I have Programs checked.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Late,
Travis" <tlate@...> wrote:
>
> Can anyone go on their Vantage Server and tell me what they have set
> under: Right click on my computer>Properties> Advanced Tab>Performance
> >Settings>Advanced. Then under memory usage what do you have checked? I
> have System Cache and not Programs checked. Could this be my problem? If
> a few of you could check out your server and let me know what you see
> I'd appreciate it.
>
>
>
> Thanks,
>
> Travis
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: Monday, April 06, 2009 6:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> The number of buffer blocks you can use depends on the blocksize of the
> db. We are using an 8k blocksize and 95K buffer blocks - if you had the
> default 4K blocksize db that would be equivalent to 190K buffer blocks
>
> If you exceed the 'magic' buffer blocksize, you will get errors in the
> appserver logs indicating that the appserver could not connect to shared
> memory.
>
> Now support blames the issue on Microsoft not being able to work with
> more than 2 gig of memory assigned to a single process. 95K blocks on an
> 8K db only equates to 'around' 760 Meg of memory allocated to db buffer
> - so go figure.......
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Paul" <chaosavy@> wrote:
> >
> > Why did they tell you to lower the number?
> >
> > My server is a 32 bit so I'm thinking that is why I'm not able to go
> past the 95 thousand.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Late, Travis" <tlate@> wrote:
> > >
> > > I currently have our Live DB running at 180,000. We have Windows
> Server
> > > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
> now
> > > we have 16GB.
> > >
> > >
> > >
> > > Our server currently says it's using 11GB of RAM and rising. I'm
> baffled
> > > by this, but never monitored it this closely at my past jobs. I'm
> not
> > > going to lower the buffer size like support suggested. That honestly
> > > makes no sense to me. I was always taught the more of you DB you can
> > > store in RAM the better off you will be.
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of Paul
> > > Sent: Monday, April 06, 2009 2:15 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: DB Buffer size
> > >
> > >
> > >
> > > Here's my experience: I talked to support a while ago on how to
> increase
> > > Vantage/database performance. They sent me a pdf file that had
> > > explanations of the settings in the progress explorer tool as well
> as
> > > other options.
> > >
> > > One of them was about the buffer size you mentioned. I found that I
> > > can't go beyond the 100000 mark in that number (don't know the exact
> > > number, currently have it set at 95 thousand), even though I have
> plenty
> > > of memory to spare (also 12gb running a enterprise 2003 server). I
> found
> > > the 100,000 mark because every time I would go up that high the
> > > appserver wouldn't start and I couldn't log into Vantage. The
> document
> > > suggested had a chart of numbers and their actual mb in ram usage
> > > results.
> > >
> > > Whiel working on the test server (seperate hardware from live
> server)
> > > its performance was incredibly lame, so I decided to follow the
> document
> > > which prompted me to call support to ask them about this.
> > >
> > > I talked to support about this last week and they confirmed that the
> > > appservers don't support the memory usage above 80 to 90 thousand
> > > (support wasn't able to give me an exact number).
> > >
> > > Did your Vantage still work above 100,000?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
We use progress. I'm going to set it tonight and let you know what I
find out.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jeff Stockard
Sent: Tuesday, April 07, 2009 7:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Buffer size



How is the performance using that setting? Are you on Progress or SQL?

We are using SQL.

Jeff

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
abcdefgsaga
Sent: Tuesday, April 07, 2009 8:23 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Buffer size

I have Programs checked.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Late,
Travis" <tlate@...> wrote:
>
> Can anyone go on their Vantage Server and tell me what they have set
> under: Right click on my computer>Properties> Advanced Tab>Performance
> >Settings>Advanced. Then under memory usage what do you have checked?
I
> have System Cache and not Programs checked. Could this be my problem?
If
> a few of you could check out your server and let me know what you see
> I'd appreciate it.
>
>
>
> Thanks,
>
> Travis
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: Monday, April 06, 2009 6:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> The number of buffer blocks you can use depends on the blocksize of
the
> db. We are using an 8k blocksize and 95K buffer blocks - if you had
the
> default 4K blocksize db that would be equivalent to 190K buffer blocks
>
> If you exceed the 'magic' buffer blocksize, you will get errors in the
> appserver logs indicating that the appserver could not connect to
shared
> memory.
>
> Now support blames the issue on Microsoft not being able to work with
> more than 2 gig of memory assigned to a single process. 95K blocks on
an
> 8K db only equates to 'around' 760 Meg of memory allocated to db
buffer
> - so go figure.......
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Paul" <chaosavy@> wrote:
> >
> > Why did they tell you to lower the number?
> >
> > My server is a 32 bit so I'm thinking that is why I'm not able to go
> past the 95 thousand.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Late, Travis" <tlate@> wrote:
> > >
> > > I currently have our Live DB running at 180,000. We have Windows
> Server
> > > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend
so
> now
> > > we have 16GB.
> > >
> > >
> > >
> > > Our server currently says it's using 11GB of RAM and rising. I'm
> baffled
> > > by this, but never monitored it this closely at my past jobs. I'm
> not
> > > going to lower the buffer size like support suggested. That
honestly
> > > makes no sense to me. I was always taught the more of you DB you
can
> > > store in RAM the better off you will be.
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of Paul
> > > Sent: Monday, April 06, 2009 2:15 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: DB Buffer size
> > >
> > >
> > >
> > > Here's my experience: I talked to support a while ago on how to
> increase
> > > Vantage/database performance. They sent me a pdf file that had
> > > explanations of the settings in the progress explorer tool as well
> as
> > > other options.
> > >
> > > One of them was about the buffer size you mentioned. I found that
I
> > > can't go beyond the 100000 mark in that number (don't know the
exact
> > > number, currently have it set at 95 thousand), even though I have
> plenty
> > > of memory to spare (also 12gb running a enterprise 2003 server). I
> found
> > > the 100,000 mark because every time I would go up that high the
> > > appserver wouldn't start and I couldn't log into Vantage. The
> document
> > > suggested had a chart of numbers and their actual mb in ram usage
> > > results.
> > >
> > > Whiel working on the test server (seperate hardware from live
> server)
> > > its performance was incredibly lame, so I decided to follow the
> document
> > > which prompted me to call support to ask them about this.
> > >
> > > I talked to support about this last week and they confirmed that
the
> > > appservers don't support the memory usage above 80 to 90 thousand
> > > (support wasn't able to give me an exact number).
> > >
> > > Did your Vantage still work above 100,000?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





[Non-text portions of this message have been removed]
Checked ours and it is set the same way - would like to know what you
found after changing it.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Tuesday, April 07, 2009 8:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Buffer size



We use progress. I'm going to set it tonight and let you know what I
find out.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jeff Stockard
Sent: Tuesday, April 07, 2009 7:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: DB Buffer size

How is the performance using that setting? Are you on Progress or SQL?

We are using SQL.

Jeff

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
abcdefgsaga
Sent: Tuesday, April 07, 2009 8:23 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Buffer size

I have Programs checked.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Late,
Travis" <tlate@...> wrote:
>
> Can anyone go on their Vantage Server and tell me what they have set
> under: Right click on my computer>Properties> Advanced Tab>Performance
> >Settings>Advanced. Then under memory usage what do you have checked?
I
> have System Cache and not Programs checked. Could this be my problem?
If
> a few of you could check out your server and let me know what you see
> I'd appreciate it.
>
>
>
> Thanks,
>
> Travis
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of bw2868bond
> Sent: Monday, April 06, 2009 6:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> The number of buffer blocks you can use depends on the blocksize of
the
> db. We are using an 8k blocksize and 95K buffer blocks - if you had
the
> default 4K blocksize db that would be equivalent to 190K buffer blocks
>
> If you exceed the 'magic' buffer blocksize, you will get errors in the
> appserver logs indicating that the appserver could not connect to
shared
> memory.
>
> Now support blames the issue on Microsoft not being able to work with
> more than 2 gig of memory assigned to a single process. 95K blocks on
an
> 8K db only equates to 'around' 760 Meg of memory allocated to db
buffer
> - so go figure.......
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Paul" <chaosavy@> wrote:
> >
> > Why did they tell you to lower the number?
> >
> > My server is a 32 bit so I'm thinking that is why I'm not able to go
> past the 95 thousand.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Late, Travis" <tlate@> wrote:
> > >
> > > I currently have our Live DB running at 180,000. We have Windows
> Server
> > > 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend
so
> now
> > > we have 16GB.
> > >
> > >
> > >
> > > Our server currently says it's using 11GB of RAM and rising. I'm
> baffled
> > > by this, but never monitored it this closely at my past jobs. I'm
> not
> > > going to lower the buffer size like support suggested. That
honestly
> > > makes no sense to me. I was always taught the more of you DB you
can
> > > store in RAM the better off you will be.
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of Paul
> > > Sent: Monday, April 06, 2009 2:15 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: DB Buffer size
> > >
> > >
> > >
> > > Here's my experience: I talked to support a while ago on how to
> increase
> > > Vantage/database performance. They sent me a pdf file that had
> > > explanations of the settings in the progress explorer tool as well
> as
> > > other options.
> > >
> > > One of them was about the buffer size you mentioned. I found that
I
> > > can't go beyond the 100000 mark in that number (don't know the
exact
> > > number, currently have it set at 95 thousand), even though I have
> plenty
> > > of memory to spare (also 12gb running a enterprise 2003 server). I
> found
> > > the 100,000 mark because every time I would go up that high the
> > > appserver wouldn't start and I couldn't log into Vantage. The
> document
> > > suggested had a chart of numbers and their actual mb in ram usage
> > > results.
> > >
> > > Whiel working on the test server (seperate hardware from live
> server)
> > > its performance was incredibly lame, so I decided to follow the
> document
> > > which prompted me to call support to ask them about this.
> > >
> > > I talked to support about this last week and they confirmed that
the
> > > appservers don't support the memory usage above 80 to 90 thousand
> > > (support wasn't able to give me an exact number).
> > >
> > > Did your Vantage still work above 100,000?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

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





[Non-text portions of this message have been removed]
What version is everyone running? I do know that with 8.00 - using OpenEdge 10.0b - you could go above the 100,000 threshold and use up the memory. Starting in 8.03 and the use of 10.1b from OpenEdge the 100,000 barrier became an issue. The 100,000 barrier is for databases with an 8k block size and the 200,000 barrier is with databases with 4k block sizes. This is actually an OpenEdge limitation with shared memory. Because OpenEdge does not come in a 64-bit version for Windows, then you will never be able to use more than 2GB for the entire application. Below is the official description of the problem and "fix" from the Progress knowledge base:
Cause:
Changes to internal architecture of the 10.1B client code and 10.1B database internals have changed the memory requirements and some functional limits for many executables.
In 10.1Bx the client will most likely only be able to connect in shared memory to a database whose total allocated shared memory is around 1.4 Gig of RAM (or less).
Depending on parameters used to start the database the following are the values typical for -B dependent on database blocksize:
DB Blocksize Approximate limit for -B value which
will allow shared memory connection
1k 1400000
2k 700000
4k 350000
8k 175000

These numbers are largely approximations.
Changes to .dll versions within a system may increase or lower these suggested values.
Changes to some startup parameters which affect shared memory such as -B, -L, -Mxs, -shmsegsize, et al. will likely alter the above limits.

Though the database may be able to startup with values higher than those listed above, the client requires a much larger heap size in 10.1B compared to earlier versions and this added memory usage lowers the total memory that the client can attach to and still be within the addressable 32-bit memory limit for a client executable on Windows.
Fixes:
Consider reducing the -B for the database startup. A good starting point is to reduce the prior value by 10%.

This is for Windows operating systems. OpenEdge 10.1b does not currently have a 64-bit version for Windows. I hear that's in the works.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason@...>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Late, Travis
Sent: Monday, April 06, 2009 4:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Buffer size


They couldn't give me an explanation. When I asked why I should lower it
they sent me the db tuning guide. They are completely contradicting
themselves with this one. Still holding steady at 11GB. I'll see where I
am at by the end of tomorrow. Hopefully not maxed out at 16GB.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Paul
Sent: Monday, April 06, 2009 3:07 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Buffer size

Why did they tell you to lower the number?

My server is a 32 bit so I'm thinking that is why I'm not able to go
past the 95 thousand.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...<mailto:tlate@...>> wrote:
>
> I currently have our Live DB running at 180,000. We have Windows
Server
> 2003 R2 64x. I put an extra 4GB of RAM in our server this weekend so
now
> we have 16GB.
>
>
>
> Our server currently says it's using 11GB of RAM and rising. I'm
baffled
> by this, but never monitored it this closely at my past jobs. I'm not
> going to lower the buffer size like support suggested. That honestly
> makes no sense to me. I was always taught the more of you DB you can
> store in RAM the better off you will be.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Paul
> Sent: Monday, April 06, 2009 2:15 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: DB Buffer size
>
>
>
> Here's my experience: I talked to support a while ago on how to
increase
> Vantage/database performance. They sent me a pdf file that had
> explanations of the settings in the progress explorer tool as well as
> other options.
>
> One of them was about the buffer size you mentioned. I found that I
> can't go beyond the 100000 mark in that number (don't know the exact
> number, currently have it set at 95 thousand), even though I have
plenty
> of memory to spare (also 12gb running a enterprise 2003 server). I
found
> the 100,000 mark because every time I would go up that high the
> appserver wouldn't start and I couldn't log into Vantage. The document
> suggested had a chart of numbers and their actual mb in ram usage
> results.
>
> Whiel working on the test server (seperate hardware from live server)
> its performance was incredibly lame, so I decided to follow the
document
> which prompted me to call support to ask them about this.
>
> I talked to support about this last week and they confirmed that the
> appservers don't support the memory usage above 80 to 90 thousand
> (support wasn't able to give me an exact number).
>
> Did your Vantage still work above 100,000?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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



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