Solved

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

Posted on 2011-02-11
1
874 Views
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!
0
Comment
Question by:childersj
1 Comment
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
Comment Utility
On a 64bit system you do not need this switch, just simply allocate the required memory in the sql server config.
0

Featured Post

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A procedure for exporting installed hotfix details of remote computers using powershell
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now