We have combined application & database servers (SQL Server) running W2k advanced server.
They have 4GB of RAM, and don't have either of the above switches in the boot.ini file.
We are rather confused in general about how windows utilises memory, and in paticular what impact the above switches have.
Our SQL Server process is capped to only use 1GB of memory, and other applications tend to use about another 1GB combined.
Does windows 2000 advanced by default allow more than 2GB of physical memory to be assigned to application processes?
Thus if memory utilisation is above 2GB (of application processes), does this mean that hard paging will result.
Does anyone have any advice on how we should set these servers up with respect to memory?
Stats from one of our server from task manager:
Physical Memory:
Total 3669496
Available 1072344
System cache 1342476
Commit Charge:
Total 2413416
Limit 6649316
Peak 2599292
Thanks in advance
They have 4GB of RAM, and don't have either of the above switches in the boot.ini file.
We are rather confused in general about how windows utilises memory, and in paticular what impact the above switches have.
Our SQL Server process is capped to only use 1GB of memory, and other applications tend to use about another 1GB combined.
Does windows 2000 advanced by default allow more than 2GB of physical memory to be assigned to application processes?
Thus if memory utilisation is above 2GB (of application processes), does this mean that hard paging will result.
Does anyone have any advice on how we should set these servers up with respect to memory?
Stats from one of our server from task manager:
Physical Memory:
Total 3669496
Available 1072344
System cache 1342476
Commit Charge:
Total 2413416
Limit 6649316
Peak 2599292
Thanks in advance