SQL Server Performance Forum – Threads Archive

memory switch

hello, i have a couple sql 2000 enterprise on windows 03 advance server. each box have 10GB of memory installed. I’m a bit confuse on what switch to use to enable sql to more memory. currently, i have the /pae switch in boot.ini and awe enabled on sql. But From reading microsoft recommedation, it is recommended to use /3gb and /pae in boot.ini, also enabling awe. thanks
Calvin

The /3gb switch is optional. You do normally want to use it though unless you have more than 16gb of RAM. If you have the /3gb switch enabled, the server will have only 1gb for the OS. The other 3gb will be used for applications. You will then have to use the awe memory less, generally resulting in better performance. How big is your largest database? How big are the total databases? How intensive is the memory usage on the server? What is your current buffer cache hit ratio, cache hit ratio, target server memory, and total server memory on the server? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Check the stats using PERFMON(SYSMON) tool for Derrick’s reference. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

is window 2003 advanced server = 2003 enterprise edition?

By default, Windows can address a total of 4 gigabytes (GB) of virtual address space. By default, 2 GB of this is reserved for the kernel (operating system), and 2 GB is reserved for User mode programs. Only use the /3GB switch with the following operating systems:
â€¢ Windows 2000 Advanced Server
â€¢ Windows 2000 Datacenter Server
â€¢ Windows NT 4.0 Enterprise Server BTW how about the SQL memory configuration? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>