Tuesday, March 20, 2012

Performance benchmarks

Hello everyone,
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin Par
Microsoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Co..._vs_oracle.htm
http://www.microsoft.com/sql/evaluat...benchmarks.asp
http://searchdatabase.techtarget.com...953120,00.html
http://www.oracle.com/technology/pro...0g-vs-ss2k.pdf
David G.
|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>

No comments:

Post a Comment