Setting Performance Benchmarks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dibur - 04 Jul 2006 16:43 GMT

I have been told to set the performance benchmarks for all the db2
databases hosted on all servers. I have no clue as to how to approach
this problem.
Can this be done theoritically through extrapolation techniques.One
thing that is important here is that all the servers are in production
phase so practically carrying out load testing is not feasible.
Any ideas , suggestions or comments are welcome

Reply to this Message

Larry - 04 Jul 2006 17:24 GMT

> I have been told to set the performance benchmarks for all the db2
> databases hosted on all servers. I have no clue as to how to approach
[quoted text clipped - 3 lines]
> phase so practically carrying out load testing is not feasible.
> Any ideas , suggestions or comments are welcome

What exactly does "set the performance benchmarks" mean, and what is the
objective?

Larry Edelstein

Reply to this Message

Dibur - 05 Jul 2006 04:16 GMT

I guess i should ask what are the performance benchmarks for a
database?

> > I have been told to set the performance benchmarks for all the db2
> > databases hosted on all servers. I have no clue as to how to approach
[quoted text clipped - 8 lines]
>
> Larry Edelstein

Reply to this Message

Gregor Kovač - 05 Jul 2006 08:35 GMT

> I guess i should ask what are the performance benchmarks for a
> database?
[quoted text clipped - 10 lines]
>>
>> Larry Edelstein

Hmm.. I hope you mean this:
http://www-306.ibm.com/software/data/highlights/benchmarks/20050214.html
or
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Reply to this Message

Oliver Mensinger - 05 Jul 2006 11:37 GMT

Check this out: www.tpc.org
This council defines benchmarks for transaction and datawarehouse load.
Look at the test results. The complete PDF includes not only the
calculated benchmark results, but also the scripts that where used.

HTH, Oliver.

Reply to this Message