all groups > sql server clustering > october 2003 >
You're in the

sql server clustering

group:

About memory usage


About memory usage Jenny
10/30/2003 1:58:54 PM
sql server clustering:
Hi All,

We have active/active Cluster setting on Microsoft Windows
2003 DataCenter Server. Installed SQL Server 2000 with
SP3, used AWE to configured max server memory to 3072(MB)
and the 3 GB switch in the Boot.ini file.

From SQL Server Properties, it selected Use a fixed memory
size and Configured values but didn't select Reserve
physical memory for SQL Server.

If I do the query use command sp_configure, it showed min
and max server memory config_value 3072(MB) and run_value
3072(MB).

The problem is that we didn't see memory usage even up to
2 GB per SQL Server during peak-hour in Windows Task
Manager.

My questions are:
1) The configuration is right?
2) Do we need select Reserve physical memory for SQL
Server to force use more than 2GB memory?

Any ideas would be highly appreciated.

Thanks!
Jenny
About memory usage Allan Hirt
11/9/2003 4:28:56 PM
You have Datacenter with only 3 GB? To use AWE you must
have /PAE set in boot.ini as well. While you can turn on
AWE under 32-bit in SQL Server, to really use it, you must
have /PAE set to expand beyond the 3GB that the /3GB
switch limits you to. But in SQL Server, if you use AWE
with PAE, you must give it a fixed amount of memory and it
is not dynamic.

So my question is more of one of how are you looking to
utilize SQL Server?

[quoted text, click to view]
AddThis Social Bookmark Button