Benchmarking a server

[Trevor Best]

is there a freebie utility/database that could benchmark a sqlserver?
Would like to try out different disk configurations (raid, swapfile
location, cluster size, etc) for getting the best results.

Or would I be better off writing a load script to stress the server on
a copy of my own database?

--
A)bort, R)etry, I)nfluence with large hammer.

[Simon Hayes]

Trevor Best <bouncer@localhost> wrote in message news:<t8********************************@4ax.com>. ..

is there a freebie utility/database that could benchmark a sqlserver?
Would like to try out different disk configurations (raid, swapfile
location, cluster size, etc) for getting the best results.

Or would I be better off writing a load script to stress the server on
a copy of my own database?

Depending on what you want to test, this is one possible tool:

http://support.microsoft.com/default...&Product=sql2k

The SQL 2000 Resource Kit has a tool called DB Hammer (or something
similar) which creates multiple client connections.

But if you want to test how fast various processes (meaning stored
procedure or application code) run, then the best test will be to use
your own test database, because then you know that you're testing
something which is meaningful for you.

Simon