Sunday, February 19, 2012

Benchmarking database

Is there a ready made database for benchmarking a server's performance
to see what tweaks external to SQL Server will have an effect?

--
A)bort, R)etry, I)nfluence with large hammer."Trevor Best" <bouncer@.localhost> wrote in message
news:8o4020lu7rnc51mm1urc0aghn669tk46eo@.4ax.com...
> Is there a ready made database for benchmarking a server's performance
> to see what tweaks external to SQL Server will have an effect?
> --
> A)bort, R)etry, I)nfluence with large hammer.

In principle, you could use any database that you know how to recreate
easily, eg. Northwind. However I would guess that most people would prefer
to benchmark and performance test using a test database that looks like (or
is a copy of) their production database, in order to make the test
meaningful for their environment.

Simon

No comments:

Post a Comment