we will be moving our sql instance to a new san setup. and i have a week to test functionality.
i plan on using SQLIOSim to stress test the hardware setup,
When i have sql actually setup and a test application server pointing at it, i will then test various steps that were before taking a long time to complete/locking sql such as invoicing orders and despatching orders.
but can anyone advise how i could simulate 100+ users on the system? and have them actually query the db etc