We have a Windows 2000 Server/MSSQL 2000 machine that was recently upgrade to 3gb of memory. I made an adjustment in the memory properties for SQL Server.
SQL LOG states:
Configuration option 'max server memory (MB)' changed from 2147483647 to 2024. Run the RECONFIGURE statement to install.
It was previously at the max.
I ran the statement RECONFIGURE - I also ran sp_configure. Should the sp_configure results reflect this adjusment? I also stopped and started the Server and the sp_config results appear the same. Is there an additional step to verify this adjustment?
SQL LOG states:
Configuration option 'max server memory (MB)' changed from 2147483647 to 2024. Run the RECONFIGURE statement to install.
It was previously at the max.
I ran the statement RECONFIGURE - I also ran sp_configure. Should the sp_configure results reflect this adjusment? I also stopped and started the Server and the sp_config results appear the same. Is there an additional step to verify this adjustment?