Memory Qn

[Tomi]

Hi

My server (dedicated SQL system ) has 3 GB of physical memory and it runs SQL 2000 standard ed. My system admin said that that SQL std. ed. can only see upto 2GB.But when I look at the Total server memory and Target memory it is always showing only 1.6gb.
Why is it showing 1.6Gb when it can take all the 2gb ?

Acc to BOL :
Target Server Memory (KB) is Total amount of dynamic memory the server can consume.
Total Server Memory (KB) is Total amount of dynamic memory (in kilobytes) that the server is using currently.


Thanks
Tomi

 

[Catadmin]

Look at the Server properties and see if the memory is set to that specifically or if it is set to use memory dynamically. Also, SQL Server 2000 and above apparently reserves some memory for Full Text Indexing, so this could also be your problem.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Tomi]

The max. memory is not set.It is set to use dynamically

Thanks
Tomi

 

[ptheriault]

SQL Server 2000 STD edition will only use 1.7 gig max. It will reserve 300MB for full text.

- Paul
- Database performance looks fine, it must be the Network!

 

[ptheriault]

This might help.

http://www.sql-server-performance.com/awe_memory.asp

- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

AWE isn't involved if less than 2 Gigs of memory are being used by SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com