Does anyone know what the Ram limit is on WINXP and WINXP PRO.
I work on large databases ( 1 gig > ) and I would like to cut out all
the Swap File action.

We also have some workstations that run Pagemaker/Quark.

Questions:
What is the technical limit?
What is the practical limit?

"Scott Burke" <ScottBurke@discussions.microsoft.com> wrote:

>Does anyone know what the Ram limit is on WINXP and WINXP PRO.
>I work on large databases ( 1 gig > ) and I would like to cut out all
>the Swap File action.

XP will handle up to 4 GB of RAM. There have been several posts
recently to the effect that if you have 4GB loaded, the OS reports
some smaller amount.

--
Tim Slattery
MS MVP(DTS)
Slattery_T@bls.gov

Besides memory, the Mass Storage system in most computers is
the biggest bottleneck. Along with more RAM, installing newer
technology (SATA, SATA-II) would certainly help, especially by
storing your database on a separate SATA drive using Larger
cluster size.

"Tim Slattery" <Slattery_T@bls.gov> wrote in message
news:r7qlr1d47qnip14gqirku8nt80qje9cncl@4ax.com...
> "Scott Burke" <ScottBurke@discussions.microsoft.com> wrote:
>
>>Does anyone know what the Ram limit is on WINXP and WINXP PRO.
>>I work on large databases ( 1 gig > ) and I would like to cut out all
>>the Swap File action.
>
> XP will handle up to 4 GB of RAM. There have been several posts
> recently to the effect that if you have 4GB loaded, the OS reports
> some smaller amount.
>
> --
> Tim Slattery
> MS MVP(DTS)
> Slattery_T@bls.gov

