The most recent content from our members.
When looking at the Trends for a day for a SQL Server instance, the Advisors tab shows the top 5 entries for the latest hour, and if I click on the link at the top, it will display the top 5 for each hour and for the day so far. How can I get it to display more than 5 for each period?
The free Dell Spotlight Essentials provides information similar to the DPA Advisors for each instance, but much more comprehensive and detailed: Missing Indexes, Security Policies [Guest user and password policies], Best Practices [use of Select *, Optimization Hints, and Set Rowcount], Recovery Model, Backups, Ad Hoc…
Is there a way to view which queries are excluded from Advisor analysis? I've excluded some by drilling into the query information from the Advisors tab and am just wondering how i can view exlusions and/or add them back in if i needed to, i'm pretty sure it'll be an obvious option somewhere but i just can't see it at the…
It looks like you're new here. Sign in or register to get started.