How to get statistics for specific stored procedure that might not be in “Top Procedure” list?
The top procedures information is provided in a table, which is sorted by the Avg Duration (ms) column. The Top Procedures table has the same columns as the Top SQL Table. In addition, the SQL Text column provides a navigation tree for each top procedure SQL statement, which contains the procedure name data. Expanding the root procedure node lists the line numbers containing the SQL statements in the procedure for which the execution statistics are available.
The top procedures tab information is limited to the top performance affecting procedures. The number of these procedures appearing a managed by the agent properties.
There are two means in addition to using the Top Procedures filter (which would be applicable for procedures already appearing in the list) that you may be able use to identify specific procedure not currently seen in the Top Procedures list.