performance testing

I would like to test some servers. Is there a simple testtool to benchmark
performance. I would like to have it tested on a Itanium 64 bits server and
32 bit server to forcast the performance gain. Besides the server switch the
San will also be upgraded.
Does any one have predifined query's ?
SQL&Sap wrote:
> I would like to test some servers. Is there a simple testtool to
> benchmark performance. I would like to have it tested on a Itanium 64
> bits server and 32 bit server to forcast the performance gain.
> Besides the server switch the San will also be upgraded.
> Does any one have predifined query's ?
Pre-defined queries won't really tell you how much of an improvement, if
any, you are going to see moving from one server to another. In fact,
they could serve to inflate expectations. For that type of information,
a simple reference to tpc.org benchmarks or the manufacturers claim of
TPS would suffice.
I strongly suggest you test your own database and applications on the
new server and compare to the old one in terms of SQL performance.
It's easy to assume that because you're moving from a 32-bit Intel
system to a 64-bit Itanium one, that the performance will be faster. And
on paper, that's probably true. But SQL performance is a different beast
and it's best to test what you plan to run on the server.
If you can come up with a set of queries that you either run manually
or, better yet, are run from existing applications, you can use a tool
like Profiler or Speed Coefficient from Imceda to benchmark your SQL
performance on both systems and compare the results.
David Gugick
Imceda Software
www.imceda.com