MSSQL 2000 Standard Edition not utilizing Maximum Memory!!!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: vasum (anonymous_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 04:01:05 -0700

Hi All,

Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows...

It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend .
OS: Win 2000 Advanced Server + 3GB Memory + 2 CPU

MSSQL Memory Configured as Dynamic with Maximum Memory has been set as "2 GB". This Server has Replication
Configuration also. During peak time or non-peak time, it always use 1 GB Memory only. Why MSSQL is not taking more than 1 GB, even though server has got 3 GB and database's max. memory configured as 2 GB.

In SQL 2000 Enterprise Edition, to utilize more than 2 GB for database, we will give /3GB in boot.ini. Similarly anything should be given for SQL 2000 Standard Edition. Right now, boot.ini doesn't contain this option.

Appreciate your help on this.

tks in advance,
vasum

Relevant Pages

  • Re: C++ in the kernel
    ... M68K based STB with only 1.5 MB or flash and 1.5MB of RAM and no disks. ... What we got for that one engineers effort was a development environment ... STL is surprisingly damn useful. ... STL chunking of memory needs to be looked at, ...
    (freebsd-arch)
  • Re: Cobol data protection? Get a dog...
    ... I use win32 APIs to LOCK the memory heaps? ... This problem is universal and is not restricted to a COBOL caller. ... The submodule needs an address to do damage. ... You use the phrase 'open environment' I will let you define that so folks can ...
    (comp.lang.cobol)
  • VMWare ESX and FBSD 7.2 AMD64 guest
    ... two processors, and 8GB of memory. ... running with the exact same environment. ... I'd appreciate any feedback on tweaks that I can make (either to VMWare, ... or FreeBSD itself) to make the virtualized environment much more efficient. ...
    (freebsd-questions)
  • Re: PPC Write to memory in Linux
    ... a user mode program is running in it own address space, it complicates ... programmers anywhere around and they won't deal with environment specific C ... adjust a C pointer value to access a specific memory address. ...
    (alt.lang.asm)
  • Re: Cool visual illusion
    ... > the environment which is important to a machine ... states (memory). ... product of our histories is a load of crock. ... It could be said that learning itself is a reward. ...
    (comp.ai.philosophy)