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…