SQL 2005 not using all the memory that is allocated to it

I have a SQL Server 2005 SP2 running on Windows 2008 64 bit machine with 12 gb of ram
I have allocated 9.5 gb of ram to SQL Server via SP_Configure - however then I go see the memory usage via Resource Monitor in Windows Server I see it only using 487000kb of memory.

Need to find out why sql server is not using all of the 9.5gb that is allocated to it.
Thanks
DavidKanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Ok. Check whether you have enabled

* Lock Pages in Memory for the startup account of SQL Server service.
http://www.tipandtrick.net/2008/enable-lock-pages-in-memory-to-prevent-database-paging-to-disk/
"Eventhough Lock Pages in Memory is not required for 64-bit operating system, it’s recommend to lock pages in memory."

* Apply SP3

Restart your machine once after the above changes..
And hope you have 64 bit SQL Server 2005 instead of 32 bit..
If you have 32 bit SQL Server 2005, then make sure you have enabled AWE..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Ok.. Kindly confirm the Min and Max values specified in your SQL Server instance.
Also let me know whether you have one or more instance in your server.
0
 
ong-hhCommented:
What version of SQL Server  2005 are you using?

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
k_murli_krishnaCommented:
SQL Server will use some memory as per the memory component/requirement of its architecture. With user defined tables when one does SELECT/INSERT/UPDATE/DELETE all occur in RAM. So, when lots of these happen especially SELECT fetching lot of records from big tables, your RAM usage will increase.

Also refer:

SQL Server memory architecture
http://blogs.msdn.com/teekamg/archive/2007/11/05/sql-server-memory-architecture.aspx

Memory Management in SQL Server 2005
http://www.gre-sqlserver-solutions.com/Memory.html
http://searchsqlserver.techtarget.com/searchSQLServer/downloads/Guru_Guide_to_SQL_Server_Architecture_Chap%2011_AWL.pdf
Dynamic Memory Management
http://msdn.microsoft.com/en-us/library/ms178145.aspx

How to adjust memory usage by using configuration options in SQL Server
http://support.microsoft.com/kb/321363
SQL Server memory usage
http://blog.colinmackay.net/archive/2008/07/20/2996.aspx
SQL Server Memory Usage Grows and Not Shrinks
http://www.sql-server-performance.com/faq/sql_server_memory_usage_p1.aspx
0
 
DavidKanAuthor Commented:
rrjegan17:
Ok.. Kindly confirm the Min and Max values specified in your SQL Server instance.
Also let me know whether you have one or more instance in your server.

Min 9500
Max: 10000

Only 1 instance running
0
 
DavidKanAuthor Commented:
ong-hh:
What version of SQL Server  2005 are you using?

SQL 2005 Developer Edition with SP2
0
All Courses

From novice to tech pro — start learning today.