[Webinar] Streamline your web hosting managementRegister Today


Memory Deference between Win 2008 R2 server & Win 2003 Server

Posted on 2010-03-31
Medium Priority
Last Modified: 2012-05-09
  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.
Question by:DWTCIT
  • 2
LVL 10

Accepted Solution

skca54 earned 1000 total points
ID: 29188197
64-bit allows you to get past the 3.5 to 4Gb limit on 32-bit OSs.
LVL 10

Assisted Solution

skca54 earned 1000 total points
ID: 29188305
Server 2008 R2 is only available in a 64-bit version so you are not limited by the above mentioned limit.

Assisted Solution

leonov_alex earned 500 total points
ID: 29188703
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.
LVL 59

Assisted Solution

by:Darius Ghassem
Darius Ghassem earned 500 total points
ID: 29205327

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question