Solved

Windows 2003 R2 Standard /3GB switch

Posted on 2011-09-07
8
1,093 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
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Learn about cloud computing and its benefits for small business owners.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

749 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