64-bit performance vs 32-bit performance

Hi
Does anybody know of any official documents comparing 64-bit SQL Server
performance against 32-bit on a similar hardware platform? Apologies for
any cross posting that may have occurred only I need answer ASAP. Ideally I
need OLAP & OLTP benchmarks.
Regards.greedo wrote:
> Hi
> Does anybody know of any official documents comparing 64-bit SQL
> Server performance against 32-bit on a similar hardware platform?
> Apologies for any cross posting that may have occurred only I need
> answer ASAP. Ideally I need OLAP & OLTP benchmarks.
See TPC benchmarks for SQL Server at
http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
There are some 64-bit systems over there to compare against.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the quick response but unfortunately these systems vary wildly to
make true comparisons. What I'm looking for is case study where it shows
the true differences between 64-bit and 32-bit SQL Server rather than
numerous hardware configurations.
"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
in message news:uycl5KIAEHA.3400@.tk2msftngp13.phx.gbl...
> greedo wrote:
> > Hi
> >
> > Does anybody know of any official documents comparing 64-bit SQL
> > Server performance against 32-bit on a similar hardware platform?
> > Apologies for any cross posting that may have occurred only I need
> > answer ASAP. Ideally I need OLAP & OLTP benchmarks.
> See TPC benchmarks for SQL Server at
> http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
> There are some 64-bit systems over there to compare against.
> sincerely,
> --
> Sebastian K. Zaklada
> Skilled Software
> http://www.skilledsoftware.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||How can you compare them on a "similar hardware platform"? The hardware (at
least CPU etc) is completely different. You can't run 64 bit sql on a 32
bit machine.
--
Andrew J. Kelly SQL MVP
"greedo" <me@.there.com> wrote in message
news:eeb9kNIAEHA.1608@.TK2MSFTNGP11.phx.gbl...
> Thanks for the quick response but unfortunately these systems vary wildly
to
> make true comparisons. What I'm looking for is case study where it shows
> the true differences between 64-bit and 32-bit SQL Server rather than
> numerous hardware configurations.
>
> "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote
> in message news:uycl5KIAEHA.3400@.tk2msftngp13.phx.gbl...
> > greedo wrote:
> > > Hi
> > >
> > > Does anybody know of any official documents comparing 64-bit SQL
> > > Server performance against 32-bit on a similar hardware platform?
> > > Apologies for any cross posting that may have occurred only I need
> > > answer ASAP. Ideally I need OLAP & OLTP benchmarks.
> >
> > See TPC benchmarks for SQL Server at
> > http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
> > There are some 64-bit systems over there to compare against.
> >
> > sincerely,
> > --
> > Sebastian K. Zaklada
> > Skilled Software
> > http://www.skilledsoftware.com
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
>|||Sorry I should have been more specific. The results at www.tpc.org do no
have comparable results in that I am looking for a 4 x 64 bit CPU + 8 Gig
Ram against 4x32 bit CPU + 8 Gig Ram. Typically I'm finding 16 ways against
8 ways with differing Ram configurations which isn't really helpful!!
Hopefully someone can steer me in the right direction.
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:%23G8ae$KAEHA.212@.TK2MSFTNGP12.phx.gbl...
> How can you compare them on a "similar hardware platform"? The hardware
(at
> least CPU etc) is completely different. You can't run 64 bit sql on a 32
> bit machine.
> --
> Andrew J. Kelly SQL MVP
>
> "greedo" <me@.there.com> wrote in message
> news:eeb9kNIAEHA.1608@.TK2MSFTNGP11.phx.gbl...
> > Thanks for the quick response but unfortunately these systems vary
wildly
> to
> > make true comparisons. What I'm looking for is case study where it
shows
> > the true differences between 64-bit and 32-bit SQL Server rather than
> > numerous hardware configurations.
> >
> >
> > "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com>
wrote
> > in message news:uycl5KIAEHA.3400@.tk2msftngp13.phx.gbl...
> > > greedo wrote:
> > > > Hi
> > > >
> > > > Does anybody know of any official documents comparing 64-bit SQL
> > > > Server performance against 32-bit on a similar hardware platform?
> > > > Apologies for any cross posting that may have occurred only I need
> > > > answer ASAP. Ideally I need OLAP & OLTP benchmarks.
> > >
> > > See TPC benchmarks for SQL Server at
> > > http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
> > > There are some 64-bit systems over there to compare against.
> > >
> > > sincerely,
> > > --
> > > Sebastian K. Zaklada
> > > Skilled Software
> > > http://www.skilledsoftware.com
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> >
> >
>|||I see now what your after. I don't have a specific link but this has a
lotof info:
http://www.microsoft.com/sql/64bit/productinfo/newsandreviews.asp
--
Andrew J. Kelly SQL MVP
"greedo" <me@.there.com> wrote in message
news:OcrA5PLAEHA.392@.TK2MSFTNGP12.phx.gbl...
> Sorry I should have been more specific. The results at www.tpc.org do no
> have comparable results in that I am looking for a 4 x 64 bit CPU + 8 Gig
> Ram against 4x32 bit CPU + 8 Gig Ram. Typically I'm finding 16 ways
against
> 8 ways with differing Ram configurations which isn't really helpful!!
> Hopefully someone can steer me in the right direction.
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:%23G8ae$KAEHA.212@.TK2MSFTNGP12.phx.gbl...
> > How can you compare them on a "similar hardware platform"? The hardware
> (at
> > least CPU etc) is completely different. You can't run 64 bit sql on a
32
> > bit machine.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "greedo" <me@.there.com> wrote in message
> > news:eeb9kNIAEHA.1608@.TK2MSFTNGP11.phx.gbl...
> > > Thanks for the quick response but unfortunately these systems vary
> wildly
> > to
> > > make true comparisons. What I'm looking for is case study where it
> shows
> > > the true differences between 64-bit and 32-bit SQL Server rather than
> > > numerous hardware configurations.
> > >
> > >
> > > "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com>
> wrote
> > > in message news:uycl5KIAEHA.3400@.tk2msftngp13.phx.gbl...
> > > > greedo wrote:
> > > > > Hi
> > > > >
> > > > > Does anybody know of any official documents comparing 64-bit SQL
> > > > > Server performance against 32-bit on a similar hardware platform?
> > > > > Apologies for any cross posting that may have occurred only I need
> > > > > answer ASAP. Ideally I need OLAP & OLTP benchmarks.
> > > >
> > > > See TPC benchmarks for SQL Server at
> > > > http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
> > > > There are some 64-bit systems over there to compare against.
> > > >
> > > > sincerely,
> > > > --
> > > > Sebastian K. Zaklada
> > > > Skilled Software
> > > > http://www.skilledsoftware.com
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > >
> > >
> >
> >
>|||not sure if this helps you -
in evaluating 64bit for our purposes the one thing that stood out to us is
the olap piece. analysis services ability to address more than 3gig of ram
should seal the deal for you if you are working on a dw project that will
utilize large cubes. that process is memory intensive and loves to eat up
the ram.
as for the oltp piece - that seems to be a little tougher to quantify.
basically, any applications that are memory intensive should yield better
performance from the 64bit platform.
my rec, and i know time is important right now, is to contact both your
local microsoft office and speak to the sql server technology specialist and
ask them if they have any 64bit machines in their labs.
the local office should have a demo machine or access to a demo machine via
hp that you can use and test. personally, that would be the best way to test
your apps in deciding if 64bit is right for you. i have worked with several
customers and that was the route they went to help them make a decision.
hth -
Sal
"greedo" <me@.there.com> wrote in message
news:O8e5WFIAEHA.2432@.TK2MSFTNGP11.phx.gbl...
> Hi
> Does anybody know of any official documents comparing 64-bit SQL Server
> performance against 32-bit on a similar hardware platform? Apologies for
> any cross posting that may have occurred only I need answer ASAP. Ideally
I
> need OLAP & OLTP benchmarks.
>
> Regards.
>
>|||I can't help with your specific question, but there's an interesting
database performance comparison of Intel Xeons vs. AMD Opterons at
http://www.anandtech.com/IT/showdoc.html?i=1982 .
Mike Kruchten
"greedo" <me@.there.com> wrote in message
news:OcrA5PLAEHA.392@.TK2MSFTNGP12.phx.gbl...
> Sorry I should have been more specific. The results at www.tpc.org do no
> have comparable results in that I am looking for a 4 x 64 bit CPU + 8 Gig
> Ram against 4x32 bit CPU + 8 Gig Ram. Typically I'm finding 16 ways
against
> 8 ways with differing Ram configurations which isn't really helpful!!
> Hopefully someone can steer me in the right direction.
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:%23G8ae$KAEHA.212@.TK2MSFTNGP12.phx.gbl...
> > How can you compare them on a "similar hardware platform"? The hardware
> (at
> > least CPU etc) is completely different. You can't run 64 bit sql on a
32
> > bit machine.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "greedo" <me@.there.com> wrote in message
> > news:eeb9kNIAEHA.1608@.TK2MSFTNGP11.phx.gbl...
> > > Thanks for the quick response but unfortunately these systems vary
> wildly
> > to
> > > make true comparisons. What I'm looking for is case study where it
> shows
> > > the true differences between 64-bit and 32-bit SQL Server rather than
> > > numerous hardware configurations.
> > >
> > >
> > > "Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com>
> wrote
> > > in message news:uycl5KIAEHA.3400@.tk2msftngp13.phx.gbl...
> > > > greedo wrote:
> > > > > Hi
> > > > >
> > > > > Does anybody know of any official documents comparing 64-bit SQL
> > > > > Server performance against 32-bit on a similar hardware platform?
> > > > > Apologies for any cross posting that may have occurred only I need
> > > > > answer ASAP. Ideally I need OLAP & OLTP benchmarks.
> > > >
> > > > See TPC benchmarks for SQL Server at
> > > > http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
> > > > There are some 64-bit systems over there to compare against.
> > > >
> > > > sincerely,
> > > > --
> > > > Sebastian K. Zaklada
> > > > Skilled Software
> > > > http://www.skilledsoftware.com
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > >
> > >
> >
> >
>