How to test TempDB performance?
- by Matt Penner
I'm getting some conflicting advice on how to best configure our SQL storage with our current SAN. I would like to do some of my own performance testing with a few different configurations.
I looked at using SQLIOSim but it doesn't seem to simulate TempDB.
Can anyone recommend a way to test data, log and TempDB performance?
What about using a SQL profiler trace file from our production system? How would I use This to run against my test server?
Thanks,
Matt