SQL Server 2000 memory usage
Posted on 2006-11-07
windows 2003 server standard
ms sql2000 standard
i have read that sql 2000 can only access 2GB of memory and also that 2003 server std can only access 4GB,
is there any way to increae this?
is this per sql instance? ie if i have 2 instances can i now access 4GB, 2GB per instance?
currently have 1 instnace with 3 databases of varying sizes. i have 3.5GB of memory and yet still using a 2.5GB paging file.
i have done the usual of seperating the logs onto another disk etc to try to gain speed however still a very large number of page faults all on disks.
any ideas warmly accepted