Memory usage? Blank Title 112826

Thanks John, I really appreciate that! I'll be up there next week and will see how it's working.

thanks again!

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> For what it's worth, I've rarely seen DB that need more than 2GB of RAM to
> run well --even the massive ones. A lot of people tend to concentrate on
> how much of the DB is being cached when what really matters is how often
> the client requests are hitting the cache vs going to disk.
>
> 1. Open up proenv on your server and navigate to your DB directory.
> 2. Run "promon mfgsys"
> 3. Select option 5
> 4. Hit 'U' so it auto-updates
>
> You should see your 'Buffer Hits' in the lower left. This is just what it
> sounds like, the percentage of requests that are being server by the
> buffer. Unless you have a very large number of users, anything above 90%
> should pretty safely indicate that you aren't really being bottlenecked by
> your disks. (You can always check your Disk Queue Length to verify.)
>
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Aug 8, 2012 at 2:39 PM, Ned <TechnoBabbly@...> wrote:
>
> > **
> >
> >
> > I believe it will be limited to 2GB which is the limit for the 32-bit
> > version of Progress.
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of
> > Elizabeth
> > Sent: Wednesday, August 08, 2012 2:30 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Memory usage?
> >
> > We're running 9.04.507A SQL, using SQL Server 2005 on a Windows Server 2008
> > R2 64-bit box. A sister company is running 8.03.305K (Progress), and in the
> > process of upgrading to 9.05.700C (Progress), also on a 64-bit Win2008 R2
> > box.
> >
> > Over the course of a few hours each morning, our entire database loads into
> > RAM on the server. Since our sister company's Progress is only a 32-bit
> > app,
> > will it be able to load all of itself into RAM or will it be limited to 4G?
> >
> > Ernie Lowell
> > Diba Industries
> >
> > ------------------------------------
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
We're running 9.04.507A SQL, using SQL Server 2005 on a Windows Server 2008 R2 64-bit box. A sister company is running 8.03.305K (Progress), and in the process of upgrading to 9.05.700C (Progress), also on a 64-bit Win2008 R2 box.

Over the course of a few hours each morning, our entire database loads into RAM on the server. Since our sister company's Progress is only a 32-bit app, will it be able to load all of itself into RAM or will it be limited to 4G?

Ernie Lowell
Diba Industries
I believe it will be limited to 2GB which is the limit for the 32-bit
version of Progress.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Elizabeth
Sent: Wednesday, August 08, 2012 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Memory usage?

We're running 9.04.507A SQL, using SQL Server 2005 on a Windows Server 2008
R2 64-bit box. A sister company is running 8.03.305K (Progress), and in the
process of upgrading to 9.05.700C (Progress), also on a 64-bit Win2008 R2
box.

Over the course of a few hours each morning, our entire database loads into
RAM on the server. Since our sister company's Progress is only a 32-bit app,
will it be able to load all of itself into RAM or will it be limited to 4G?

Ernie Lowell
Diba Industries



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
For what it's worth, I've rarely seen DB that need more than 2GB of RAM to
run well --even the massive ones. A lot of people tend to concentrate on
how much of the DB is being cached when what really matters is how often
the client requests are hitting the cache vs going to disk.

1. Open up proenv on your server and navigate to your DB directory.
2. Run "promon mfgsys"
3. Select option 5
4. Hit 'U' so it auto-updates

You should see your 'Buffer Hits' in the lower left. This is just what it
sounds like, the percentage of requests that are being server by the
buffer. Unless you have a very large number of users, anything above 90%
should pretty safely indicate that you aren't really being bottlenecked by
your disks. (You can always check your Disk Queue Length to verify.)


*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Aug 8, 2012 at 2:39 PM, Ned <TechnoBabbly@...> wrote:

> **
>
>
> I believe it will be limited to 2GB which is the limit for the 32-bit
> version of Progress.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Elizabeth
> Sent: Wednesday, August 08, 2012 2:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Memory usage?
>
> We're running 9.04.507A SQL, using SQL Server 2005 on a Windows Server 2008
> R2 64-bit box. A sister company is running 8.03.305K (Progress), and in the
> process of upgrading to 9.05.700C (Progress), also on a 64-bit Win2008 R2
> box.
>
> Over the course of a few hours each morning, our entire database loads into
> RAM on the server. Since our sister company's Progress is only a 32-bit
> app,
> will it be able to load all of itself into RAM or will it be limited to 4G?
>
> Ernie Lowell
> Diba Industries
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


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