SQL2K Ent SP3a Win2k SP3
I've recently enabled awe memory on 2 of our servers.
Everything seems to be going OK, AWE memory counters
are active in performance monitor and the sql serror log
shows awe memory enabled on startup.
My question is, is the above information enough to know that
awe is working correctly? If not, what other things can be looked
at?
TIA.see
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274750#6
--
BR,
Mark Broadbent mcdba,mcse+i
_________________________
"Stressed" <k@.c.co.uk> wrote in message
news:%23oI0KZzVDHA.2164@.TK2MSFTNGP09.phx.gbl...
> SQL2K Ent SP3a Win2k SP3
> I've recently enabled awe memory on 2 of our servers.
> Everything seems to be going OK, AWE memory counters
> are active in performance monitor and the sql serror log
> shows awe memory enabled on startup.
> My question is, is the above information enough to know that
> awe is working correctly? If not, what other things can be looked
> at?
> TIA.
>
>|||Also, when SQL Server starts you should see a line time in
the event log that says:
"Address Windowing Extensions enabled."
Ron
>--Original Message--
>see
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q274750#6
>--
>BR,
>Mark Broadbent mcdba,mcse+i
>_________________________
>"Stressed" <k@.c.co.uk> wrote in message
>news:%23oI0KZzVDHA.2164@.TK2MSFTNGP09.phx.gbl...
>> SQL2K Ent SP3a Win2k SP3
>> I've recently enabled awe memory on 2 of our servers.
>> Everything seems to be going OK, AWE memory counters
>> are active in performance monitor and the sql serror log
>> shows awe memory enabled on startup.
>> My question is, is the above information enough to know
that
>> awe is working correctly? If not, what other things can
be looked
>> at?
>> TIA.
>>
>>
>
>.
>
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Thursday, March 8, 2012
Wednesday, March 7, 2012
AWE MEM
Hi ,
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .'
Thanks
ARRHi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .'
Thanks
ARRHi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>
AWE MEM
Hi ,
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .?
Thanks
ARR
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
>
|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
>
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .?
Thanks
ARR
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
>
|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .?
> Thanks
> ARR
>
>
AWE MEM
Hi ,
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .'
Thanks
ARRHi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
--
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>
I have win2k server with 4 GB Ram
enabled /3gb switch to use all RAM
SQL SERVER 2K enterprise edition
enabled awe switch .
When started sql server it occupied only 2GB not all
is it correct .'
Thanks
ARRHi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>|||The /3GB switch will allow Sql server to use up to 3GB of the 4 but only if
you are running Win2K Adv Server or higher. If it is std server you can
only use 2GB for Sql Server. You should turn off AWE and leave the rest for
the OS and any other apps running.
--
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e1SBmT8HFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>|||If you are running only Win2K Standard Edition, /3GB option is not
supported. However, with 4 GB ram and SS2K EE, you should still be able to
use AWE, either 2 GB lower, up to 2 GB AWE, or 3 GB lower and up to 1 GB AWE
depending on the /3GB switch setting.
Also check out the SQL Server:Memory Manager, Target Server Memory. If this
value is not larger than Total Server Memory, the BPool does not know to
grow.
Finally, you have to RECONFIGURE and RESTART before the enable AWE takes
effect.
Sincerely,
Anthony Thomas
"Umut Nazlica" <UmutNazlica@.discussions.microsoft.com> wrote in message
news:F53E1E3D-F422-4187-9FCC-8067C6432E0D@.microsoft.com...
Hi,
I don't think you need to enable AWE, /3GB swith is enough for 4 GB Memory..
And from where you are monitoring SQL mem usage. Task Manager shows
incorrect values sometimes, use Performance Monitor- SQL Server:Memory
Manager:Total Server Memory instead..
"Aju" wrote:
> Hi ,
> I have win2k server with 4 GB Ram
> enabled /3gb switch to use all RAM
> SQL SERVER 2K enterprise edition
> enabled awe switch .
> When started sql server it occupied only 2GB not all
> is it correct .'
> Thanks
> ARR
>
>
Subscribe to:
Posts (Atom)