dbTalk Databases Forums  

Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 )

Go Back dbTalk Databases Forums Databases sybase.public.sqlanywhere.general Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 )

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 ) in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Frank Ploessel
 
Posts: n/a

Default Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 ) - 10-31-2007 , 11:16 AM





MD,

If you do not tell it explicitely not to do so, SQL Anywhere tries to be
nice and give resources to other applications that might run on the server
as long as it does not need them. In this case, maybe the queries running
on your engine do not need much cache.

You can use the -ca 0 command line switch on a dedicated server to force
the db engine not to do dynamic cache sizing (the technical term for
"being nice").

Frank


On Wed, 31 Oct 2007 17:16:51 +0100, <MD> wrote:

Quote:
My ASA network server runs on Opetron 4 CPU 4GB RAM, we have
/3G option enabled, (ASA is not enabled for AWE). There are
no other significant jobs or processes on this machine other
than ASA. The ASA config has -c 1536M parameter, the DB size
is approx 15G.

On the windows performance monitor, I see that DBSRV9.EXE's
memory usage never exceeds more than 100 MB, although the
server has 2 GB RAM available for it. Typically the mem
usage is 77,200K, peak mem usage is 91,972K, VM size is
107,264K. However, the O/S page file usage is CONSTANTLY -
2GB. Also, we have the ASA server temp file on a separate
disk drive, but it is always 0 byte.

Can anyone please help me understand why DBSRV9.EXE does not
take more memory ? And, why ASA server temp file is always 0
bytes? (see attached perfmon pictures).

Some statistics of ASA is as under

Page size 4K

dbspace_name free_space
'SYSTEM' 47006707712
'Transaction Log' 10652241920
'Temporary File' 21277491200

select DB_PROPERTY('TempTablePages') = 300 pages


Really appreciate if you can shed some light on this.

Thanks.


Reply With Quote
  #2  
Old   
John Smirnios
 
Posts: n/a

Default Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 ) - 10-31-2007 , 12:24 PM





It sounds to me like you are using the task manager and not perfmon. Are
you *sure* you are using perfmon and not the task manager? What the task
manager calls "mem usage" is actually the working set size. What the
task manager case "VM Size" is actually the committed memory size and
not the address space size as one might expect. Task manager is
definitely not what you want to use. Use perfmon.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

MD wrote:
Quote:
My ASA network server runs on Opetron 4 CPU 4GB RAM, we have
/3G option enabled, (ASA is not enabled for AWE). There are
no other significant jobs or processes on this machine other
than ASA. The ASA config has -c 1536M parameter, the DB size
is approx 15G.

On the windows performance monitor, I see that DBSRV9.EXE's
memory usage never exceeds more than 100 MB, although the
server has 2 GB RAM available for it. Typically the mem
usage is 77,200K, peak mem usage is 91,972K, VM size is
107,264K. However, the O/S page file usage is CONSTANTLY -
2GB. Also, we have the ASA server temp file on a separate
disk drive, but it is always 0 byte.

Can anyone please help me understand why DBSRV9.EXE does not
take more memory ? And, why ASA server temp file is always 0
bytes? (see attached perfmon pictures).

Some statistics of ASA is as under

Page size 4K

dbspace_name free_space
'SYSTEM' 47006707712
'Transaction Log' 10652241920
'Temporary File' 21277491200

select DB_PROPERTY('TempTablePages') = 300 pages


Really appreciate if you can shed some light on this.

Thanks.

Reply With Quote
  #3  
Old   
MD
 
Posts: n/a

Default Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 ) - 10-31-2007 , 12:37 PM



My apologies, yes, I am using task manager (not perfmon)...

In Perfmon, for dbsrv9 process, I see working set peak as
94Mb, Virtual bytes peak as 182 MB, Private Bytes 110Mb,
Page file bytes = 110Mb, IO write bytes/sec oscilating
between couple hundred to 100,000.

For the system, I see Cache bytes as 158MB, Cache peak as
230MB, paging file usage as 14% (15% peak), on Server tab, I
see pool non-paged bytes as 3Mb.

Thanks
MD
Quote:
It sounds to me like you are using the task manager and
not perfmon. Are you *sure* you are using perfmon and not
the task manager? What the task manager calls "mem usage"
is actually the working set size. What the task manager
case "VM Size" is actually the committed memory size and
not the address space size as one might expect. Task
manager is definitely not what you want to use. Use
perfmon.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through
the iAnywhere Developer Community at
http://www.ianywhere.com/developer

