I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linea
r
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. S
ee
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
Showing posts with label awe. Show all posts
Showing posts with label awe. Show all posts
Monday, March 19, 2012
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
Saturday, February 11, 2012
(Target Server Memory)Perf. Monitor Counters
Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
..
What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>
|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to
>
>.
>
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
..
What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>
|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to
>
>.
>
(Target Server Memory)Perf. Monitor Counters
Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
>
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
>
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
>
> How can I fix the memory problem.
>
> Thanks,
>
> Mike
>
.What is the Total Server Memory counter value?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> >
> > Why does'nt my Target Server Memory value (2.7 GB) within
> > Memory Manager in the Performance Monitor Counters match
> > the values in SQL Server Memory Maximum Value (5.2 GB)
> >
> > My Target Server Memory displays a value of 2.7 GB and
> the
> > SQL Memory Maximum displays 5.2 GB.
> >
> > The boot.ini is set with the following parameters:
> > [boot loader]
> > timeout=10
> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> > [operating systems]
> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> >
> > The server initially had 6GB of RAM and 2GB were added to
> > the server. SQL Server displays 5.2 GB is the maximum
> alot
> > memory and Dynamically configure SQL Server memory.
> >
> > How can I fix the memory problem.
> >
> > Thanks,
> >
> > Mike
> >
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
>> Yes, we have AWE set to 1 and max server memory set to
>> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
>> with Windows 2000 Advanced Server. SQL Server is
>> clustered also. After the 2GB of RAM (6GB + 2GB) was
>> added to the server the script listed below was applied
to
>> the server.
>> We have three other servers that have the same
>> configuration and SQL Server Memory Manager (Target
Server
>> Memory) is set correctly at 5.12GB. But when you run
>> Performance Monitor and display SQL Server Memory
Manager
>> (Target Server Memory) it is set to 2.7GB
>> I replied the script listed below but it did not change
>> the SQL Server Memory Manager (Target Server Memory)
value.
>> Please help me with this problem.
>> Thanks,
>> Mike
>>
>> sp_configure "show advanced options", 1
>> RECONFIGURE
>> GO
>> sp_configure "awe enabled", 1
>> RECONFIGURE
>> GO
>> sp_configure "max server memory", 5120
>> RECONFIGURE
>> GO
>> sp_configure "min server memory", 0
>> RECONFIGURE
>> GO
>>
>>
>> Do you have AWE enabled in SQL?
>> Are you running Enterprise Edition SQL?
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>> "Mike" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>> >
>> > Why does'nt my Target Server Memory value (2.7 GB)
within
>> > Memory Manager in the Performance Monitor Counters
match
>> > the values in SQL Server Memory Maximum Value (5.2 GB)
>> >
>> > My Target Server Memory displays a value of 2.7 GB and
>> the
>> > SQL Memory Maximum displays 5.2 GB.
>> >
>> > The boot.ini is set with the following parameters:
>> > [boot loader]
>> > timeout=10
>> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
>> > [operating systems]
>> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
>> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>> >
>> > The server initially had 6GB of RAM and 2GB were
added to
>> > the server. SQL Server displays 5.2 GB is the maximum
>> alot
>> > memory and Dynamically configure SQL Server memory.
>> >
>> > How can I fix the memory problem.
>> >
>> > Thanks,
>> >
>> > Mike
>> >
>>
>> .
>>
>
>.
>
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
>
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
>
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
>
> How can I fix the memory problem.
>
> Thanks,
>
> Mike
>
.What is the Total Server Memory counter value?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> >
> > Why does'nt my Target Server Memory value (2.7 GB) within
> > Memory Manager in the Performance Monitor Counters match
> > the values in SQL Server Memory Maximum Value (5.2 GB)
> >
> > My Target Server Memory displays a value of 2.7 GB and
> the
> > SQL Memory Maximum displays 5.2 GB.
> >
> > The boot.ini is set with the following parameters:
> > [boot loader]
> > timeout=10
> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
> > [operating systems]
> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> >
> > The server initially had 6GB of RAM and 2GB were added to
> > the server. SQL Server displays 5.2 GB is the maximum
> alot
> > memory and Dynamically configure SQL Server memory.
> >
> > How can I fix the memory problem.
> >
> > Thanks,
> >
> > Mike
> >
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
>> Yes, we have AWE set to 1 and max server memory set to
>> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
>> with Windows 2000 Advanced Server. SQL Server is
>> clustered also. After the 2GB of RAM (6GB + 2GB) was
>> added to the server the script listed below was applied
to
>> the server.
>> We have three other servers that have the same
>> configuration and SQL Server Memory Manager (Target
Server
>> Memory) is set correctly at 5.12GB. But when you run
>> Performance Monitor and display SQL Server Memory
Manager
>> (Target Server Memory) it is set to 2.7GB
>> I replied the script listed below but it did not change
>> the SQL Server Memory Manager (Target Server Memory)
value.
>> Please help me with this problem.
>> Thanks,
>> Mike
>>
>> sp_configure "show advanced options", 1
>> RECONFIGURE
>> GO
>> sp_configure "awe enabled", 1
>> RECONFIGURE
>> GO
>> sp_configure "max server memory", 5120
>> RECONFIGURE
>> GO
>> sp_configure "min server memory", 0
>> RECONFIGURE
>> GO
>>
>>
>> Do you have AWE enabled in SQL?
>> Are you running Enterprise Edition SQL?
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>> "Mike" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
>> >
>> > Why does'nt my Target Server Memory value (2.7 GB)
within
>> > Memory Manager in the Performance Monitor Counters
match
>> > the values in SQL Server Memory Maximum Value (5.2 GB)
>> >
>> > My Target Server Memory displays a value of 2.7 GB and
>> the
>> > SQL Memory Maximum displays 5.2 GB.
>> >
>> > The boot.ini is set with the following parameters:
>> > [boot loader]
>> > timeout=10
>> > default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
>> > [operating systems]
>> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft
>> > Windows 2000 Advanced Server" /fastdetect /3gb /PAE
>> >
>> > The server initially had 6GB of RAM and 2GB were
added to
>> > the server. SQL Server displays 5.2 GB is the maximum
>> alot
>> > memory and Dynamically configure SQL Server memory.
>> >
>> > How can I fix the memory problem.
>> >
>> > Thanks,
>> >
>> > Mike
>> >
>>
>> .
>>
>
>.
>
(Target Server Memory)Perf. Monitor Counters
Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
.What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to[vbcol=seagreen]
>
>.
>
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
.What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike
>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to[vbcol=seagreen]
>
>.
>
Subscribe to:
Posts (Atom)