Memory Deference between Win 2008 R2 server & Win 2003 Server

Hi,  
  I just want to know the exact deference in memory between Win 2003 server with SQL 2005 & Win 2008 server with SQL 2008 . What I mean that I know that SQL 2005 server service will be allocated 2 GB memory as maximum from Win 2003 server with an option to increase it to 3 GB memory. is it the same situation with win 2008 R2  server.
also what is the deference between 32 bit & 64 bit memory wise.
DWTCITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

skca54Senior EngineerCommented:
64-bit allows you to get past the 3.5 to 4Gb limit on 32-bit OSs.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skca54Senior EngineerCommented:
Server 2008 R2 is only available in a 64-bit version so you are not limited by the above mentioned limit.
0
leonov_alexCommented:
32-bit OS can operate only 4Gb RAM. And one separate process can use 3Gb maximum (PAE mode).
64-bit OS can operate 2Tb memory.

If your hardware has 4Gb RAM or more use 64-bit OS.

MS SQL try take memory as it need, but can't break OS limits.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.