question

Are there two timestamp columns in the table? If not, could you add a secondary one with a default constraint to capture when the record is actually inserted?

I'm not sure I understand. You want to measure how long a record takes to be inserted into a table? Also, measuring RPC:Completed might not give you what you want. That's going to measure a remote procedure call in other-words when a procedure has completed. You could insert multiple records within a single procedure call. Depending on how the procedure is written, you could potentially use sp:stmtcompleted assuming you are inserting records in a RBAR fashion.

each record has a timestamp included that is generated by the application when a new record is generated. but there is some delay between this timestamp and the effective time of insert (start) so i need to compare the starttime of insert and the timestamp column.