I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032BOOT.INI is a hidden system file in C:\. Add the /PAE switch and reboot.
You need to run:
sp_configure 'aew', 1
reconfigure
... and restart SQL Server.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1181256247.731355.184430@.p47g2000hsd.googlegroups.com...
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032|||Go to the Windows Explorer menu, Tools | Folder Options ..., and the View
tab, then uncheck Hide Protected operating system files. You'll then see
boot.ini in the system root directory (typically C:\).
Linchi
"bmwbase-newsgroup@.yahoo.com" wrote:
> I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
> Enterprise Edition SP4) which has 16Gb memory.
> I'm not 100% sure the server has been correctly configured to use the
> memory up to 12Gb as defined in the SQL Server properties.
> Based on the KB article at http://support.microsoft.com/kb/274750 I
> have two questions:
> Firstly, I cannot find the file boot.ini to include the /PAE switch.
> Where is this file supposed to be located? Do I need to create a new
> one?
> Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
> sample output below from sp_confiure:
> name minimum maximum
> config_value run_value
> -- -- --
> -- --
> show advanced options 0 1
> 1 1
> awe enabled 0 1
> 0 0
> max server memory (MB) 4 2147483647
> 12032 12032
>
Showing posts with label pae. Show all posts
Showing posts with label pae. Show all posts
Monday, March 12, 2012
Memory Usage - PAE / AWE question
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032
BOOT.INI is a hidden system file in C:\. Add the /PAE switch and reboot.
You need to run:
sp_configure 'aew', 1
reconfigure
... and restart SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1181256247.731355.184430@.p47g2000hsd.googlegr oups.com...
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032
|||Go to the Windows Explorer menu, Tools | Folder Options ..., and the View
tab, then uncheck Hide Protected operating system files. You'll then see
boot.ini in the system root directory (typically C:\).
Linchi
"bmwbase-newsgroup@.yahoo.com" wrote:
> I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
> Enterprise Edition SP4) which has 16Gb memory.
> I'm not 100% sure the server has been correctly configured to use the
> memory up to 12Gb as defined in the SQL Server properties.
> Based on the KB article at http://support.microsoft.com/kb/274750 I
> have two questions:
> Firstly, I cannot find the file boot.ini to include the /PAE switch.
> Where is this file supposed to be located? Do I need to create a new
> one?
> Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
> sample output below from sp_confiure:
> name minimum maximum
> config_value run_value
> -- -- --
> -- --
> show advanced options 0 1
> 1 1
> awe enabled 0 1
> 0 0
> max server memory (MB) 4 2147483647
> 12032 12032
>
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032
BOOT.INI is a hidden system file in C:\. Add the /PAE switch and reboot.
You need to run:
sp_configure 'aew', 1
reconfigure
... and restart SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1181256247.731355.184430@.p47g2000hsd.googlegr oups.com...
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032
|||Go to the Windows Explorer menu, Tools | Folder Options ..., and the View
tab, then uncheck Hide Protected operating system files. You'll then see
boot.ini in the system root directory (typically C:\).
Linchi
"bmwbase-newsgroup@.yahoo.com" wrote:
> I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
> Enterprise Edition SP4) which has 16Gb memory.
> I'm not 100% sure the server has been correctly configured to use the
> memory up to 12Gb as defined in the SQL Server properties.
> Based on the KB article at http://support.microsoft.com/kb/274750 I
> have two questions:
> Firstly, I cannot find the file boot.ini to include the /PAE switch.
> Where is this file supposed to be located? Do I need to create a new
> one?
> Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
> sample output below from sp_confiure:
> name minimum maximum
> config_value run_value
> -- -- --
> -- --
> show advanced options 0 1
> 1 1
> awe enabled 0 1
> 0 0
> max server memory (MB) 4 2147483647
> 12032 12032
>
Memory Usage - PAE / AWE question
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032BOOT.INI is a hidden system file in C:\. Add the /PAE switch and reboot.
You need to run:
sp_configure 'aew', 1
reconfigure
... and restart SQL Server.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1181256247.731355.184430@.p47g2000hsd.googlegroups.com...
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032|||Go to the Windows Explorer menu, Tools | Folder Options ..., and the View
tab, then uncheck Hide Protected operating system files. You'll then see
boot.ini in the system root directory (typically C:\).
Linchi
"bmwbase-newsgroup@.yahoo.com" wrote:
> I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
> Enterprise Edition SP4) which has 16Gb memory.
> I'm not 100% sure the server has been correctly configured to use the
> memory up to 12Gb as defined in the SQL Server properties.
> Based on the KB article at http://support.microsoft.com/kb/274750 I
> have two questions:
> Firstly, I cannot find the file boot.ini to include the /PAE switch.
> Where is this file supposed to be located? Do I need to create a new
> one?
> Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
> sample output below from sp_confiure:
> name minimum maximum
> config_value run_value
> -- -- --
> -- --
> show advanced options 0 1
> 1 1
> awe enabled 0 1
> 0 0
> max server memory (MB) 4 2147483647
> 12032 12032
>
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032BOOT.INI is a hidden system file in C:\. Add the /PAE switch and reboot.
You need to run:
sp_configure 'aew', 1
reconfigure
... and restart SQL Server.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<bmwbase-newsgroup@.yahoo.com> wrote in message
news:1181256247.731355.184430@.p47g2000hsd.googlegroups.com...
I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
Enterprise Edition SP4) which has 16Gb memory.
I'm not 100% sure the server has been correctly configured to use the
memory up to 12Gb as defined in the SQL Server properties.
Based on the KB article at http://support.microsoft.com/kb/274750 I
have two questions:
Firstly, I cannot find the file boot.ini to include the /PAE switch.
Where is this file supposed to be located? Do I need to create a new
one?
Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
sample output below from sp_confiure:
name minimum maximum
config_value run_value
-- -- --
-- --
show advanced options 0 1
1 1
awe enabled 0 1
0 0
max server memory (MB) 4 2147483647
12032 12032|||Go to the Windows Explorer menu, Tools | Folder Options ..., and the View
tab, then uncheck Hide Protected operating system files. You'll then see
boot.ini in the system root directory (typically C:\).
Linchi
"bmwbase-newsgroup@.yahoo.com" wrote:
> I'm working on a server (Windows Server 2003 R2 SP1 - SQL Server
> Enterprise Edition SP4) which has 16Gb memory.
> I'm not 100% sure the server has been correctly configured to use the
> memory up to 12Gb as defined in the SQL Server properties.
> Based on the KB article at http://support.microsoft.com/kb/274750 I
> have two questions:
> Firstly, I cannot find the file boot.ini to include the /PAE switch.
> Where is this file supposed to be located? Do I need to create a new
> one?
> Secondly, if I output the sp_configure 'awe enabled', it is set to 0.
> sample output below from sp_confiure:
> name minimum maximum
> config_value run_value
> -- -- --
> -- --
> show advanced options 0 1
> 1 1
> awe enabled 0 1
> 0 0
> max server memory (MB) 4 2147483647
> 12032 12032
>
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)