Memory management

Hi,
I have a MS Sql server 7.0 running on Windows 2000 advanced server with 6GB
ram. The boot.ini contains the /3gb /pae options. The OS sees all of the
ram. But the sql server memory management tab shows false values (16MB and
0 values), and the sliders are disabled. Why is it? How can I check memory
usage for the sql server?
Thank you,
Chris
--
Message posted via http://www.sqlmonster.comHi
Run sp_configure 'max server memory' to see what is configured.
If you use SQL Server Standard Edition, all what it can use is 2GB as that
is an Edition limitation.
SQL Server Enterprise edition, IIRC is 8GB.
Regards
Mike
"Mary Poppins via SQLMonster.com" wrote:
> Hi,
> I have a MS Sql server 7.0 running on Windows 2000 advanced server with 6GB
> ram. The boot.ini contains the /3gb /pae options. The OS sees all of the
> ram. But the sql server memory management tab shows false values (16MB and
> 0 values), and the sliders are disabled. Why is it? How can I check memory
> usage for the sql server?
> Thank you,
> Chris
> --
> Message posted via http://www.sqlmonster.com
>|||Do you have AWE enabled? If so then sql server does not dynamically manage
memory. It will grab all of what if there unless you set the max memory
setting to something less than the total available. In your case I recommend
around 5GB. You can use the Sql Memory counters in perfmon to see how much
it is actually using. Total memory and Target memory should be the same and
what ever you set your max memory setting to. Make sure you don't have the
Use Fixed Amount checked as that will disable the sliders.
--
Andrew J. Kelly SQL MVP
"Mary Poppins via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:6ea9fff4366143f8b44320e5b0092e94@.SQLMonster.com...
> Hi,
> I have a MS Sql server 7.0 running on Windows 2000 advanced server with
> 6GB
> ram. The boot.ini contains the /3gb /pae options. The OS sees all of the
> ram. But the sql server memory management tab shows false values (16MB and
> 0 values), and the sliders are disabled. Why is it? How can I check memory
> usage for the sql server?
> Thank you,
> Chris
> --
> Message posted via http://www.sqlmonster.com|||AWE not enabled . (The extended memory option in SQL Server 7.0 is not
available on Windows 2000 Advanced Server). Sp_configure shows that the
min, max and the run server memories are 2147483647. In the server
properties memory tab the "Use fixed memory size" are checked, and I can
not change it, and it shows only min 16MB and max 0MB. However the in the
performance monitor the Target server memory shows 2082896KB, and the Total
server memory 144150 KB.
Can I ignore the memory panel, or could you advise something to correct the
wrong values?
Thank you,
Chris
--
Message posted via http://www.sqlmonster.com|||Ignore the memory panel. The important thing is the sp_configure setting. The memory dialog is
probably just some kind of UI bug.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mary Poppins via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0b5fc3940c614ef79498116929c69874@.SQLMonster.com...
> AWE not enabled . (The extended memory option in SQL Server 7.0 is not
> available on Windows 2000 Advanced Server). Sp_configure shows that the
> min, max and the run server memories are 2147483647. In the server
> properties memory tab the "Use fixed memory size" are checked, and I can
> not change it, and it shows only min 16MB and max 0MB. However the in the
> performance monitor the Target server memory shows 2082896KB, and the Total
> server memory 144150 KB.
> Can I ignore the memory panel, or could you advise something to correct the
> wrong values?
> Thank you,
> Chris
> --
> Message posted via http://www.sqlmonster.com|||OK. Thank you.
Bye
--
Message posted via http://www.sqlmonster.com