September 14, 2005 at 6:52 am
We are running 'Sql 2000 Standard Edition sp3' on a 4gig 'Windows 2003 Standard Edition' server. The /3GB switch does not seem be be valid. Is that true or is there some other sql switch/setting required to get sql up to 3 gig in use? When this does work can the extra memory usage be seen in Task Manager or Perf Manager ? What products are required to use the extra memory ?
thanks
Tim Logan
September 14, 2005 at 8:11 am
sql 2000 standard edition can only support 2GB mem. You need to use enterprse edtion to use more than 2GB of ram.
Though windows 2003 SE support /3GB, it's not officially supported.
September 14, 2005 at 8:17 am
Here is the original MS link: http://support.microsoft.com/kb/291988
Caution Microsoft supports using the /3GB switch in Windows Server 2003, Standard Edition in a production environment for use by Active Directory. For other applications, Microsoft supports using the /3GB switch in Windows Server 2003, Standard Edition only in a production environment if the application vendor has tested in this environment and if the vendor is willing to support the customer who is using this functionality. Microsoft Exchange Server 2003 and Microsoft SQL Server 2000 are supported in production using this functionality. Contact your application vendor regarding their application. The /3GB switch can cause some applications to have problems that are related to address dependencies or to a reduction in kernel space. Except in the cases described here, the /3GB switch in Windows Server 2003, Standard Edition is only for development and testing purposes.
SQL server 2000 is in the support list.
September 15, 2005 at 2:14 am
We've just enabled the /3G setting on our system here and it's made quite a difference. As long as your system is solely a SQL box and isn't used for anything else then the /3G switch makes quite a bit of difference to performance.
September 15, 2005 at 6:43 am
SQL Standard edition only supports 2GB of RAM regardless of any switch you use in the OS.
Full stop - no exceptions
Hence you saw no difference.
You need SQL Enterprise to use more than 2GB.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply