I have SQL Server 2000 Standard Edition Build 8.00818(SP3) Running on Windows 2003 Standard Edition SP2. I run Perfmon on this server getting the following counter:
SQLServer:Memory Manager\Target Server Memory(KB)
SQLServer:Memory Manager\Total Server Memory (KB)
The value gathered for these two counters always equal, around ~1,679,000KB
The server has 4GB RAM.
I check the Maximum memory allocation in EM and it set to 4095MB with zero minimum,
When I check thru QA, sp_configure, the value is as follow:
min server memory (MB) 0 2147483647 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
set working set size 0 1 0 0
It just show that thru EM, the value is different from value from QA. Is this the cause why the two counters above always have the same value?
I know the standard edition of SQL 2000 only utilized 2GB so I am assuming the memory usage of the server always > 50% because of other memory usage such as OS's. Is this the correct thinking?