question

Background, we're getting performance issues on this stored proc (that I didn't write). The proc: 1. Is passed two variables, an id (int) and a table-type variable 2. It updates a table, changing the sort order in rows matching the table variable and the ID param, then 3. Inserts the rows that aren't there already To troubleshoot it, I want to capture the contents of the table type variable in an extended events session. My current XE session captures: 1. the rpc_completed (filtered on the name of the stored proc I'm calling, "DocumentComponentVariables") event 2. the sp_statement_completed (where the statement contains the word "document") 3. the qn_parameter_table (no filter) events, but it looks like I'm only capturing the scalar parameters. But I don't see anything about what's in the table variable passed into the proc, just the order id param. Are these the right events to use? Do I need to add other columns or something? Or is this harder than it seems?