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.

  • It kills my ability to report historically on a stored procedure. Every time it changes I have to give it a new name. Really need a way to group these as being the "same" despite SQL server thinking they're different.

  • I think grouping similar statements is an excellent idea.  It could be combined with filtering. a "Group Filter" could be defined as a like expression or regular expression. A checkbox on the Group filter "automatically add new statements" would set the group field on a new statement if it was blank and it matched a filter.  The Group Members within a time period would be excludable or includable as members of the group.  A Checkbox next to individual statements could help with that and then "Apply to Selected".  the net effect of this would be to set the "Group" field on the the dialog that allows the SQL Name to be edited.  Also, a new group name could be added or modified there. The trend display "Show Groups" option would aggregate statistics for a group of statements into a single bar block and sort them according to the total.  The entire group could be included or excluded from the trend display.  Include basically means exclude everything else.

  • FormerMember
    FormerMember in reply to brandon.hunt

    Thanks for the feedback Brandon.  We appreciate it!!!

    Kathy Gibbs

  • Having the ability to arbitrarily group hashes together and have DPA treat those as a single "query" would allow for this and also some other flexibility when you may want to group up statements that are all related.