We have several production SQL servers, some physical, some virtual. I would really like some generic scripts that I could run against each maybe using AdventureWorks to stress test them and compare the performance.
Does anyone know of anything which is commonly used? I understand that different types of load (e.g OLTP, DW) require different hardware but I need something to get started in order to give some accurate comparisons between the different environments.