Re: MSSQL 2000 Standard Edition not utilizing Maximum Memory!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Amol Kasbekar (apk_at_nospam.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 09:54:19 -0400

Verify if your application is I/O bound or Memory Bound ??
If your cpu utilization is fixed at 100%, then you should worry about
Memory.

Most of the performance problems in databases usually come from locks,
blocking, lot of IO read/writes, etc.
Check http://www.sql-server-performance.com/ for various ways to measure SQL
Server Performance.

Amol.

"vasum" <anonymous@discussions.microsoft.com> wrote in message
news:E2239F3D-53B5-4DA7-B7AC-280DC8B54ED7@microsoft.com...
> 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: T1000 vs. T2000
    ... And that's what bothers me (and memory throutput is one of the ... If your application can extract all bandwidth of T2000, ... However, if your app is I/O bound on T1000, ...
    (comp.unix.solaris)
  • RE: CPU Utilization - Xbox 360 Extender Vista Media Center
    ... motherboard in order for the memory to run at the "double-data rate". ... But, when I playback HDTV on the Xbox, CPU utilization is not low and smooth ... while also recording, the high CPU utilization causes choppy recordings. ... Disabled auto defrag settings so that it does not automatcially ...
    (microsoft.public.windows.mediacenter)
  • Re: CPU Utilization - Xbox 360 Extender Vista Media Center
    ... This system runs on DDR memory which are in pairs. ... anywhere from 0 to 70% CPU utilization. ... while also recording, the high CPU utilization causes choppy recordings. ... Disabled auto defrag settings so that it does not automatcially ...
    (microsoft.public.windows.mediacenter)
  • Re: CPU Utilization - Xbox 360 Extender Vista Media Center
    ... It's ok if the memory is different as long as installed in pairs. ... I think you need to install the modules in equal pairs on the ... anywhere from 0 to 70% CPU utilization. ... while also recording, the high CPU utilization causes choppy recordings. ...
    (microsoft.public.windows.mediacenter)
  • Re: ADO and Cursors with MSSQL
    ... "Schlup Herbert" wrote in message ... the memory used by MSSQL is not so heavy increasing as ... repeatedly issue the same parameterized statement, the cached statement, ...
    (borland.public.delphi.database.ado)