Does windows server 2008 R1 x64 with sql 2008 R2 support the /3gb memory switch?

Posted on 2011-02-11
Medium Priority
Last Modified: 2012-05-11
On Windows Server 2003 with SQL 2005 I know you could allocate only 1gb of memory for the OS and 3gb for applications.  Is this a viable option in Windows Server 2008 R1 x64 running SQL 2008 R2?  I have 4gb of RAM on the box and it seems to allocate memory, but only actively use about 45%.  The server will have reports run against it during the day and be performing an ETL process at night.  I did find the following link which explains what I already know but doesn't really say whether it is an option or a good idea for this scenario: http://msdn.microsoft.com/en-us/library/ms178067.aspx

I know there are things they can do such as optimize the ETL process to make sure they are selecting only columns that they need and not entire tables.  We can give it more memory, but we want to make sure the configuration is optimized first before throwing more resources at it.  Please help!
Question by:childersj
1 Comment
LVL 16

Accepted Solution

EvilPostIt earned 2000 total points
ID: 34871998
On a 64bit system you do not need this switch, just simply allocate the required memory in the sql server config.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Viewers will learn how the fundamental information of how to create a table.

624 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