At this moment I do a lot of vitalizing with VMware ESX and the first question I always get from my customers: What is the impact on a SQL-Server database on a Virtual machine compared with a Physical machine.
Using SQL-Data Generator to import 1.000.000 records in 25 tables give a nice stress on the server. Only, I can’t really compare it as I can’t see exact how much time it takes to finish the job. I like to suggest to supply a start and finish time so we also can use SQL Data Compare to test server speed without the need of sophisticated testing tools
I already get an possible work around from your engineers with an example using some command line commands, but I prefer to have timer functionality as part of the product itself Smile