MD wrote:
My ASA network server runs on Opetron 4 CPU 4GB RAM, we
have /3G option enabled, (ASA is not enabled for AWE).
There are no other significant jobs or processes on this
machine other than ASA. The ASA config has -c 1536M
parameter, the DB size is approx 15G.

On the windows performance monitor, I see that
DBSRV9.EXE's memory usage never exceeds more than 100 MB
, although the server has 2 GB RAM available for it.
Typically the mem usage is 77,200K, peak mem usage is
91,972K, VM size is 107,264K. However, the O/S page file
usage is CONSTANTLY - 2GB. Also, we have the ASA server
temp file on a separate disk drive, but it is always 0
byte.
Can anyone please help me understand why DBSRV9.EXE does
not take more memory ? And, why ASA server temp file is
always 0 bytes? (see attached perfmon pictures).

Some statistics of ASA is as under

Page size 4K

dbspace_name free_space
'SYSTEM' 47006707712
'Transaction Log' 10652241920
'Temporary File' 21277491200

select DB_PROPERTY('TempTablePages') = 300 pages


Really appreciate if you can shed some light on this.

Thanks.

Reply With Quote
  #4  
Old   
John Smirnios
 
Posts: n/a

Default Re: why DBSRV9.EXE does not occupy RAM ? (ASA 9.0.2.2451 ) - 11-01-2007 , 01:27 PM


Something is wrong here... There is no way that we have just 182MB of
address space allocated (as shown by the Virtual Bytes counter) for a
server that has -c 1536m on the command line. Can you check that you
didn't slip a digit and that it isn't 1820MB?

You have -c 1536m but do you have any other cache-related switches? -cl?
-ch? -cw? Unless you have a -cl, Private Bytes and Page File Bytes
should both be > 1563MB.

Please take a look at the startup messages for you server. It should
display the initial min & max cache sizes as shown below (your numbers
will be different):

5120K of memory used for caching
Minimum cache size: 5120K, maximum cache size: 512000K


-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

MD wrote:
Quote:
My apologies, yes, I am using task manager (not perfmon)...

In Perfmon, for dbsrv9 process, I see working set peak as
94Mb, Virtual bytes peak as 182 MB, Private Bytes 110Mb,
Page file bytes = 110Mb, IO write bytes/sec oscilating
between couple hundred to 100,000.

For the system, I see Cache bytes as 158MB, Cache peak as
230MB, paging file usage as 14% (15% peak), on Server tab, I
see pool non-paged bytes as 3Mb.

Thanks
MD
It sounds to me like you are using the task manager and
not perfmon. Are you *sure* you are using perfmon and not
the task manager? What the task manager calls "mem usage"
is actually the working set size. What the task manager
case "VM Size" is actually the committed memory size and
not the address space size as one might expect. Task
manager is definitely not what you want to use. Use
perfmon.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through
the iAnywhere Developer Community at
http://www.ianywhere.com/developer

MD wrote:
My ASA network server runs on Opetron 4 CPU 4GB RAM, we
have /3G option enabled, (ASA is not enabled for AWE).
There are no other significant jobs or processes on this
machine other than ASA. The ASA config has -c 1536M
parameter, the DB size is approx 15G.

On the windows performance monitor, I see that
DBSRV9.EXE's memory usage never exceeds more than 100 MB
, although the server has 2 GB RAM available for it.
Typically the mem usage is 77,200K, peak mem usage is
91,972K, VM size is 107,264K. However, the O/S page file
usage is CONSTANTLY - 2GB. Also, we have the ASA server
temp file on a separate disk drive, but it is always 0
byte.
Can anyone please help me understand why DBSRV9.EXE does
not take more memory ? And, why ASA server temp file is
always 0 bytes? (see attached perfmon pictures).

Some statistics of ASA is as under

Page size 4K

dbspace_name free_space
'SYSTEM' 47006707712
'Transaction Log' 10652241920
'Temporary File' 21277491200

select DB_PROPERTY('TempTablePages') = 300 pages


Really appreciate if you can shed some light on this.

Thanks.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top