Very Computer

 Arno - standard edition can only use 2GB.  EE can use 3GB if you use the /3GB
switch in the NT boot.ini

 > We have a SQL server 7 (Standard Edition) runnning on Windows 2000 server

Quote:> (Standard) on a Dell server with 4 GB of physical RAM. We are running a number of
> big databases (a few GB's each) on the server. The problem is that only about 2
> GB of the 4 GB of physical RAM is being used by SQL, although it is set to grow
> dynamically up to 3 GB. DOes anybody have an idea what we can try to make full
> use of the physical RAM?

> thank you
> Arno

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

We have a SQL server 7 (Standard Edition) runnning on Windows 2000 server
(Standard) on a Dell server with 4 GB of physical RAM. We are running a number of
big databases (a few GB's each) on the server. The problem is that only about 2
GB of the 4 GB of physical RAM is being used by SQL, although it is set to grow
dynamically up to 3 GB. DOes anybody have an idea what we can try to make full
use of the physical RAM?

thank you
Arno

Arno,

Quote:> DOes anybody have an idea what we can try to make full use of the physical

RAM?

buy Enterprise edition. Standard is limited to 2GB (7.0 and 2000). SQL 2000
Enterprise can use up to 64GB on a Win2k Datacenter.

HTH,
Dejan Sarka