Very Computer

I have built up a new SQL7 Cluster, two Compaq 8500 with four processors
each, 2GB memory per server. Our developers have been writing applications
to run against the SQL server and like most new software it is running a bit
slow and the developers would like to lay the blame on the SQL7 cluster
server. Could anyone help in suggesting an application to benchmark the
server i.e. something that will give me a number to compare it against?

You can use something from quest software:
http://www.quest.com/benchmark_factory/
However your developer may say that doesn't apply to your case. The best thing is to use apple to compare apple. Use your new software to run on your old hardware and new one and see what happens. If it is on the same hardware, just new one with cluster, then need to check deeper. SQL cluster will not give you and performance boost nor performance drag, it should be same as a standalone server on the same hardware.

David Gao, MCSE, MCDBA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!