July 21, 2008 at 5:31 pm
I installed 64 bit SQL Server Enterprise Edition (version = 9.00.3068.00) on a Dell 2950 (8 GB RAM, 2 X5450 Quad Core Xeons) with Windows Server 2003 R2 Standard x64 SP2. The OS should also have been Enterprise edition, but since this is for testing, I didn't take the time to reinstall it. When I go to set maximum server memory in SSMS, the largest number allowed is 2GB. I thought the client tools ran as 32 bit apps on x64, but SQL Server ran as a 64 bit app. The 2 GB limit would imply SQL Server is running 32 bit. Does SQL run as a 32 or 64 bit app in this scenario?
July 22, 2008 at 2:41 am
Kevin,
are you sure that it only allows a max memory of 2 Gb? The default number shown in SQL2K5 (2147483647 MB) is actually about 2 TB and it will show that, no matter how much RAM you actually have in the machine.
With W2K3 Standard x64 you should be able to address up to 32 Gb and if you don't set a lower max value for SQL Server, SQL will claim all of that after some time.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply