benfit of 64bit windows os for sql 2000

I been reading quite a bit of documentation and am somewhat confused as to
whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQ
L
to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
specific settings but have found that SQL needs more memory. We cannot run
64bit SQL due to our application not supporting it. I understand that SQL
2000 will run under WOW on Win2K3 but will this truely offer us any better
performance?The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
Server 2003 x64 edition will give you any performance benefit truly depends
on the characteristics of your workloads. You have to test your app to tell;
I don't know a better way than actually testing.
It's very hard to predict how your specific app will behave in this
configuration from whatever you may read in general whitepapers.
Linchi
"Brian" wrote:

> I been reading quite a bit of documentation and am somewhat confused as to
> whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
> currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured
SQL
> to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQ
L
> specific settings but have found that SQL needs more memory. We cannot run
> 64bit SQL due to our application not supporting it. I understand that SQL
> 2000 will run under WOW on Win2K3 but will this truely offer us any better
> performance?|||Thanks. I guess its time for some real world testing.
"Linchi Shea" wrote:
[vbcol=seagreen]
> The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
> Server 2003 x64 edition will give you any performance benefit truly depend
s
> on the characteristics of your workloads. You have to test your app to tel
l;
> I don't know a better way than actually testing.
> It's very hard to predict how your specific app will behave in this
> configuration from whatever you may read in general whitepapers.
> Linchi
> "Brian" wrote:
>

benfit of 64bit windows os for sql 2000

I been reading quite a bit of documentation and am somewhat confused as to
whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
specific settings but have found that SQL needs more memory. We cannot run
64bit SQL due to our application not supporting it. I understand that SQL
2000 will run under WOW on Win2K3 but will this truely offer us any better
performance?The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
Server 2003 x64 edition will give you any performance benefit truly depends
on the characteristics of your workloads. You have to test your app to tell;
I don't know a better way than actually testing.
It's very hard to predict how your specific app will behave in this
configuration from whatever you may read in general whitepapers.
Linchi
"Brian" wrote:
> I been reading quite a bit of documentation and am somewhat confused as to
> whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
> currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
> to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
> specific settings but have found that SQL needs more memory. We cannot run
> 64bit SQL due to our application not supporting it. I understand that SQL
> 2000 will run under WOW on Win2K3 but will this truely offer us any better
> performance?|||Thanks. I guess its time for some real world testing.
"Linchi Shea" wrote:
> The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
> Server 2003 x64 edition will give you any performance benefit truly depends
> on the characteristics of your workloads. You have to test your app to tell;
> I don't know a better way than actually testing.
> It's very hard to predict how your specific app will behave in this
> configuration from whatever you may read in general whitepapers.
> Linchi
> "Brian" wrote:
> > I been reading quite a bit of documentation and am somewhat confused as to
> > whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
> > currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
> > to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
> > specific settings but have found that SQL needs more memory. We cannot run
> > 64bit SQL due to our application not supporting it. I understand that SQL
> > 2000 will run under WOW on Win2K3 but will this truely offer us any better
> > performance?

Benefits of 64bit SQL?

