We have heard that SQL standard can take over 2 gigs of memory. We are currently running SQL 2000 Standard on Windows 2000 Advanced Server with 4 gigs physical memory. When we go into the SQL server properties, we can set the max limit to 3.8 gigs for SQL to take. Now, SQL server only takes 1.7gigs. We do not have the /3gig setting in the boot.ini and do not have AWE enabled (can't since its standard) Why can we set that max memory in SQL server properties higher than 2gigs? If anyone has any kbase articles that would be great.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
