Autonumber field: bit

Showing posts with label bit. Show all posts

Thursday, March 8, 2012

AWE on Windows 64 Bit

Hi,
By having 6GB memory on Windows 2003 64 bit:
1) Do I have to add /PAE switch to boot.ini ?
2) What about AWE option for SQL Server, it must be enabled?
Thanks in advance,
LeilaIs SQL Server 64 bit? If so, you don't need any of those settings (AWE will be ignored if set).
However, you might benefit if service account has "lock pages in memory" privileges.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
> Hi,
> By having 6GB memory on Windows 2003 64 bit:
> 1) Do I have to add /PAE switch to boot.ini ?
> 2) What about AWE option for SQL Server, it must be enabled?
> Thanks in advance,
> Leila
>|||Thanks Tibor,
Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
Is /3GB switch still beneficial for SQL Server in 64 bit environment?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
> Is SQL Server 64 bit? If so, you don't need any of those settings (AWE
> will be ignored if set). However, you might benefit if service account has
> "lock pages in memory" privileges.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> By having 6GB memory on Windows 2003 64 bit:
>> 1) Do I have to add /PAE switch to boot.ini ?
>> 2) What about AWE option for SQL Server, it must be enabled?
>> Thanks in advance,
>> Leila
>>
>|||> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
No, such a switch is irrelevant in 64 bit.
> If it's 32 bit AWE is required?
Yes, if you want to utilize > 4GB memory. PAE is not needed, though Note, this applies to 32 bit SQL
Server in 64 bit OS (x64, architecture).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OlP9cnRhHHA.4132@.TK2MSFTNGP05.phx.gbl...
> Thanks Tibor,
> Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
>> Is SQL Server 64 bit? If so, you don't need any of those settings (AWE will be ignored if set).
>> However, you might benefit if service account has "lock pages in memory" privileges.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> By having 6GB memory on Windows 2003 64 bit:
>> 1) Do I have to add /PAE switch to boot.ini ?
>> 2) What about AWE option for SQL Server, it must be enabled?
>> Thanks in advance,
>> Leila
>>
>|||> No, such a switch is irrelevant in 64 bit.
Could you please explain it? AFAIK, 3GB switch forces OS to use only 1GB for
kernel mode. Therefore still it must be useable for 64 bit. Is it wrong?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OFpOezRhHHA.4444@.TK2MSFTNGP04.phx.gbl...
>> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
> No, such a switch is irrelevant in 64 bit.
>
>> If it's 32 bit AWE is required?
> Yes, if you want to utilize > 4GB memory. PAE is not needed, though Note,
> this applies to 32 bit SQL Server in 64 bit OS (x64, architecture).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OlP9cnRhHHA.4132@.TK2MSFTNGP05.phx.gbl...
>> Thanks Tibor,
>> Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
>> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
>> Is SQL Server 64 bit? If so, you don't need any of those settings (AWE
>> will be ignored if set). However, you might benefit if service account
>> has "lock pages in memory" privileges.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> By having 6GB memory on Windows 2003 64 bit:
>> 1) Do I have to add /PAE switch to boot.ini ?
>> 2) What about AWE option for SQL Server, it must be enabled?
>> Thanks in advance,
>> Leila
>>
>>
>|||32 bit has a limitation of only being able to directly address 4GB of
memory. Beyond that it requires PAE for the OS and AWE for the apps to use
the extra memory. By default 32 bit apps can only use 2 of that 4GB and the
OS uses 2GB. With 64 bit the directly addressable memory is way beyond what
the app or OS will use in the near future. As such there is no need for the
/3GB since any 64 bit app can address all it wants as can the OS.
--
Andrew J. Kelly SQL MVP
"Leila" <Leilas@.hotpop.com> wrote in message
news:uWXaG%23RhHHA.984@.TK2MSFTNGP04.phx.gbl...
>> No, such a switch is irrelevant in 64 bit.
> Could you please explain it? AFAIK, 3GB switch forces OS to use only 1GB
> for kernel mode. Therefore still it must be useable for 64 bit. Is it
> wrong?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:OFpOezRhHHA.4444@.TK2MSFTNGP04.phx.gbl...
>> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
>> No, such a switch is irrelevant in 64 bit.
>>
>> If it's 32 bit AWE is required?
>> Yes, if you want to utilize > 4GB memory. PAE is not needed, though Note,
>> this applies to 32 bit SQL Server in 64 bit OS (x64, architecture).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:OlP9cnRhHHA.4132@.TK2MSFTNGP05.phx.gbl...
>> Thanks Tibor,
>> Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
>> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
>> Is SQL Server 64 bit? If so, you don't need any of those settings (AWE
>> will be ignored if set). However, you might benefit if service account
>> has "lock pages in memory" privileges.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Leila" <Leilas@.hotpop.com> wrote in message
>> news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> By having 6GB memory on Windows 2003 64 bit:
>> 1) Do I have to add /PAE switch to boot.ini ?
>> 2) What about AWE option for SQL Server, it must be enabled?
>> Thanks in advance,
>> Leila
>>
>>
>>
>

AWE on Windows 64 Bit

AWE on SQL Server 2000 & 2005

I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
2000 Enterprose I would like to use AWE,
to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
I have windows2003 server 32 bit version, 16Gb ram on it, running inder SQL
2005 Enterprose I would like to use AWE,
to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
SQL serer DBAYou need the /PAE switch although Win2003 may automatically add it for you.
The /3GB can not be used with 16GB but can with 8GB. It is up to you if you
need the extra directly addressable memory or not. IN either case you will
also need to enable AWE in SQL Server.
Andrew J. Kelly SQL MVP
"Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
> 2000 Enterprose I would like to use AWE,
> to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> I have windows2003 server 32 bit version, 16Gb ram on it, running inder
> SQL
> 2005 Enterprose I would like to use AWE,
> to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> --
> SQL serer DBA|||And if you enable AWE in SQL Server without the PAE switch being on, you
aren't going to get anything. The PAE switch causes a different NT kernel
to be loaded which contains the code to manipulate memory addresses above
the 32 bit address space. Keep in mind that AWE is for data only. No
executable code can exist outside of the 32 bit address space. It's
actually quite rare to have an application with memory pressure due to data
alone.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eoJ8YgtGGHA.312@.TK2MSFTNGP09.phx.gbl...
> You need the /PAE switch although Win2003 may automatically add it for
> you. The /3GB can not be used with 16GB but can with 8GB. It is up to you
> if you need the extra directly addressable memory or not. IN either case
> you will also need to enable AWE in SQL Server.
> --
> Andrew J. Kelly SQL MVP
>
> "Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
> news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>

AWE on SQL Server 2000 & 2005

I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
2000 Enterprose I would like to use AWE,
to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
I have windows2003 server 32 bit version, 16Gb ram on it, running inder SQL
2005 Enterprose I would like to use AWE,
to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
SQL serer DBA
You need the /PAE switch although Win2003 may automatically add it for you.
The /3GB can not be used with 16GB but can with 8GB. It is up to you if you
need the extra directly addressable memory or not. IN either case you will
also need to enable AWE in SQL Server.
Andrew J. Kelly SQL MVP
"Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
> 2000 Enterprose I would like to use AWE,
> to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> I have windows2003 server 32 bit version, 16Gb ram on it, running inder
> SQL
> 2005 Enterprose I would like to use AWE,
> to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> --
> SQL serer DBA
|||And if you enable AWE in SQL Server without the PAE switch being on, you
aren't going to get anything. The PAE switch causes a different NT kernel
to be loaded which contains the code to manipulate memory addresses above
the 32 bit address space. Keep in mind that AWE is for data only. No
executable code can exist outside of the 32 bit address space. It's
actually quite rare to have an application with memory pressure due to data
alone.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eoJ8YgtGGHA.312@.TK2MSFTNGP09.phx.gbl...
> You need the /PAE switch although Win2003 may automatically add it for
> you. The /3GB can not be used with 16GB but can with 8GB. It is up to you
> if you need the extra directly addressable memory or not. IN either case
> you will also need to enable AWE in SQL Server.
> --
> Andrew J. Kelly SQL MVP
>
> "Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
> news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>

AWE on SQL Server 2000 & 2005

I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
2000 Enterprose I would like to use AWE,
to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
I have windows2003 server 32 bit version, 16Gb ram on it, running inder SQL
2005 Enterprose I would like to use AWE,
to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
please let me know if any one have this information.
--
SQL serer DBAYou need the /PAE switch although Win2003 may automatically add it for you.
The /3GB can not be used with 16GB but can with 8GB. It is up to you if you
need the extra directly addressable memory or not. IN either case you will
also need to enable AWE in SQL Server.
--
Andrew J. Kelly SQL MVP
"Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
> 2000 Enterprose I would like to use AWE,
> to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> I have windows2003 server 32 bit version, 16Gb ram on it, running inder
> SQL
> 2005 Enterprose I would like to use AWE,
> to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
> please let me know if any one have this information.
>
> --
> SQL serer DBA|||And if you enable AWE in SQL Server without the PAE switch being on, you
aren't going to get anything. The PAE switch causes a different NT kernel
to be loaded which contains the code to manipulate memory addresses above
the 32 bit address space. Keep in mind that AWE is for data only. No
executable code can exist outside of the 32 bit address space. It's
actually quite rare to have an application with memory pressure due to data
alone.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eoJ8YgtGGHA.312@.TK2MSFTNGP09.phx.gbl...
> You need the /PAE switch although Win2003 may automatically add it for
> you. The /3GB can not be used with 16GB but can with 8GB. It is up to you
> if you need the extra directly addressable memory or not. IN either case
> you will also need to enable AWE in SQL Server.
> --
> Andrew J. Kelly SQL MVP
>
> "Srikanth" <Srikanth@.discussions.microsoft.com> wrote in message
> news:61F51031-1B5D-454B-B88C-9D30442A5932@.microsoft.com...
>>I have windows2003 server 32 bit version, 8Gb ram on it, running inder SQL
>> 2000 Enterprose I would like to use AWE,
>> to enable AWE I need to add onlt \PAE or I need \3gb + \PAE in boot.ini?
>> please let me know if any one have this information.
>>
>> I have windows2003 server 32 bit version, 16Gb ram on it, running inder
>> SQL
>> 2005 Enterprose I would like to use AWE,
>> to enable AWE I need to add only \PAE or I need \3gb + \PAE in boot.ini?
>> please let me know if any one have this information.
>>
>> --
>> SQL serer DBA
>

