HI, We are using SQL 2005 Standard Edition on the Windous 2003 Enterprise Edition server. We have 16 GB RAM and Database Size 20GB. Memory usege only 2.3GB. Why SQL does not use additional memory to cache data?
Have you activated all the /3GB or /PAE parameters in the boot.ini file? Have you enabled AWE on the SQL Server?
Is the 2GB limit removed on Standard Edition in 2005?
Referring to this it is: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Did you set the memory allocation in the SQL Server properties? You should be able to increase it to the OS maximum.
Hi, I have activated /PAE parameters in the boot.ini file and enabled AWE on the SQL Server. I have tryes to set Min Memory to 4GB and it still allocated only up to 2.3GB. ???
What about /3GB (and /PAE) ?
Found on another Forum http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=13611#62699 We have built a test server and installed 2005 standard ed. The test server has 6 gig of RAM and the /PAE boot.ini switch (it’s a 32 bit system). I was able to turn on the SQL Server 2005 “Use AWE” memory setting, after granting the “Lock Pages in Memory” permission to the account under which it runs. Perf Mon > SQL Server Buffer Manager > Database pages shows 665,145 in use, vs. our SQL Server 2000 Standard Ed box, which shows only 185,000. If I have the math right, that means: 2005 Standard Ed Data Cache: 665,145 pages / 128 pages per MB = 5,196 MB 5,196 / 1024 = 5.07 GB 2000 Standard Ed Data Cache: 185,000 pages / 128 pages per MB = 1,445 MB 1,445 / 1024 = 1.4 GB So I think it works after all. Yay! Hope it will serve you. I can’t test it cause i don’t have W2003 nor SQLServer. Regards,