|
|
You're in the
sql server data warehouse
group:64-bit performance vs 32-bit performance
sql server data warehouse:
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.
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. [quoted text, click to view] "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 [quoted text, click to view] "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. > > > > > >
[quoted text, click to view]
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 [quoted text, click to view] "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. > > > > > > > > > > > > > > > > > > > >
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. [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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. > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |