SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL server only uses 2.7GB on 8GB server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

j0nx
Starting Member

4 Posts

Posted - 04/07/2007 :  15:07:11  Show Profile  Reply with Quote
Accidently posted this in the development forum.

Here is the setup.

Hardware:
Dell Quad Xeon 2.7ghz
8 GB ram

Software:
Windows 2003 Server Enterprise
Sql 2000 Enterprise Sp3

Boot.ini Settings:
/PAE /3GB

Sql Settings:
AWE = 1
Max server memory = 7000 (fixed)

Database sizes:
150GB
220GB

With these settings, sqlserver.exe will use only 2.7GB of memory with over 4GB of memory left available to the server (the server properly reports 8GB total). Perfmon "sqlserver:total server memory" confirms this. If I take out the /3GB switch in boot.ini, sqlserver will only use 1.7GB. These are hard limits as SQL never scales past these amounts even under load for several days. What am I missing??

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 04/07/2007 :  15:20:31  Show Profile  Reply with Quote
Did you restart the server after you changed the max server memory setting?
Go to Top of Page

j0nx
Starting Member

4 Posts

Posted - 04/08/2007 :  11:51:42  Show Profile  Reply with Quote
quote:
Originally posted by sql_er

Did you restart the server after you changed the max server memory setting?



Yes
Go to Top of Page

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 04/09/2007 :  11:34:52  Show Profile  Reply with Quote
Hmm ... don't know then.

I followed advices here and as long as server is restarted, it worked:

http://support.microsoft.com/kb/274750/

http://www.sql-server-performance.com/awe_memory.asp
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/09/2007 :  15:48:15  Show Profile  Reply with Quote
Does sql service account has following user rights on the server?

Act as part of the operating system
Increase quotas
Log on as a batch job
Log on as a service
Replace a process level token
Bypass traverse checking (that is usually set for Everyone anyway)
Lock pages in memory
access this computer from the network
backup files
restore files
increase scheduling priority
load & unload device drivers
Go to Top of Page

j0nx
Starting Member

4 Posts

Posted - 04/12/2007 :  15:25:23  Show Profile  Reply with Quote
quote:
Originally posted by rmiao

Does sql service account has following user rights on the server?

Act as part of the operating system
Increase quotas
Log on as a batch job
Log on as a service
Replace a process level token
Bypass traverse checking (that is usually set for Everyone anyway)
Lock pages in memory
access this computer from the network
backup files
restore files
increase scheduling priority
load & unload device drivers



Awesome, that did it! (I'm assuming the lock pages in memory) The task manger is reporting the memory usage incorrectly, but the perfmon object is dead on.

Thanks!
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 05/08/2007 :  11:22:28  Show Profile  Reply with Quote
Where do you go to look how these user rights are set up?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 05/08/2007 :  15:44:07  Show Profile  Reply with Quote
Local security policy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000