Maximum memory on a 64-bit operating system?

364155 pts.
Tags:
64-bit (x64)
Capacity planning
Memory management
Operating systems
SQL Server administration
SQL Server memory
I need to install a new SQL server and we are buying a 64-bit OS. What's the maximum amount of memory that the operating system can hold/support/make use of?

Software/Hardware used:
SQL server

Answer Wiki

Thanks. We'll let you know when a new response is added.

It depends on the OS version.

Take a look at this:

Memory Limits for Windows Releases (MSDN).

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Radyair
    You aren't going to run this on some supercomputer cluster, right? Then your practical limits as of today are going to be: 32Gb RAM in Windows Standard 2008 (64 bit) 128Gb RAM in Windows HPC Edition 2008 (64 bit) 192Gb RAM limit in most current HP and IBM servers under $20,000 1 Tb RAM in Linux 2.6.28 kernel distributions and later
    450 pointsBadges:
    report
  • ITKE
    [...] 10. Carlosdl and Radyair provided some great resources and general specs for the inquiry regarding the maximum memory on a 64-bit operating system? [...]
    43,525 pointsBadges:
    report
  • andrewjackson
    Hi

    First make sure which version of sql server u want to install then proceed further, find here some useful source http://msdn.microsoft.com/en-us/library/ms143506.aspx
    65 pointsBadges:
    report
  • Harisheldon
    You cannot just look at the software and assume how much memory you will need.  Saying that, you will need to have at least the bare minimum to run the program.  You will need to look at the hardware that you are installing the software on and see if it is capable of holding all of the memory that you either need, or want to install to run the software.  A good rule is to take the minimum that you need, increase it by at least half, and that should be a good staring point to go from.  Me, I always try to double it.
    7,505 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following