new2nz: In some cases it can take > 24hrs to load the data, and then there is overnight processing of about 1-x hours. 

And in the past we would just do that, however we want to be able to give them indications on how particular hardware will likely perform.

An SQL Server performance benchmark will fill a lot of that need. Microsoft provide one or two, and there are third party ones as well.