The ability to group instances into subgroups would improve the ability to browse through many instances For Example, being able to create the following structure: Home>Oracle>SubGroup1>Application1>Environment1>instancename
When analysing Page Life Expectancy issues it would be useful to see a list of queries that have large memory grants. It might be possible to show these under "Tuning Advisors" or in the "CURRENT" tab along with Highest Execution Time, Long Running Queries and Most Executed?
we have DB Instances in eastern, pacific, and UTC timezones. So when I look at a report (such as this), what timezone is this data and how does it relate to the database timezone. This page says that times are in the timezone of the DPA, but that in most of my cases is not the timezone of the DB Instance itself. So, now I…
1) It would be quite useful to have an option to see the current day superimposed/included on the typical day charts. Include toggle to show/hide
Being able to toggle the SQL status from the query drilldown page, for "Sending data" there is not much I can do - make my SELECT smaller or get a bigger network! Whereas on "Sorting result" I can easily make massive improvements by adding an index. Point 1 - If I could untick them all and just tick "sorting result", so…
DPA will tell me about how much time is spent waiting for memory allocations (although only aggregated with other memory and CPU waits), but that doesn't tell me which statements executing during a time period used the most buffer cache, which is generally what causes a Page Life Expectancy drop. If I drill into the…
Without being able to see the entire SQL statement, it is difficult or impossible to make appropriate index changes or to refer it to developers for refactoring. LINQ / Entity Framework frequently generates queries that are much longer than this.
Hi When looking at blockers I get the slide bar, would be good if the screen would resize so the slide bar is removed.
DPA on the driver it ships with doesn't work with MultiSubnetFailover=True. This feature would allow for this connection to work when it is needed for SQL Server Multi-Subnet Clustering. SQL Server Multi-Subnet Clustering (SQL Server) | Microsoft Docs
Hi, I want to apply SMS on my DAP application when alerting occurred on our database. i already opened case, but currently can't send direct from DAP "Case # - 00198859 SMS setup " any body have idea how we i can do that? Thanks.
It looks like you're new here. Sign in or register to get started.