/3GB on a cluster
-
Hi
We have SQL 2000 Enterprise, SP3 running on Windows 2000 Advanced in an active/passive cluster. The boxes were upgraded from 2GB to 4GB at the weekend but SQL is still using 1.7GB
Am I right in thinking that adding the /3GB switch to the boot.ini and leaving SQL to dynamically manage memory will allow SQL to grab up to around the 3GB mark? This is a dedicated SQL box so 1GB should be fine for the OS.
Are there any gotchas or risks in doing this? Should I do the active or passive node first?
cheers
-
yes, you are right. Adding the /3Gb should do the trick.
gotchas ? The /3Gb is in the boot.ini so it will need a reboot.
If you do your action on the passive node first, you'll be able to failover and sql will be able got use up to 3Gb.
Then you can perform your action on the first node, and failback if needed
BTW this thread should be in the SQL2000 forum
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I don't think so just using /3GB switch will make sql to use more than 2 GB of ram. You should enable AWE also at the SQL Server level for sql to use more than 2gb of RAM.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
check out http://www.sql-server-performance.com/awe_memory.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Hello,
AWE enabled is only to take advantage of more than 4GB (switch /PAE maust be enabled in boot.ini).
/3GB (for server with less than 16GB) to have more memory (in this case 3GB) available, and reserve only 1 GB to operating system.
-
Hi,
agree with previous post.
In addition please refer to http://support.microsoft.com/kb/291988, since these things (/3GB, /PAE, AWE) are different, and http://support.microsoft.com/kb/274750.
/3GB changes default user space/kernel space from 2/2 to 3/1 respectively.
rgds
Sinisa
-
I sometimes worry that here we are 7 years on from SQL 2000 and we still have these endless posts about memory on SQL Server. Even more worrying is the number of incorrect posts too.
Just to add my 2 p worth, with 4GB ram you can take two routes:-
enable /3gb and sql server will pick up the extra memory, you don't have to do anything else at all, memeory used will go to around 2.7gb reported use.
enable /PAE + awe in this case you must set maximum memory, awe does this anyway but you must leave enough for the o/s, usually 1Gb.
The difference in the two versions is /pae only increases the data cache whilst the /3gb also increases the various internal pools.
note that awe disables dynamic memory allocation, you must set max memory otherwise it will attempt to take most memory. You cannot use task manager to see memory used with awe enabled btw. It's quite surprising how many people still don't know this.
This is for 32bit o/s and sql server.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
After looking at some of the links, am I correct in saying that a Windows 2000 Server with Sql-Server 2000 STANDARD Edition is not able to use more than 1.7 GB?
Steve
-
Yes, you are correct.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply