If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
Thanks
You shouldn't have to do any config on a 64 bit SS on a 64 bit machine for using > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Oks blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks
|||2147483647 is much more than 2GB... 1024 = 1GB
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks
|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label versions. Show all posts
Showing posts with label versions. Show all posts
Thursday, March 8, 2012
6G Ram but SQL doesn't make use of it by default
If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
ThanksYou shouldn't have to do any config on a 64 bit SS on a 64 bit machine for u
sing > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Ok
s blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, i
n
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||2147483647 is much more than 2GB... 1024 = 1GB
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
ThanksYou shouldn't have to do any config on a 64 bit SS on a 64 bit machine for u
sing > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Ok
s blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, i
n
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||2147483647 is much more than 2GB... 1024 = 1GB
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
6G Ram but SQL doesn't make use of it by default
If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
ThanksYou shouldn't have to do any config on a 64 bit SS on a 64 bit machine for using > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Oks blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||2147483647 is much more than 2GB... 1024 = 1GB
--
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
I have made a new fresh setup (everything is in 64 bit version) on a brand
new machine with 6Gigs of RAM, still when I display server's properties, in
the memory section, in the textbox under Max Server memory
I have 2147483647, which I think is 2 G
ThanksYou shouldn't have to do any config on a 64 bit SS on a 64 bit machine for using > 2GB memory.
> I have 2147483647, which I think is 2 G
No, that number is in MB:
2147483647 MB
= 2097151 GB
= 2047 TB
= approx 2 PB (it is Peta or Exa?)
No discussion on memory and 64 bit is complete without referring to Slava Oks blogs. In short,
consider using lock pages in memory also on 64 bit (if my memory serves me):
http://blogs.msdn.com/slavao/archive/category/9043.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties, in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||2147483647 is much more than 2GB... 1024 = 1GB
--
Keith Kratochvil
"SalamElias" <eliassal@.online.nospam> wrote in message
news:60DD00FD-BFA2-4A68-B6B5-142E8B895D45@.microsoft.com...
> If I setup SQL 2005 64 bit on a win2k3 64 bit, do I need to enable/disable
> AWE as for other versions or it is managed dynamically by SQL 2005 64 bit.
> I have made a new fresh setup (everything is in 64 bit version) on a brand
> new machine with 6Gigs of RAM, still when I display server's properties,
> in
> the memory section, in the textbox under Max Server memory
> I have 2147483647, which I think is 2 G
> Thanks|||Hi Salam,
As other members have mentioned, the 2147483647 default value is in MB, so
it is a quite large value( you need to reduce it according to your
machine's physical memory).
As for AWE, it is an operating system feature and is only useful when the
virtual address space(of OS process) is less than the available physical
memory. For SQL server 2005 64 bit on windows 2003 64 bit, there is no
such virtual address space limitation(normally virtual address space is
much larger than available physical memory space). also, it is recommended
that we adjust the SQL Server instance's max server memory to a proper
value so that other applications on the server can also get sufficient
physical memory for paging file switch.
#Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Salam,
Have you got any further idea on this issue? Please feel free to post here
if there is anything else we can help.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
Tuesday, March 6, 2012
64-bit SQL Server for Xeon
Hello,
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank youHi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> > Hello,
> > Is there a SQL Server 2000 64-bit Edition for XEON processors?
> > I saw that there are two different versions of SQL 2005 (64 Bit Extended
> > and
> > 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> > for Itanium processors.
> >
> > Thank you
>
>|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank youHi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> > Hello,
> > Is there a SQL Server 2000 64-bit Edition for XEON processors?
> > I saw that there are two different versions of SQL 2005 (64 Bit Extended
> > and
> > 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> > for Itanium processors.
> >
> > Thank you
>
>|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
64-bit SQL Server for Xeon
Hello,
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank you
Hi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you
|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
>
>
|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank you
Hi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you
|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
>
>
|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
64-bit SQL Server for Xeon
Hello,
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank youHi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
>
>|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
Is there a SQL Server 2000 64-bit Edition for XEON processors?
I saw that there are two different versions of SQL 2005 (64 Bit Extended and
64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
for Itanium processors.
Thank youHi
SQL Server 2000 has only a full 64 bit edition of Itaniums.
SQL Server 2000 with SP4 supports EM64T and x64.
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/
"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
> Hello,
> Is there a SQL Server 2000 64-bit Edition for XEON processors?
> I saw that there are two different versions of SQL 2005 (64 Bit Extended
> and
> 64 Bit Itanium), but for SQL 2000 I found only one, and it seems that it's
> for Itanium processors.
> Thank you|||So how do I install SQL 64-bit on a Xeon processor based server? Is there a
release "SQL 2000 with SP4"? And if so, is 64-bit an option during
installation?
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2000 has only a full 64 bit edition of Itaniums.
> SQL Server 2000 with SP4 supports EM64T and x64.
> 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/
> "Vi" <Vi@.discussions.microsoft.com> wrote in message
> news:8B3CC9AB-8025-4CDB-9B1D-4F0AC5DFFB8E@.microsoft.com...
>
>|||"Vi" <Vi@.discussions.microsoft.com> wrote in message
news:A329E111-A514-4860-9697-64F947441955@.microsoft.com...
> So how do I install SQL 64-bit on a Xeon processor based server? Is there
> a
> release "SQL 2000 with SP4"? And if so, is 64-bit an option during
> installation?
>
It's 32-bit SQL Server 2000 running in WOW32 mode on 64-bit windows. You
get a 4gig user-mode address space because of WOW64, but it's still a 32-bit
application.
David
Subscribe to:
Posts (Atom)