Hi Scott... I dont frequent this group but saw ur question so I'll tell
you what I know.
32bit operating systems (WinXP and Pro) have a memory limit of 4GB
however I've been told (not sure if its true however Windows Server
2003 DOES support 8GB memory!) that Windows can take more if you use a
startup switch??? (Google it!

64 bit operating systems (like Windows 64bit) also support 8GB of RAM.

One thing to bear in mind is the hardware (Your motherboard) also needs
to support up to 8GB ram!

Anyway... if 4GB is enough (and provided that your current hardware
supports it!!!!) You may still lose 512KB of that 4GB - if you wanna
know why .....Google it my friend.

Have you ever run 2GB??? Its seriously speeds up your system!! You can
pick up 2 x 1GB sticks of DDR or DDR2 memory for under £150.

I take it you are at work? I have no idea of your understanding of PC
hardware - your PC's could have upto 5 different types of memory!
However you are likely to have either SDRAM, DDR or DDR2.

Bear in mind many work desktops/workstations (especially Small Form
Factor (small PCs)) only have TWO memory slots!!

If you want to find out about your PC hardware - run a program like
cpuz (www.cpuid.org) on the desktop - that should give some clues.


Scott Burke wrote:
> Does anyone know what the Ram limit is on WINXP and WINXP PRO.
> I work on large databases ( 1 gig > ) and I would like to cut out all
> the Swap File action.
>
> We also have some workstations that run Pagemaker/Quark.
>
> Questions:
> What is the technical limit?
> What is the practical limit?

Thank you Tim.


"Tim Slattery" wrote:

> "Scott Burke" <ScottBurke@discussions.microsoft.com> wrote:
>
> >Does anyone know what the Ram limit is on WINXP and WINXP PRO.
> >I work on large databases ( 1 gig > ) and I would like to cut out all
> >the Swap File action.
>
> XP will handle up to 4 GB of RAM. There have been several posts
> recently to the effect that if you have 4GB loaded, the OS reports
> some smaller amount.
>
> --
> Tim Slattery
> MS MVP(DTS)
> Slattery_T@bls.gov
>

Scott Burke wrote:

> Does anyone know what the Ram limit is on WINXP and WINXP PRO.


First, note that it's not XP vs. XP Pro. There is no product called simply
"Windows XP." The two basic "flavors" of XP are XP Home and XP Professional.

The limit is the same for both XP Home and XP Professional: 4GB.

--
Ken Blake - Microsoft MVP Windows: Shell/User
Please reply to the newsgroup

"Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
news:A695C6EC-9986-406C-8974-329E25D2F8A6@microsoft.com...
> Does anyone know what the Ram limit is on WINXP and WINXP PRO.
> I work on large databases ( 1 gig > ) and I would like to cut out all
> the Swap File action.
>
> We also have some workstations that run Pagemaker/Quark.
>
> Questions:
> What is the technical limit?
> What is the practical limit?
You cannot install more than 4GB on a 32 bit processor no matter what OS you
use; that is the technical limit.
No process can address more than 3GB by the design of the OS. But, if you
only install 3GB, remember that there is non-paged pool which cannot be
swapped to disk.

You must determine how well your systems work with amounts less than 4GB
because program load makes some difference.

However, you will gain more improvement by using faster disks (for example)
because the database must reside there. I would suggest SATA 10,000 rpm
drives with as large a buffer as they sell.
You need both SATA and 10,000 rpm.
Jim

"Frobinrobin" <frobinrobin@hotmail.com> wrote:

>Hi Scott... I dont frequent this group but saw ur question so I'll tell
>you what I know.
>32bit operating systems (WinXP and Pro) have a memory limit of 4GB
>however I've been told (not sure if its true however Windows Server
>2003 DOES support 8GB memory!) that Windows can take more if you use a
>startup switch??? (Google it!

I'm extremely skeptical about this claim. 32-bit hardware has a 32-bit
address space. 2**32 = 4,294,967,296 bytes. Unless the hardware and
software do something extraordinary (remember memory banks and
expanded memory?) that's all the physical RAM that the machine can
talk to.

64-bit machines, of course, can address much more. The limits (AFAIK)
are *far* short of the theoretical maximum, 2**64
(18,446,744,073,709,551,616), but I don't know exactly what they are.

--
Tim Slattery
MS MVP(DTS)
Slattery_T@bls.gov

Hi Ken,
I thought I would ask. Remember we are talking Microsoft.

Thanks for your imput.


"Ken Blake, MVP" wrote:

> Scott Burke wrote:
>
> > Does anyone know what the Ram limit is on WINXP and WINXP PRO.
>
>
> First, note that it's not XP vs. XP Pro. There is no product called simply
> "Windows XP." The two basic "flavors" of XP are XP Home and XP Professional.
>
> The limit is the same for both XP Home and XP Professional: 4GB.
>
> --
> Ken Blake - Microsoft MVP Windows: Shell/User
> Please reply to the newsgroup
>
>
>

HI Jim,
It looks like my current computer needs more than just ram.
Pitty.... I just got it configured just right.

Oh well. If the boss needs the job done faster, he will just have
to spring for a new system.

ooH the pain.

Thanks
Scott Burke


"Jim" wrote:

>
> "Scott Burke" <ScottBurke@discussions.microsoft.com> wrote in message
> news:A695C6EC-9986-406C-8974-329E25D2F8A6@microsoft.com...
> > Does anyone know what the Ram limit is on WINXP and WINXP PRO.
> > I work on large databases ( 1 gig > ) and I would like to cut out all
> > the Swap File action.
> >
> > We also have some workstations that run Pagemaker/Quark.
> >
> > Questions:
> > What is the technical limit?
> > What is the practical limit?
> You cannot install more than 4GB on a 32 bit processor no matter what OS you
> use; that is the technical limit.
> No process can address more than 3GB by the design of the OS. But, if you
> only install 3GB, remember that there is non-paged pool which cannot be
> swapped to disk.
>
> You must determine how well your systems work with amounts less than 4GB
> because program load makes some difference.
>
> However, you will gain more improvement by using faster disks (for example)
> because the database must reside there. I would suggest SATA 10,000 rpm
> drives with as large a buffer as they sell.
> You need both SATA and 10,000 rpm.
> Jim
>
>
>