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