Printable View
I have SQL 7 Enterprise and NT 4.0 Enterprise running on a server with 4 Gig of RAM. Is there anything special I have to do for SQL to access all the memory? My NT administrators tell me that it will only access up to 3 Gig if I add a /3G switch to the end of the boot.ini file. Any suggestions?
You have to right click on the server name in Enterprise Manager then change the Memory settings on the Memory tab.
You probably only want SQL to use no more than 3GB due to OS and any other programs running on the box.
------------
Jeff at 8/31/01 5:30:34 PM
I have SQL 7 Enterprise and NT 4.0 Enterprise running on a server with 4 Gig of RAM. Is there anything special I have to do for SQL to access all the memory? My NT administrators tell me that it will only access up to 3 Gig if I add a /3G switch to the end of the boot.ini file. Any suggestions?