One tool you can use is [SQLQueryStress][1]. For a quick start provide: the stored procedure the iterations and the number of threads. Then start the stress testing. Metrics like CPU seconds, logical reads, etc... will be shown.


  [1]: http://www.datamanipulation.net/sqlquerystress/