My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of RAM
and there is only 16GB in the server.
I have the max memory for SQL server set at 12582912 (12GB) but the process
is running at 15,388,052 ignoring the maximum settings.
Thus the server is swapping memory to disk.
How can i make sure the SQL server is limited in its memory usgage if it is
ignoring the setting.
Regards
TobyDid you change the setting after the server was already running? Decreasing
memory won't necessarily release reserved mem without a reboot.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"TobiR" <TobiR@.discussions.microsoft.com> wrote in message
news:147CE1A0-1D90-431F-960A-E44BF36B695F@.microsoft.com...
> My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of
> RAM
> and there is only 16GB in the server.
> I have the max memory for SQL server set at 12582912 (12GB) but the
> process
> is running at 15,388,052 ignoring the maximum settings.
> Thus the server is swapping memory to disk.
> How can i make sure the SQL server is limited in its memory usgage if it
> is
> ignoring the setting.
> Regards
> Toby
>|||Also note that max memory setting applies to the buffer pool only. The SQL
Server process consumes more memory than just its buffer pool, although the
buffer pool is often the largest, or at least should be, memory consumer.
Linchi
"TobiR" wrote:
> My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of RAM
> and there is only 16GB in the server.
> I have the max memory for SQL server set at 12582912 (12GB) but the process
> is running at 15,388,052 ignoring the maximum settings.
> Thus the server is swapping memory to disk.
> How can i make sure the SQL server is limited in its memory usgage if it is
> ignoring the setting.
> Regards
> Toby
>|||On Jan 23, 2:12 am, TobiR <To...@.discussions.microsoft.com> wrote:
> My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of RAM
> and there is only 16GB in the server.
> I have the max memory for SQL server set at 12582912 (12GB) but the process
> is running at 15,388,052 ignoring the maximum settings.
> Thus the server is swapping memory to disk.
> How can i make sure the SQL server is limited in its memory usgage if it is
> ignoring the setting.
> Regards
> Toby
12GB is 12288MB (which is what the max memory setting is in). Where
are you seeing max memory set to 12582912?|||Thanks for spotting my math issues! I had it set to 12TB instead of 12GB,
noticed it the other day, no wonder it was using eything it could get.
Thanks
Toby
"Jeffrey Williams" wrote:
> On Jan 23, 2:12 am, TobiR <To...@.discussions.microsoft.com> wrote:
> > My SQL Server Ent 2005 64Bit Active / Passive Cluster is using 16.3GB of RAM
> > and there is only 16GB in the server.
> >
> > I have the max memory for SQL server set at 12582912 (12GB) but the process
> > is running at 15,388,052 ignoring the maximum settings.
> >
> > Thus the server is swapping memory to disk.
> >
> > How can i make sure the SQL server is limited in its memory usgage if it is
> > ignoring the setting.
> >
> > Regards
> >
> > Toby
> 12GB is 12288MB (which is what the max memory setting is in). Where
> are you seeing max memory set to 12582912?
>
Showing posts with label 16gb. Show all posts
Showing posts with label 16gb. Show all posts
Monday, March 19, 2012
Memory Usage on 64bit Cluster
My SQL Server Ent 2006 64Bit Active / Passive Cluster is using 16.3GB of RAM
and there is only 16GB in the server.
I have the max memory for SQL server set at 12582912 (12GB) but the process
is running at 15,388,052 ignoring the maximum settings.
Thus the server is swapping memory to disk.
How can i make sure the SQL server is limited in its memory usgage if it is
ignoring the setting.
Regards
TobySorry SQL 2005 (typeo)
"TobiR" wrote:
> My SQL Server Ent 2006 64Bit Active / Passive Cluster is using 16.3GB of RAM
> and there is only 16GB in the server.
> I have the max memory for SQL server set at 12582912 (12GB) but the process
> is running at 15,388,052 ignoring the maximum settings.
> Thus the server is swapping memory to disk.
> How can i make sure the SQL server is limited in its memory usgage if it is
> ignoring the setting.
> Regards
> Toby
>
and there is only 16GB in the server.
I have the max memory for SQL server set at 12582912 (12GB) but the process
is running at 15,388,052 ignoring the maximum settings.
Thus the server is swapping memory to disk.
How can i make sure the SQL server is limited in its memory usgage if it is
ignoring the setting.
Regards
TobySorry SQL 2005 (typeo)
"TobiR" wrote:
> My SQL Server Ent 2006 64Bit Active / Passive Cluster is using 16.3GB of RAM
> and there is only 16GB in the server.
> I have the max memory for SQL server set at 12582912 (12GB) but the process
> is running at 15,388,052 ignoring the maximum settings.
> Thus the server is swapping memory to disk.
> How can i make sure the SQL server is limited in its memory usgage if it is
> ignoring the setting.
> Regards
> Toby
>
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 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
>
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
>
Subscribe to:
Posts (Atom)