Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL Server Tools - Recomendations On Stress Testing and I/O Testing On New SQL Server RE: SQL Server Tools - Recomendations On Stress Testing and I/O Testing On New SQL Server

  • August 20, 2012 at 2:07 pm

    #1527851

    YSLGuru (8/20/2012)

    Grant Fritchey (8/20/2012)

    Actually, yeah, looks like 2005 might be out. That stinks. Never noticed that before.

    Any suggestions on what to do? I need to do some comparison testing aginst the new server to see how it fares against the current DB server, to see if the same workload occurring now will run better on the new system. I was going to run a non-gui trace (server side trace) and then play it back on the new server but I'm thinking here has to be a better way to do this. I'd prefer not to pays lots of moeny to do this but if nothing else I woudl think one of the SQL sofwtare Toools vendors woudl have come up with something like this, that lets you see how the same workload on one server will do on another. Make sense?

    BTW - I have and did run SQL Imulator but thats it so far.

    Thanks

    First, I think you server side trace ides is better because it's going to behave like the actual database engine.

    That being said there are tools that will just thrash the disks if that's what you need. As Grant already mentioned, SQLIO basically did just that (a bunch of reads and writes with files of a size you specified).

    Take a look at PassMark's BurnInTest suite. It has disk tests built in. The standard and pro editions are both pretty reasonably priced.