So I disabled advice for a particular SQL statement a couple of months ago and now that I've tuned it to the point where it won't be the top SQL everyday, all day, I'd like to re-enable advise for it. Searches for the key words "SQL Advisor", "Disable", etc in the DPA documentation returns nothing on the topic.
The Advisors are under Trend Analysis, main page, bottom half of the window, first of three tabs (default config); Advisors, Resources and SQL Text. By clicking on "more..." to the right of a particular piece of advice you'll be taken to a new screen with charts and tuning suggestions. In the top right corner, to the left of the envelope used to email the report is a ban symbol. To disable the advise I want to reinstate I click that ban symbol. Now I'd like to enable it again.
Any ideas?
