Re: Allocating more memory to sql server
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/23/04
- Next message: Cornelius Wipf: "Installing sqlserver SP3"
- Previous message: jwf: "Re: MSDE Re-Install Fails"
- In reply to: Subbaiahd: "Re: Allocating more memory to sql server"
- Next in thread: Subbaiahd: "Re: Allocating more memory to sql server"
- Reply: Subbaiahd: "Re: Allocating more memory to sql server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 17:38:52 -0500
Are you sure you have Windows 2000 Advanced Server and not just Server? You
need Win2K Adv Server and SQL EE to use more than 4GB. Does the OS
recognize all 6GB? YOu should not use Task Manager to monitor memory for
SQL Server. Use Perfmon instead. There are counters for Target and total
memory used by SQL Server that will give a better idea of the actual usage.
You also need to restart SQL Server after enabling AWE for it to take
effect.
-- Andrew J. Kelly SQL MVP "Subbaiahd" <subbaiahd@hotmail.com> wrote in message news:%23734AQX0EHA.2676@TK2MSFTNGP12.phx.gbl... > Thanks for the response, it helped to improve little bit. > after i added the swith /3GB in boot.ini file and did configure sql server > to awe enable. i see a little improvement from 1.65 GB to 2.65 GB. In > windows task manager total physical memory shows as memory usage 5766448KB > , > total memory usage is only 3GB, I setup sql server to a fixed memory of > 4.5gb. Still 3GB memory is not being used, can you please suggest what is > going wrong. > > Regards, > Subbu. > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23Zd95l$zEHA.1188@tk2msftngp13.phx.gbl... >> The PAE switch is so the OS can use more than 4GB but you still need to > turn >> on AWE in SQL Server for it to use more than the 2GB you are using now. > You >> want to add the /3GB switch in the boot.ini to allow SQL Server to use >> 3GB >> of the directly addressable memory and then by turning on AWE you can use > up >> to the 6GB. But when you turn it on you want to make sure you set the >> MAX >> memory setting to about 5GB since AWE does not dynamically adjust memory >> when AWE is on. YOu also need Enterprise Edition of SQL Server or you >> can >> only use 2GB of memory regardless of the settings. >> >> >> http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory >> http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 > memory >> usage >> http://www.support.microsoft.com/?id=274750 Memory config >> http://www.support.microsoft.com/?id=283037 Large Memory Support > Is >> Available in Windows 2000 (AWE) >> http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of >> memory >> >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Subbaiahd" <subbaiahd@hotmail.com> wrote in message >> news:usLu%23S%23zEHA.1296@TK2MSFTNGP10.phx.gbl... >> >I have a Dell machine, which has 4 processors, 6 gb memory , and windows >> > 2000 adv. I have a db size of 200GB. >> > >> > Perfmonitor always show memory in use is 2GB and allocated to sql >> > server >> > is >> > 1.7GB, even if i run memory and disk intensive jobs i haven't seen the >> > values above 2GB. If i see on windows exp. help i can see that the > system >> > has 6gb memory. what happened to remaining memory why it was not >> > recognised. I setup sql server to dynamic memory configuration. I know >> > i >> > have to seyup in boot.ini switches to /pae, i did, still i didnt see it >> > improved, any suggestion are welcome. >> > >> > Thanks, >> > Subbu. >> > >> > >> >> > >
- Next message: Cornelius Wipf: "Installing sqlserver SP3"
- Previous message: jwf: "Re: MSDE Re-Install Fails"
- In reply to: Subbaiahd: "Re: Allocating more memory to sql server"
- Next in thread: Subbaiahd: "Re: Allocating more memory to sql server"
- Reply: Subbaiahd: "Re: Allocating more memory to sql server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
