Database benchmark

We are in the process of moving our databases from one server to another and
want to know what are some best to capture some performance benchmarks of
existing systems and compare it with the migrated database on the new server
so that at the end of the day performace is at best similar or better on the
new hardware.
Thanks
Hi Hassan
The obvious ones are to use perfmon and SQL Profiler over a variety of
periods/tests and produce comparative graphs/figures. You may also want to
replay profiles as a backend test.
If you are using a tool such as load runner or Visual Studio Team Test they
will collect their own stats that could be use to give a front end view.
As you are moving to a new system you should get a baseline using SQLIOSim
to make sure there are no issues with the new environment and have values
that you can use to compare against for future tests.
John
"Hassan" wrote:

> We are in the process of moving our databases from one server to another and
> want to know what are some best to capture some performance benchmarks of
> existing systems and compare it with the migrated database on the new server
> so that at the end of the day performace is at best similar or better on the
> new hardware.
> Thanks
>
>