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.
Wond work.
Pathetic database. WAY too small for real word testing. Waht you want to test in particular?
There are tests, but they require a lot of hardware.
In general, I do a good SQLIO test, plus you can do some cpu based tests. That is about it.
If you are just looking to get some baseline stats on your servers, I would recommend starting with Perfmon counters. Brent Ozar has an excellent tutorial here: SQL Server Perfmon Counters Tutorial
These stats are great for identifying bottlenecks, trending usage (when you run multiple times), identifying servers you may wish to consolidate, etc.