Benchmarking database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Trevor Best

    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.
  • Simon Hayes

    #2
    Re: Benchmarking database


    "Trevor Best" <bouncer@localh ost> wrote in message
    news:8o4020lu7r nc51mm1urc0aghn 669tk46eo@4ax.c om...[color=blue]
    > 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.[/color]

    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


    Comment

    Working...