Hi,
I'm trying to decide whether our next database server should be 32 or 64
bit. Could someone please explain the benefits of 64bit computing and the
factors I should be looking at in order to determine whether it would be of
value to me?
The only benefit I'm aware of is the fact that memory beyond 4gigs can
be accessed directly -- but surely there must be other benefits as well. I
imagine that the speed at which data is transferred across the bus must be
doubled due to the fatter data path... but given that I'd still be limited
by the I/O speed of the drives, is the performance improvement even
relevant?
Sorry for the newbie questions. I just want to avoid having some slick
talking salesman sell us a 64bit machine if we don't really need it. I want
to know what questions to ask.
Thanks..."The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well.
That's pretty much it. But x64 64 bit does not add any cost to servers.
Intel and AMD's server chips are (basically) all 64 bit chips.
>I imagine that the speed at which data is transferred across the bus must
>be doubled due to the fatter data path... but given that I'd still be
>limited by the I/O speed of the drives, is the performance improvement even
>relevant?
Memory bus speed is a very important performance factor for databse servers.
With several gigabytes of data cached, moving that data in and out of the
CPU is one of the major system bottlenecks. Large on-chip L2 cache helps
here too. However 64 bit systems are not automatically better here. X64
servers use basically the same system boards as 32-bit systems.
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
You definitely want 64bit, since it doesn't really cost you anyting. You
still have to choose between x64 and IA64-based systems. Currently dollar
for dollar x64 is the performance king, but for certian very large workloads
you might need a big IA64 box.
David|||from a performance point of view, for the same hardware and less then 4Gb
there is no difference.
above 4Gb there are small improvements at the DB level. but managing the
memory is more easier.
the performance improvement is at the SSIS & AS levels. with more then 4Gb
these 2 tools takes a big advantage of this memory.
the other advantage is at the OS level.
Standard x64 edition of windows support 32Gb while the 32bits version is
limited to 4Gb.
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>|||http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>|||> However 64 bit systems are not automatically better here. X64 servers use
> basically the same system boards as 32-bit systems.
Hi David,
Could you expand on this a bit? Excuse my ignorance here, but what do
you mean when you say that X64 servers use basically the same system boards
as 32 bit systems? How is that possible? Also, is "X64" just a generic term
that's used to refer to 64 bit computing in general or does it represent a
particular *brand* of 64 bit processors designed by Intel (ala "Pentium" or
"386")?
Thanks,
Dave|||http://en.wikipedia.org/wiki/X64
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:x_SdnandWO39lEjenZ2dnUVZ_tidnZ2d@.giganews.com...
>> However 64 bit systems are not automatically better here. X64 servers
>> use basically the same system boards as 32-bit systems.
> Hi David,
> Could you expand on this a bit? Excuse my ignorance here, but what do
> you mean when you say that X64 servers use basically the same system
> boards as 32 bit systems? How is that possible? Also, is "X64" just a
> generic term that's used to refer to 64 bit computing in general or does
> it represent a particular *brand* of 64 bit processors designed by Intel
> (ala "Pentium" or "386")?
> Thanks,
> Dave
>

Benefits of 64bit SQL?

Hi,
I'm trying to decide whether our next database server should be 32 or 64
bit. Could someone please explain the benefits of 64bit computing and the
factors I should be looking at in order to determine whether it would be of
value to me?
The only benefit I'm aware of is the fact that memory beyond 4gigs can
be accessed directly -- but surely there must be other benefits as well. I
imagine that the speed at which data is transferred across the bus must be
doubled due to the fatter data path... but given that I'd still be limited
by the I/O speed of the drives, is the performance improvement even
relevant?
Sorry for the newbie questions. I just want to avoid having some slick
talking salesman sell us a 64bit machine if we don't really need it. I want
to know what questions to ask.
Thanks...
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well.
That's pretty much it. But x64 64 bit does not add any cost to servers.
Intel and AMD's server chips are (basically) all 64 bit chips.

>I imagine that the speed at which data is transferred across the bus must
>be doubled due to the fatter data path... but given that I'd still be
>limited by the I/O speed of the drives, is the performance improvement even
>relevant?
Memory bus speed is a very important performance factor for databse servers.
With several gigabytes of data cached, moving that data in and out of the
CPU is one of the major system bottlenecks. Large on-chip L2 cache helps
here too. However 64 bit systems are not automatically better here. X64
servers use basically the same system boards as 32-bit systems.

> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
You definitely want 64bit, since it doesn't really cost you anyting. You
still have to choose between x64 and IA64-based systems. Currently dollar
for dollar x64 is the performance king, but for certian very large workloads
you might need a big IA64 box.
David
|||from a performance point of view, for the same hardware and less then 4Gb
there is no difference.
above 4Gb there are small improvements at the DB level. but managing the
memory is more easier.
the performance improvement is at the SSIS & AS levels. with more then 4Gb
these 2 tools takes a big advantage of this memory.
the other advantage is at the OS level.
Standard x64 edition of windows support 32Gb while the 32bits version is
limited to 4Gb.
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>
|||http://www.microsoft.com/sql/techinf...vironment.mspx
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>
|||> However 64 bit systems are not automatically better here. X64 servers use
> basically the same system boards as 32-bit systems.
Hi David,
Could you expand on this a bit? Excuse my ignorance here, but what do
you mean when you say that X64 servers use basically the same system boards
as 32 bit systems? How is that possible? Also, is "X64" just a generic term
that's used to refer to 64 bit computing in general or does it represent a
particular *brand* of 64 bit processors designed by Intel (ala "Pentium" or
"386")?
Thanks,
Dave
|||http://en.wikipedia.org/wiki/X64
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:x_SdnandWO39lEjenZ2dnUVZ_tidnZ2d@.giganews.com ...
> Hi David,
> Could you expand on this a bit? Excuse my ignorance here, but what do
> you mean when you say that X64 servers use basically the same system
> boards as 32 bit systems? How is that possible? Also, is "X64" just a
> generic term that's used to refer to 64 bit computing in general or does
> it represent a particular *brand* of 64 bit processors designed by Intel
> (ala "Pentium" or "386")?
> Thanks,
> Dave
>

