Open for Voting

Group individual statements/batches in stored procedures

It is nice to report on the execution characteristics of all the statements/batches in a stored procedure.  The individual hashes have to be selected.  We make this a little easier by our naming convention.  The first part of the name identifies the procedure and the last part contains the statement begin and end positions.  DPA should be able to identify all the statements that are included in a stored procedure and present that as an option to include in SQL reports.

Parents
  • Having DPA create the names, and allowing for grouping/versioning would be a huge help. I ended up coming up with a naming convention as well, but often run out of characters to adequately name an item. If the name field could be longer, or have a sub-field for the code section/version that would be helpful.

Comment
  • Having DPA create the names, and allowing for grouping/versioning would be a huge help. I ended up coming up with a naming convention as well, but often run out of characters to adequately name an item. If the name field could be longer, or have a sub-field for the code section/version that would be helpful.

Children
No Data