Wednesday, March 7, 2012

AWE enabled on 64 bit system ?

Do we need to enable AWE on a 64 bit system ?
Do we need to add the /PAE switch ?
Can someone send me the link that specifically talks about these settings on
a 64 bit server , if one exists ? ThanksNo
On true 64 bit Intel Itanium Processor based Systems, there is no need for
AWE /3GB or PAE switches.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
> Do we need to enable AWE on a 64 bit system ?
> Do we need to add the /PAE switch ?
> Can someone send me the link that specifically talks about these settings
> on a 64 bit server , if one exists ? Thanks
>|||Although, interestingly enough, enabling 'lock pages in memory' can be
beneficial: http://blogs.msdn.com/slavao/archiv.../31/458545.aspx
Thanks,
--
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ukm9LtiuFHA.2568@.TK2MSFTNGP15.phx.gbl...
> No
> On true 64 bit Intel Itanium Processor based Systems, there is no need for
> AWE /3GB or PAE switches.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
>

AWE enabled on 64 bit system ?

Do we need to enable AWE on a 64 bit system ?
Do we need to add the /PAE switch ?
Can someone send me the link that specifically talks about these settings on
a 64 bit server , if one exists ? Thanks
No
On true 64 bit Intel Itanium Processor based Systems, there is no need for
AWE /3GB or PAE switches.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
> Do we need to enable AWE on a 64 bit system ?
> Do we need to add the /PAE switch ?
> Can someone send me the link that specifically talks about these settings
> on a 64 bit server , if one exists ? Thanks
>
|||Although, interestingly enough, enabling 'lock pages in memory' can be
beneficial: http://blogs.msdn.com/slavao/archive...31/458545.aspx
Thanks,
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ukm9LtiuFHA.2568@.TK2MSFTNGP15.phx.gbl...
> No
> On true 64 bit Intel Itanium Processor based Systems, there is no need for
> AWE /3GB or PAE switches.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
>

AWE enabled on 64 bit system ?

Do we need to enable AWE on a 64 bit system ?
Do we need to add the /PAE switch ?
Can someone send me the link that specifically talks about these settings on
a 64 bit server , if one exists ? ThanksNo
On true 64 bit Intel Itanium Processor based Systems, there is no need for
AWE /3GB or PAE switches.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
> Do we need to enable AWE on a 64 bit system ?
> Do we need to add the /PAE switch ?
> Can someone send me the link that specifically talks about these settings
> on a 64 bit server , if one exists ? Thanks
>|||Although, interestingly enough, enabling 'lock pages in memory' can be
beneficial: http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx
Thanks,
--
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ukm9LtiuFHA.2568@.TK2MSFTNGP15.phx.gbl...
> No
> On true 64 bit Intel Itanium Processor based Systems, there is no need for
> AWE /3GB or PAE switches.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:u7c7lKiuFHA.2948@.TK2MSFTNGP15.phx.gbl...
>> Do we need to enable AWE on a 64 bit system ?
>> Do we need to add the /PAE switch ?
>> Can someone send me the link that specifically talks about these settings
>> on a 64 bit server , if one exists ? Thanks
>

Thursday, March 8, 2012

AWE on Windows 64 Bit

AWE on Windows 64 Bit

AWE on Windows 64 Bit

AWE on SQL Server 2000 & 2005

AWE on SQL Server 2000 & 2005

AWE on SQL Server 2000 & 2005

Wednesday, March 7, 2012

AWE enabled on 64 bit system ?

AWE enabled on 64 bit system ?

AWE enabled on 64 bit system ?

Autonumber field

Blog Archive

About Me