SQL Server Agent reports only 2GB RAM detected...Server has 4GB Installed
Posted on 2006-07-06
Using MSSQL 2000 SP4.
Well, the title pretty much says it all.
In the SQLAGENT.OUT report, the line reads:
2006-07-06 13:59:57 - ?  4 processor(s) and 2048 MB RAM detected
I have 4GB of RAM installed in the server though. Within Properties, on the Memory tab of the SQL server, it is indicated there are 4095 MB...
I'd like to make all 4GB available to any process...