Benefits of 64bit SQL?

Hi,
I'm trying to decide whether our next database server should be 32 or 64
bit. Could someone please explain the benefits of 64bit computing and the
factors I should be looking at in order to determine whether it would be of
value to me?
The only benefit I'm aware of is the fact that memory beyond 4gigs can
be accessed directly -- but surely there must be other benefits as well. I
imagine that the speed at which data is transferred across the bus must be
doubled due to the fatter data path... but given that I'd still be limited
by the I/O speed of the drives, is the performance improvement even
relevant?
Sorry for the newbie questions. I just want to avoid having some slick
talking salesman sell us a 64bit machine if we don't really need it. I want
to know what questions to ask.
Thanks..."The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well.
That's pretty much it. But x64 64 bit does not add any cost to servers.
Intel and AMD's server chips are (basically) all 64 bit chips.

>I imagine that the speed at which data is transferred across the bus must
>be doubled due to the fatter data path... but given that I'd still be
>limited by the I/O speed of the drives, is the performance improvement even
>relevant?
Memory bus speed is a very important performance factor for databse servers.
With several gigabytes of data cached, moving that data in and out of the
CPU is one of the major system bottlenecks. Large on-chip L2 cache helps
here too. However 64 bit systems are not automatically better here. X64
servers use basically the same system boards as 32-bit systems.

> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
You definitely want 64bit, since it doesn't really cost you anyting. You
still have to choose between x64 and IA64-based systems. Currently dollar
for dollar x64 is the performance king, but for certian very large workloads
you might need a big IA64 box.
David|||from a performance point of view, for the same hardware and less then 4Gb
there is no difference.
above 4Gb there are small improvements at the DB level. but managing the
memory is more easier.
the performance improvement is at the SSIS & AS levels. with more then 4Gb
these 2 tools takes a big advantage of this memory.
the other advantage is at the OS level.
Standard x64 edition of windows support 32Gb while the 32bits version is
limited to 4Gb.
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>|||x" target="_blank">http://www.microsoft.com/sql/techin...nt.msp
x
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:yLudnZXu2Ii_AE7eRVn-gQ@.giganews.com...
> Hi,
> I'm trying to decide whether our next database server should be 32 or
> 64 bit. Could someone please explain the benefits of 64bit computing and
> the factors I should be looking at in order to determine whether it would
> be of value to me?
> The only benefit I'm aware of is the fact that memory beyond 4gigs can
> be accessed directly -- but surely there must be other benefits as well. I
> imagine that the speed at which data is transferred across the bus must be
> doubled due to the fatter data path... but given that I'd still be limited
> by the I/O speed of the drives, is the performance improvement even
> relevant?
> Sorry for the newbie questions. I just want to avoid having some slick
> talking salesman sell us a 64bit machine if we don't really need it. I
> want to know what questions to ask.
> Thanks...
>|||> However 64 bit systems are not automatically better here. X64 servers use
> basically the same system boards as 32-bit systems.
Hi David,
Could you expand on this a bit? Excuse my ignorance here, but what do
you mean when you say that X64 servers use basically the same system boards
as 32 bit systems? How is that possible? Also, is "X64" just a generic term
that's used to refer to 64 bit computing in general or does it represent a
particular *brand* of 64 bit processors designed by Intel (ala "Pentium" or
"386")?
Thanks,
Dave|||http://en.wikipedia.org/wiki/X64
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"The One We Call 'Dave'" <ghetto@.englewood.com> wrote in message
news:x_SdnandWO39lEjenZ2dnUVZ_tidnZ2d@.gi
ganews.com...
> Hi David,
> Could you expand on this a bit? Excuse my ignorance here, but what do
> you mean when you say that X64 servers use basically the same system
> boards as 32 bit systems? How is that possible? Also, is "X64" just a
> generic term that's used to refer to 64 bit computing in general or does
> it represent a particular *brand* of 64 bit processors designed by Intel
> (ala "Pentium" or "386")?
> Thanks,
> Dave
>