Run a sample procedure call in a SSMS Query window with the 'Include Actual Execution Plan' option enabled. This will reveal the relative cost of each query within the stored procedure, and it will reveal the relative cost of each operation within each query.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho