Hi
We are running full text search with 4GB RAM on SQL server 2000. Ihave the
/3G option on in boot.ini. The VM setting is set at 2048 to 4095.
I read it in the manual that the optimal configuration for full text search
is
1. The virtual memory size to at least 3 times the physical memory installed
in the computer.
2. The SQL Server max server memory server configuration option to 1.5 times
the physical memory (half the virtual memory size setting).
Questions:
1. How do I set max sql server memory to 1.5 times physical memory? Max
memory that SQL server allows us to set is 4095 MB? Is this only possible
with AWE?
2. My observation when I made the VM 3X the physical, was that the full text
queries were slower.
What are the right settings and what am I doing wrong?
Matt
Hi
Can any body throw some ideas on this one?
MM
"ISTS" wrote:
> Hi
> We are running full text search with 4GB RAM on SQL server 2000. Ihave the
> /3G option on in boot.ini. The VM setting is set at 2048 to 4095.
> I read it in the manual that the optimal configuration for full text search
> is
> 1. The virtual memory size to at least 3 times the physical memory installed
> in the computer.
> 2. The SQL Server max server memory server configuration option to 1.5 times
> the physical memory (half the virtual memory size setting).
> Questions:
> 1. How do I set max sql server memory to 1.5 times physical memory? Max
> memory that SQL server allows us to set is 4095 MB? Is this only possible
> with AWE?
> 2. My observation when I made the VM 3X the physical, was that the full text
> queries were slower.
> What are the right settings and what am I doing wrong?
> --
> Matt
Showing posts with label ini. Show all posts
Showing posts with label ini. Show all posts
Friday, February 24, 2012
Monday, February 20, 2012
Memory Management: SQL Enterprise, 2000 Adv. Srv.
Questions
A) If I have the /3GB /PAE variables in the Win 2k Server boot.ini and only have 2 gig of memory will this cause issues with memory readings I am seeing in Performance Monitor? (I know it doesn't make sense to have but happened out of circumstance
B) From what I am reading if "SQLServer: Memory Manager -- Target Server Memory (KB)" provides the same value as "SQLServer: Memory Manager -- Total Server Memory (KB)" then SQL is content and has as much memory as it needs. What I am seeing on my SQL server is that the two numbers match but are using all the memory on the server which is 2 GB. I assume that this means increase the amount of memory on the box. Am I correct in this assumption
C) Again from reading my understanding is that when using AWE (under 16 GB), SQL at startup will grab the specified chunk of RAM you have alotted to it. I was wondering if there are any counters within Performance Monitor that will tell me exactly how much of that RAM (AWE) SQL Server is using
Thanks...Anyone?
A) If I have the /3GB /PAE variables in the Win 2k Server boot.ini and only have 2 gig of memory will this cause issues with memory readings I am seeing in Performance Monitor? (I know it doesn't make sense to have but happened out of circumstance
B) From what I am reading if "SQLServer: Memory Manager -- Target Server Memory (KB)" provides the same value as "SQLServer: Memory Manager -- Total Server Memory (KB)" then SQL is content and has as much memory as it needs. What I am seeing on my SQL server is that the two numbers match but are using all the memory on the server which is 2 GB. I assume that this means increase the amount of memory on the box. Am I correct in this assumption
C) Again from reading my understanding is that when using AWE (under 16 GB), SQL at startup will grab the specified chunk of RAM you have alotted to it. I was wondering if there are any counters within Performance Monitor that will tell me exactly how much of that RAM (AWE) SQL Server is using
Thanks...Anyone?
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.com
Hi
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.c om...
> 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.c om...
> 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
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
Hi
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.c om...
> 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.c om...
> 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
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.droptable.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 droptable.com" wrote:
> Hi,
> I have a MS Sql server 7.0 running on Windows 2000 advanced server with 6G
B
> 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.droptable.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 droptable.com" <forum@.droptable.com> wrote in message
news:6ea9fff4366143f8b44320e5b0092e94@.SQ
droptable.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.droptable.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.droptable.com|||Ignore the memory panel. The important thing is the sp_configure setting. Th
e 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 droptable.com" <forum@.droptable.com> wrote in message
news:0b5fc3940c614ef79498116929c69874@.SQ
droptable.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 Tota
l
> server memory 144150 KB.
> Can I ignore the memory panel, or could you advise something to correct th
e
> wrong values?
> Thank you,
> Chris
> --
> Message posted via http://www.droptable.com|||OK. Thank you.
Bye
Message posted via http://www.droptable.com
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.droptable.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 droptable.com" wrote:
> Hi,
> I have a MS Sql server 7.0 running on Windows 2000 advanced server with 6G
B
> 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.droptable.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 droptable.com" <forum@.droptable.com> wrote in message
news:6ea9fff4366143f8b44320e5b0092e94@.SQ
droptable.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.droptable.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.droptable.com|||Ignore the memory panel. The important thing is the sp_configure setting. Th
e 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 droptable.com" <forum@.droptable.com> wrote in message
news:0b5fc3940c614ef79498116929c69874@.SQ
droptable.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 Tota
l
> server memory 144150 KB.
> Can I ignore the memory panel, or could you advise something to correct th
e
> wrong values?
> Thank you,
> Chris
> --
> Message posted via http://www.droptable.com|||OK. Thank you.
Bye
Message posted via http://www.droptable.com
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
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
Memory limit
Hi, my new server has 4.5 GB of RAM.
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
Memory limit
Hi, my new server has 4.5 GB of RAM.
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
Memory limit
Hi, my new server has 4.5 GB of RAM.
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.
Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
I'd like to configure SQL2k Enterprise to use 3.3 GB.
After adding /3gb and /pae at Boot.ini and setting max/min server memory to
3.3 GB, SQL still returs the
Warning: unable to allocate 'min server memory' of 3300 MB.
Any clue?
TIA,
Roberto de Souza Santos.
Additional configuration is needed - refer to BOL - managing AWE memory
"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
|||"Roberto Souza" <roberto_tbabh@.hotmail.com> wrote in message
news:OizvTSHBFHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi, my new server has 4.5 GB of RAM.
> I'd like to configure SQL2k Enterprise to use 3.3 GB.
What version of OS do you have?
> After adding /3gb and /pae at Boot.ini and setting max/min server memory
to
> 3.3 GB, SQL still returs the
> Warning: unable to allocate 'min server memory' of 3300 MB.
> Any clue?
> TIA,
> Roberto de Souza Santos.
>
Subscribe to:
Posts (Atom)