title: TSQL Dynamically determine parameter list for SP/Function
body: <p>I want to write a generic logging snip-it into a collection of stored procedures. I'm writing this to have a quantitative measure of our front-user user experience as I know which SP's are used by the front-end software and how they are used. I'd like to use this to gather a base-line before we commence performance tunning and afterward to show the outcome of tunning. </p>
  
  <p><strong>I can dynamically pull the object name from @@PROCID, but I've been unable to determine all parameters passed and their values. Anyone know if this is possible?</strong>   </p>
  
  <p>EDIT: marking my response as the answer to close this question. Appears extended events are the least intrusive item to performance, however i'm not sure if there is any substantial difference between minimal profiling and extended events. Perhaps something for a rainy day.</p>