> -----Original Message-----
> I Think I would gain some speed by upgrading this server to have i.e.
> 2 Gb of RAM.
> Or ??

In short yes.

A little longer explaination.

You may wish to try lowering the DB's Page buffers setting. Keep in
mind this may adversely effect performance or it may not. (If I
understand things correctly) What you are 'in essences' are doing here
is saying that I'll have x # of my DB's pages in memeory while the
server is running. Memory is faster the HD. This is a good thing. But
you are using up most all your memory, so what you are saying then is
that you want to lower x, so not as much of the DB is in memory, you
give your server some room to work (not swap as much), but then you
don't have as much of your DB in memory as you had before.

As an side note, you don't control which of the DB's pages are cached,
the server does and it makes it decission based on pages that are being
accessed a lot/a that time for the queries that are running.

You may, also, benefit from doing a little research to get the block
size of the File System you are running on (I believe in Win2k it
depends on the Format [FAT/NTFS) and the size of the Disk - You can find
it out by going to Disk Administrator I think) setting the DB Page size
= the Block Size of your file system. This way page loads, and page
writes are almost always an 'single' operation.

http://www.ibphoenix.com used to have an article on tuning/tweaking the
performance of the DB. That is where I started.

HTH,

George

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003