Hi, I have a server with 16GB of RAM and SQL has been configure to use 12GB but it only uses 8GB and I need it to use the 12 GB.

This the server configuration:

SQL 2000 Enterprise Edition with SP4 (8.00.2039)

Use fixed memory size:  12970 MB

Windows 2003 Enterprise Edition with SP2

Thanks, Carlos.

HI Carlos,

How did you determine that SQL Server i using 8GB of memory? The SQL Server bufferpool (which is where most of the committed memory will end up) typically increases in size gradaully from when you start the server. It is not going to grab those 12 GB on startup. Maybe it just hasn't had the need to commit the last 4 GB - the SQL Server Memory Manager: Total Server Memory performance counter will show you the amount of memory currently committed in the buffer pool.

However, can you send the output from:

SELECT @@version

go 

sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'min server'
go
sp_configure 'max server'
go
sp_configure 'awe'
go
sp_configure 'show advanced',0
reconfigure with override

/Elisabeth

 Hi Elizabeth, this is the output:

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
    May  3 2005 23:18:38
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
name                                minimum     maximum     config_value run_value  
-----------------------------------     -----------       -----------         ------------      -----------
min server memory (MB)     0                2147483647  12970        12970

name                                minimum     maximum     config_value run_value  
-----------------------------------     -----------       -----------         ------------      -----------
max server memory (MB)              4      2147483647  12970      12970

name                                minimum     maximum     config_value run_value  
-----------------------------------     -----------       -----------         ------------      -----------
awe enabled                         0             1                  1                 1

I have Idera's DiagnosticManager and for the other 14 server that I have there to be monitoring, we have the same value for Memory that the configuration. This is a very good tool where I can see how many MB has Procedure Cache, Lock Memory, Free Data Cache, Pinned Tables, Connection Memory, "Sort, Hash, Index Creation", Used Data Cache and Optimizer Cache.

Thanks.

Hi,

 Your configuration looks OK so I think everything is OK but where is that you see the 8GB?

/Elisabeth