memory management - sql server 2005 32 bit on win 2003 64 bit using only 2 gb -


We have 5 GB RAM with 64 bits running in 32 bits in 2005. What is a way that SQL starts to use more than 2 GB? Some switch or some setting in SQL Server?

When I go to my SQL Server property and try to increase the maximum server memory to> 2 GB, then it reaches the old 2 GB.

> Thanks, Joy


Corrections - Friends: I have never seen that the value mentioned in the SQL Server config is in MB really enough It's stupid - but when you take things, you change the blind even in the most obvious things I was assuming the value described in the byte - the config screen saw 10 times and never ever paid attention to it.

See Slavic Oaks article. it has to be done.

And your licensing team is shouting about 32/64 bit licensing issues. See that you can match both the processor and the Cal for both the x86 / x64 license. As long as you do not take a shot at yourself using Workgroup version, you can go to 3Gb anyway. AdWords will not work in any way ...


Comments

Popular posts from this blog

windows - Heroku throws SQLITE3 Read only exception -

lex - Building a lexical Analyzer in Java -

python - rename keys in a dictionary -