get table size: x64

Showing posts with label x64. Show all posts

Monday, March 26, 2012

How much memory can 32-bit SQL Server 2000 use on Windows Server 2003 Standard x64 Edition

I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k Adv.
Server and 64 GB on Win2k Datacenter with AWE enabled. The grand question
I have is how much can it address on Win2003 Standard x64? The full 32 GB?
Or does the x64 editions not support the AWE method that the 32-bit version
uses?
Thanks!
PaulThis is a multi-part message in MIME format.
--070906010403080101090103
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
You've mixed up SQL & Windows versions & editions in your question a
little but I think I understand what you're getting at.
You'd be wanting to run the 64 bit edition of SQL Server 2000
(Enterprise) if you're planning on running it on a x64 version of
Windows. Given that, max memory is not really a consideration anymore
because 64 bit addressing works differently to 32 bit addressing and the
64 bit edition of SQL Server 2000 (Enterprise) can address up to 512GB
of memory (no AWE needed anymore); 64-bit addressing has a theoretical
limit of 18 Exabytes. So it's pretty much a case of how much memory can
the OS present to SQL Server?
Advantages of 64 bit SQL Server:
http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Paul Widner wrote:
>I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k Adv.
>Server and 64 GB on Win2k Datacenter with AWE enabled. The grand question
>I have is how much can it address on Win2003 Standard x64? The full 32 GB?
>Or does the x64 editions not support the AWE method that the 32-bit version
>uses?
>
>Thanks!
>Paul
>
>
--070906010403080101090103
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>You've mixed up SQL & Windows versions & editions in your
question a little but I think I understand what you're getting at. 
 
You'd be wanting to run the 64 bit edition of SQL Server 2000
(Enterprise) if you're planning on running it on a x64 version of
Windows. Given that, max memory is not really a consideration anymore
because 64 bit addressing works differently to 32 bit addressing and
the 64 bit edition of SQL Server 2000 (Enterprise) can address up to
512GB of memory (no AWE needed anymore); 64-bit addressing has a
theoretical limit of 18 Exabytes. So it's pretty much a case of how
much memory can the OS present to SQL Server? 
 
Advantages of 64 bit SQL Server: 
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp</a> ">http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp">http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp</a> 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Paul Widner wrote:
<blockquote cite="midu0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k Adv.
Server and 64 GB on Win2k Datacenter with AWE enabled. The grand question
I have is how much can it address on Win2003 Standard x64? The full 32 GB?
Or does the x64 editions not support the AWE method that the 32-bit version
uses?
Thanks!
Paul
</pre>
</blockquote>
</body>
</html>
--070906010403080101090103--|||Mike,
I might be wrong, but as I understand it, the only 64 bit SQL server 2000 is for Itanium. For x64,
you need to run 32 bit SQL server (which requires sp4 of SQL2K to be supported).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:Obp8hhkcFHA.220@.TK2MSFTNGP12.phx.gbl...
> You've mixed up SQL & Windows versions & editions in your question a
> little but I think I understand what you're getting at.
> You'd be wanting to run the 64 bit edition of SQL Server 2000
> (Enterprise) if you're planning on running it on a x64 version of
> Windows. Given that, max memory is not really a consideration anymore
> because 64 bit addressing works differently to 32 bit addressing and the
> 64 bit edition of SQL Server 2000 (Enterprise) can address up to 512GB
> of memory (no AWE needed anymore); 64-bit addressing has a theoretical
> limit of 18 Exabytes. So it's pretty much a case of how much memory can
> the OS present to SQL Server?
> Advantages of 64 bit SQL Server:
> http://www.microsoft.com/sql/64bit/productinfo/SQL64bitAdvantages.asp
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Paul Widner wrote:
>>I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
>>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k Adv.
>>Server and 64 GB on Win2k Datacenter with AWE enabled. The grand question
>>I have is how much can it address on Win2003 Standard x64? The full 32 GB?
>>Or does the x64 editions not support the AWE method that the 32-bit version
>>uses?
>>
>>Thanks!
>>Paul
>>
>>
>|||This is a multi-part message in MIME format.
--070805020306060307040909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
On SQL matters I am much more likely to be wrong than you Tibor.
After conducting a little research on the matter I see you are quite
right (http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx). I
eat humble pie.
Oh well, at least I found that out before going out and buying SQL
64-bit & a brand new quad-Xeon (with EM64T extensions) box running Win
2003 x64 and expecting it to run. Hmmm...I'd better rethink our 64-bit
SQL strategy methinks (good excuse to get some Itanium boxes <grin>).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Tibor Karaszi wrote:
>Mike,
>I might be wrong, but as I understand it, the only 64 bit SQL server 2000 is for Itanium. For x64,
>you need to run 32 bit SQL server (which requires sp4 of SQL2K to be supported).
>
>
--070805020306060307040909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>On SQL matters I am much more likely to be wrong than you Tibor. 
 
