December 17, 2006 at 11:23 am
I am about to delete the last SQL 2000 instance from a server with plain vanilla Windows 2000 server as the OS. There will now be just the one SQL 2005 instance on the box. None of the databases is more than 2Gb in size and there is 4 Gb of RAM. We are starting to make a lot of use of Reporting Services and I cannot afford another server machine to put the report server on so I would like to make as much use of that 4Gb RAM as possible.
My question is this. At present SQL Server can only address half of that RAM. Microsoft forbid using the /3Gb switch with Windows 2000 Server. Is it worth my while enabling AWE? And what should I look out for if I do?
I have read up as much as I can on this and cannot be sure whether I should just grin and bear the 2GB that cannot be used or go with AWE on which you see various warnings about danger of crashing the system.
Grateful for any advice anyone can offer
December 17, 2006 at 1:17 pm
Microsoft forbid using the /3Gb switch with Windows 2000 Server.
You can use /3gb switch in Windows 2000 too...
MohammedU
Microsoft SQL Server MVP
December 17, 2006 at 1:30 pm
Thanks very much for responding but the link you quote is to the very page where MS say "the /3GB switch should not be used on Windows 2000 Server because it is unsupported and can cause application or operating system crashes"; that is my problem, the OS is just Windows 2000 Server, not Advanced or DataCenter
December 18, 2006 at 12:55 pm
Sorry!
May be I misread your info...
Yes it is not supported for Windows 2000 Server edition...
Either you upgrade your OS to Advanced Edt.. or don't use it...
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply