Problems after setting /3GB switch in boot.ini



Hi all,

On a Windows 2003 Server Enterprise web server that also runs SQL Server
2005 Standard and a rather large ASP.NET 2.0 application, I tried to improve
performance by adding the /3GB switch to the boot.ini file.

The server has only 4GB of RAM.

After adding the switch, hoping to boost performace for SQL Server, and
rebooting the machine, I now find that my ASP.NET application which uses SQL
Server as a backend, is running much slower than before.

I have since removed the /3GB switch from the boot.ini and rebooted the
server, but the peformance has not returned.

Is there a registry setting that might be stuck that I would need to fix?

Thanks for any help...



.



Relevant Pages

  • Re: SQL 2000 memory in W2K3
    ... Kernel Components will be restricted using only 1 GB of RAM in case you add /3GB switch to the boot.ini file. ... > Microsoft Windows Server 2003 R2 ... Do not worry about SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)