title: How do you measure the performance of a stored procedure?
body: <p>I'm using a version of SQL Server 2005 that does not support the profiler, trying to figure out how best to compare the performance of two stored procedures.  I've run the execution plan for each, but it's not clear to me which of the provided metrics I should be focusing on.  Do I go through and add up the various costs?  What's the best approach?</p>
  
  <p>Thanks in advance. </p>