Solved

Windows 2003 R2 Standard /3GB switch

Posted on 2011-09-07
8
1,100 Views
Last Modified: 2012-05-12
Dear Experts:

I have one windows 2003 R2 32 bits server with SQL 2008 32 bits Standard Server installed.
Our SQL seems to suffer from some performance issue.  
I heard a lot of "/3GB" switch to improve application performance.
Can I use this switch "/3GB" to improve our SQL performance and how to modify it?
What is the risk by doing so?

Thanks,

Charlie


0
Comment
Question by:chencharlie1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 8

Assisted Solution

by:Amitabh Singh
Amitabh Singh earned 350 total points
ID: 36496959
Hi

 To Set the /3GB Startup Switch in Windows Server 2003
================================================================================
>  Right-click My Computer and select Properties. The System Properties dialog box will appear.

    Click the Advanced tab.

    In the Startup and Recovery area, click Settings. The Startup and Recovery dialog box will appear.

    In the System startup area, click Edit. This will open the Windows boot.ini file in Notepad.

    In the [Operating Systems] section, add the following switches to the end of the startup line that  includes the /fastdetect switch: /3GB

    Save the changes and close Notepad.

    Click OK two times to close the open dialog boxes, and then restart the computer for the change to take effect.

================================================================================
http://technet.microsoft.com/en-us/library/bb124810%28EXCHG.65%29.aspx
0
 
LVL 13

Assisted Solution

by:Govvy
Govvy earned 100 total points
ID: 36496961
0
 
LVL 8

Expert Comment

by:Amitabh Singh
ID: 36496973
What is the risk by doing so?

their is no risk but it can cause your OS performance get a bit slower as 3GB RAM reserved for application
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:chencharlie1
ID: 36497756
Hi Tech Eng:
I have just added the /3GB switch into the boot.ini.
Please let me know if the following changes is correct in boot.ini file.

One more question: What is the "/USERVA=2800" for?
I saw some experts mentioned this one.
Do I need to use it or I can leave it alone.
Thanks
------------------------------------------
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /NoExecute=OptOut
0
 
LVL 8

Assisted Solution

by:Amitabh Singh
Amitabh Singh earned 350 total points
ID: 36501178
Hello chencharlie1

yes parameter is correct !
============================================================================
The /USERVA switch is new to Windows Server 2003 and provides better granularity for splitting memory allocations between user mode and kernel mode,

Note Microsoft Product Support Services strongly recommends using a range of memory that is within the range of 2800 to 3030 for the /USERVA switch. This range is wide enough to provide a large enough pool of system page table entries for all currently observed issues. Typically, a setting of /userva=2800 provides close to the maximum available number of system page table entries that are possible
============================================================================
for more information have a look to the Microsoft link below
============================================================================
http://support.microsoft.com/kb/823440
0
 
LVL 62

Assisted Solution

by:gheist
gheist earned 50 total points
ID: 36501205
Not all executables actually can use >2GB of RAM
You can edit them http://msdn.microsoft.com/en-us/library/d25ddyfc.aspx (largeaddressaware) but make sure you back up original.
Why not 64bit system?
0
 
LVL 8

Accepted Solution

by:
Amitabh Singh earned 350 total points
ID: 36501225
the Microsoft link which  i provided regarding /USERVA  is for exchange server but its same for SQL aslo
some more information you can found in this link also
---------------------------------------------------------------------------------------------------------
http://support.microsoft.com/?kbid=316739
---------------------------------------------------------------------------------------------------------
in your case you need to use , /Userva switch like

timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /Userva=2900 /NoExecute=OptOut
---------------------------------------------------------------------------------------------------------
this for more precise tuning of user and kernel virtual memory space,it will allocate 2900 MB of User-mode virtual memory and 1196 MB of Kernel-mode virtual memory!
0
 
LVL 62

Expert Comment

by:gheist
ID: 36502485
SQL 2008 r2 express is limited to two gigabytes

How performance issues display themselves?
What are memory tuning parameters of SQL server? (maximum memory should not exceed actual RAM size)
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

687 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