After conducting a little research on the matter I see you are quite
right (</tt><tt><a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx</a></tt><tt>). ">http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx">http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx</a></tt><tt>).
I eat humble pie. 
 
Oh well, at least I found that out before going out and buying SQL
64-bit & a brand new quad-Xeon (with EM64T extensions) box running
Win 2003 x64 and </tt><tt>expecting it to run</tt><tt>. Hmmm...I'd
better rethink our 64-bit SQL strategy methinks (good excuse to get
some Itanium boxes <grin>). 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Tibor Karaszi wrote:
<blockquote cite="mid%23FTpD4lcFHA.3040@.TK2MSFTNGP14.phx.gbl"
type="cite">
<pre wrap="">Mike,
I might be wrong, but as I understand it, the only 64 bit SQL server 2000 is for Itanium. For x64,
you need to run 32 bit SQL server (which requires sp4 of SQL2K to be supported).
</pre>
</blockquote>
</body>
</html>
--070805020306060307040909--|||Thanks for the confirmation, Mike. I also found below at the sp4 home page (which you probably seen,
but just in case):
"SQL Server 2000 Service Pack 4 (SP4) adds platform support for Microsoft Windows Server 2003 x64
Edition, allowing 32-bit SQL Server 2000 applications to run on 64-bit platforms using the Windows
on Windows emulator (WOW64). SP4 addresses specific issues discovered in SQL Server 2000 since its
ship date. SP4 is also the first service pack to service the 64-bit edition of SQL Server."
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:uBu$aXmcFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On SQL matters I am much more likely to be wrong than you Tibor.
> After conducting a little research on the matter I see you are quite
> right (http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx). I
> eat humble pie.
> Oh well, at least I found that out before going out and buying SQL
> 64-bit & a brand new quad-Xeon (with EM64T extensions) box running Win
> 2003 x64 and expecting it to run. Hmmm...I'd better rethink our 64-bit
> SQL strategy methinks (good excuse to get some Itanium boxes <grin>).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
> Tibor Karaszi wrote:
>>Mike,
>>I might be wrong, but as I understand it, the only 64 bit SQL server 2000 is for Itanium. For x64,
>>you need to run 32 bit SQL server (which requires sp4 of SQL2K to be supported).
>>
>|||I'm guessing here but I think SQL2000 Enterprise should be able to access up
to 4GB on W2003 x64.
A 32bit app won't be able to access any more than 4GB on W2003 x64 because
you can't use PAE extensions, but I think as SQL 2000 is compiled to be
large memory aware it will be able to access more than 2GB.
Peter Lawton
"Paul Widner" <paul_widner@.hotmail.com> wrote in message
news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl...
>I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k
>Adv. Server and 64 GB on Win2k Datacenter with AWE enabled. The grand
>question I have is how much can it address on Win2003 Standard x64? The
>full 32 GB? Or does the x64 editions not support the AWE method that the
>32-bit version uses?
>
> Thanks!
> Paul
>|||PMJI, but SQL2005 will run 64-bit on Windows x64, so I wouldn't rush out and
spend money on an Itanium system unless you really need the performance.
It's supposed to be released the week of Nov. 7th.
Mike Kruchten
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:uBu$aXmcFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On SQL matters I am much more likely to be wrong than you Tibor.
> After conducting a little research on the matter I see you are quite
> right (http://www.microsoft.com/sql/64bit/productinfo/sysreq.mspx). I
> eat humble pie.
> Oh well, at least I found that out before going out and buying SQL
> 64-bit & a brand new quad-Xeon (with EM64T extensions) box running Win
> 2003 x64 and expecting it to run. Hmmm...I'd better rethink our 64-bit
> SQL strategy methinks (good excuse to get some Itanium boxes <grin>).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> Tibor Karaszi wrote:
>>Mike,
>>I might be wrong, but as I understand it, the only 64 bit SQL server 2000
>>is for Itanium. For x64,
>>you need to run 32 bit SQL server (which requires sp4 of SQL2K to be
>>supported).
>>
>|||Anyone know how I can go about getting an offical response from Microsoft in
regard to this?
Paul
"Peter Lawton" <devnull@.dummydomain.com> wrote in message
news:O1t0yJncFHA.2520@.TK2MSFTNGP09.phx.gbl...
> I'm guessing here but I think SQL2000 Enterprise should be able to access
> up to 4GB on W2003 x64.
> A 32bit app won't be able to access any more than 4GB on W2003 x64 because
> you can't use PAE extensions, but I think as SQL 2000 is compiled to be
> large memory aware it will be able to access more than 2GB.
> Peter Lawton
> "Paul Widner" <paul_widner@.hotmail.com> wrote in message
> news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl...
>>I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
>>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k
>>Adv. Server and 64 GB on Win2k Datacenter with AWE enabled. The grand
>>question I have is how much can it address on Win2003 Standard x64? The
>>full 32 GB? Or does the x64 editions not support the AWE method that the
>>32-bit version uses?
>>
>> Thanks!
>> Paul
>|||This is a multi-part message in MIME format.
--050007030501090103020505
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Flick Paul Flessner or Euan Garden an email?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Paul Widner wrote:
>Anyone know how I can go about getting an offical response from Microsoft in
>regard to this?
>Paul
>
>"Peter Lawton" <devnull@.dummydomain.com> wrote in message
>news:O1t0yJncFHA.2520@.TK2MSFTNGP09.phx.gbl...
>
>>I'm guessing here but I think SQL2000 Enterprise should be able to access
>>up to 4GB on W2003 x64.
>>A 32bit app won't be able to access any more than 4GB on W2003 x64 because
>>you can't use PAE extensions, but I think as SQL 2000 is compiled to be
>>large memory aware it will be able to access more than 2GB.
>>Peter Lawton
>>"Paul Widner" <paul_widner@.hotmail.com> wrote in message
>>news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl...
>>
>>I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
>>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k
>>Adv. Server and 64 GB on Win2k Datacenter with AWE enabled. The grand
>>question I have is how much can it address on Win2003 Standard x64? The
>>full 32 GB? Or does the x64 editions not support the AWE method that the
>>32-bit version uses?
>>
>>Thanks!
>>Paul
>>
>>
>
>
--050007030501090103020505
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Flick Paul Flessner or Euan Garden an email?</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Paul Widner wrote:
<blockquote cite="midO1fHdVpcFHA.1384@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">Anyone know how I can go about getting an offical response from Microsoft in
regard to this?
Paul
"Peter Lawton" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:devnull@.dummydomain.com"><devnull@.dummydomain.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:O1t0yJncFHA.2520@.TK2MSFTNGP09.phx.gbl">news:O1t0yJncFHA.2520@.TK2MSFTNGP09.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">I'm guessing here but I think SQL2000 Enterprise should be able to access
up to 4GB on W2003 x64.
A 32bit app won't be able to access any more than 4GB on W2003 x64 because
you can't use PAE extensions, but I think as SQL 2000 is compiled to be
large memory aware it will be able to access more than 2GB.
Peter Lawton
"Paul Widner" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:paul_widner@.hotmail.com"><paul_widner@.hotmail.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl">news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">I know the maximum memory that Server 2003 Standard x64 supports is 32 GB.
I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k
Adv. Server and 64 GB on Win2k Datacenter with AWE enabled. The grand
question I have is how much can it address on Win2003 Standard x64? The
full 32 GB? Or does the x64 editions not support the AWE method that the
32-bit version uses?
Thanks!
Paul
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--050007030501090103020505--|||Did anyone ever get an answer to this?
"Paul Widner" <paul_widner@.hotmail.com> wrote in message
news:O1fHdVpcFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Anyone know how I can go about getting an offical response from Microsoft
in
> regard to this?
> Paul
>
> "Peter Lawton" <devnull@.dummydomain.com> wrote in message
> news:O1t0yJncFHA.2520@.TK2MSFTNGP09.phx.gbl...
> > I'm guessing here but I think SQL2000 Enterprise should be able to
access
> > up to 4GB on W2003 x64.
> >
> > A 32bit app won't be able to access any more than 4GB on W2003 x64
because
> > you can't use PAE extensions, but I think as SQL 2000 is compiled to be
> > large memory aware it will be able to access more than 2GB.
> >
> > Peter Lawton
> >
> > "Paul Widner" <paul_widner@.hotmail.com> wrote in message
> > news:u0vkGadcFHA.2520@.TK2MSFTNGP09.phx.gbl...
> >>I know the maximum memory that Server 2003 Standard x64 supports is 32
GB.
> >>I know that 32-bit SQL Server 2003 Enterprise can address 8 GB on Win2k
> >>Adv. Server and 64 GB on Win2k Datacenter with AWE enabled. The grand
> >>question I have is how much can it address on Win2003 Standard x64? The
> >>full 32 GB? Or does the x64 editions not support the AWE method that the
> >>32-bit version uses?
> >>
> >>
> >> Thanks!
> >> Paul
> >>
> >
> >
>

How much memory can 32-bit SQL Server 2000 use on Windows Server 2003 Standard x64 Edi

Monday, March 19, 2012

How many 64 bit architectures are out there ?

I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
same as x64? Can someone tell me what else is out there and differences
between those ?
Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
IA64 called ?
I take it that SQL 20005 only has its bits on IA64 and x64 right ?There are only two 64 bit architectures supported by SQL Server (and
actually driven by the supported 64-bit architectures for Windows). The
separation is based on the underlying processor architecture.
The first one is IA-64 (or Itanium) and it is based on the EPIC (Explicitly
Parallel Instruction Computing) instruction set. This is Intel's first true
64-bit chip.
The second 64 bit architecture is x64 (or x86-64) which is essentially the
x86 architecture with extensions to include 64 bit functionality. All Intel
x64 and AMD64 processors fall in this category. It was first introduced with
AMD's Athlon 64.
There is no 32 bit equivalent for IA-64 as it was designed to be 64 bit from
the beginning.
It is more correct to say x86-32 for the 32-bit equivalent, as x86 is the
generic name for the architecture which started with Intel's 8086 processor
which was 16-bit. The x86-32 was introduced with the Intel 386 processor.
See more details on 64-bit computing with SQL Server 2005 here:
http://www.microsoft.com/sql/editio...t/overview.mspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>|||To add on to Plamen's response, AMD64 (AMD) and EMT64 (Intel) are basically
vendor-specific names for x64.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>|||In addition, read this http://en.wikipedia.org/wiki/X64
Linchi
"Hassan" wrote:

> I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
> same as x64? Can someone tell me what else is out there and differences
> between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>
>

How many 64 bit architectures are out there ?

I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
same as x64? Can someone tell me what else is out there and differences
between those ?
Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
IA64 called ?
I take it that SQL 20005 only has its bits on IA64 and x64 right ?
There are only two 64 bit architectures supported by SQL Server (and
actually driven by the supported 64-bit architectures for Windows). The
separation is based on the underlying processor architecture.
The first one is IA-64 (or Itanium) and it is based on the EPIC (Explicitly
Parallel Instruction Computing) instruction set. This is Intel's first true
64-bit chip.
The second 64 bit architecture is x64 (or x86-64) which is essentially the
x86 architecture with extensions to include 64 bit functionality. All Intel
x64 and AMD64 processors fall in this category. It was first introduced with
AMD's Athlon 64.
There is no 32 bit equivalent for IA-64 as it was designed to be 64 bit from
the beginning.
It is more correct to say x86-32 for the 32-bit equivalent, as x86 is the
generic name for the architecture which started with Intel's 8086 processor
which was 16-bit. The x86-32 was introduced with the Intel 386 processor.
See more details on 64-bit computing with SQL Server 2005 here:
http://www.microsoft.com/sql/editions/64bit/overview.mspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>
|||To add on to Plamen's response, AMD64 (AMD) and EMT64 (Intel) are basically
vendor-specific names for x64.
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>
|||In addition, read this http://en.wikipedia.org/wiki/X64
Linchi
"Hassan" wrote:

> I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
> same as x64? Can someone tell me what else is out there and differences
> between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>
>

How many 64 bit architectures are out there ?

I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
same as x64? Can someone tell me what else is out there and differences
between those ?
Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
IA64 called ?
I take it that SQL 20005 only has its bits on IA64 and x64 right ?There are only two 64 bit architectures supported by SQL Server (and
actually driven by the supported 64-bit architectures for Windows). The
separation is based on the underlying processor architecture.
The first one is IA-64 (or Itanium) and it is based on the EPIC (Explicitly
Parallel Instruction Computing) instruction set. This is Intel's first true
64-bit chip.
The second 64 bit architecture is x64 (or x86-64) which is essentially the
x86 architecture with extensions to include 64 bit functionality. All Intel
x64 and AMD64 processors fall in this category. It was first introduced with
AMD's Athlon 64.
There is no 32 bit equivalent for IA-64 as it was designed to be 64 bit from
the beginning.
It is more correct to say x86-32 for the 32-bit equivalent, as x86 is the
generic name for the architecture which started with Intel's 8086 processor
which was 16-bit. The x86-32 was introduced with the Intel 386 processor.
See more details on 64-bit computing with SQL Server 2005 here:
http://www.microsoft.com/sql/editions/64bit/overview.mspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>|||To add on to Plamen's response, AMD64 (AMD) and EMT64 (Intel) are basically
vendor-specific names for x64.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:O39B4jtLHHA.1044@.TK2MSFTNGP02.phx.gbl...
>I have heard of IA64 bit and x64 bit ? Is there an AMD64 as well or is the
>same as x64? Can someone tell me what else is out there and differences
>between those ?
> Is x86 a 32 bit equivalent of x64 ? If so whats the 32 bit eqiivalent to
> IA64 called ?
> I take it that SQL 20005 only has its bits on IA64 and x64 right ?
>

Monday, March 26, 2012

How much memory can 32-bit SQL Server 2000 use on Windows Server 2003 Standard x64 Edition

How much memory can 32-bit SQL Server 2000 use on Windows Server 2003 Standard x64 Edition

How much memory can 32-bit SQL Server 2000 use on Windows Server 2003 Standard x64 Edi

Monday, March 19, 2012

How many 64 bit architectures are out there ?

How many 64 bit architectures are out there ?

How many 64 bit architectures are out there ?

get table size

Blog Archive

About Me