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