sqlquery-101401 (5/7/2012)
what is the best way to get the production IOPs requirement , we have ETL that runs for an hour and trying to get new H/w , what is the best way to know the IOPs requirement with current production load, will disk transfer/s will suffice or any better way?
that is what I used.
If your in a SAN\NAS environment there will be additional utilities that capture this info as well.
GAJ
Gregory A Jackson MBA, CSM