title: Quickest way to identify most used Stored Procedure variation in SQL Server 2005
body: <p>I am trying to figure out if there's a way to identify a "version" of a SP that gets called the most. I have an SP that gets called with a bunch of different parameters. I know that the SP is causing some issues and trying to pin point the problem. Besides capturing calls to the SP and manually sifting through the results, is it possible to use the profiler to group SP calls by supplied parameters?</p>
  
  <p>I'm not a DB(A/E), just a web dev, so any hints/points in the right direction will be helpful. Thanks!</p>
  
  <p>EDIT: Recompiling the SP does not help much.</p>