What do you like best?
Ability to see current activities from multiple aspect/view is best thing for me.
When there is a an issue with any Server and need to quickly narrow down to the right place of root cause this is a tool allows me to focus on right places and remove all sorts of noise from data.
Tagging and Annotation is another great feature.
Ability to see the historical details/plan/ is very helpful while working on Query performance.
What do you dislike?
1) I can not search the specific text on any of the sub screen when drill down to session/sql/machine etc... tabs.
2) there is only one way to search the SQL by actual text is "SQL TEXT" and that is not complete. it would be good to have some place we can search specific sql I am looking for.
3) any adhoc sql/queries are not grouped to gather (like procedures) and hence its historical details can not be viewed. it will be good to have some way of connecting those adhoc sqls using same plan and being able to generate execution history.
4) on the same adhoc plan tab, for any given plan we have to drill down each sql manually one by one. it would be god to have some kind of summary popup/tool-tip when we hover over the plan in DPA.
What business problems are you solving with the product? What benefits have you realized?
It is a go to tool for me in my current work place for finding/analyzing/solving any type of SQL DB issues.
it removes the waste from screen speed up the process that increases the over all cycle time for resolving any DB issue.