I would like to see some sort of monitoring and historical views of replication performance. I currently have a custom process that captures data from the Distribution database (MSlogreader_history and MSdistribution_history) and saves the information to a separate database. From there I import the data into Excel for my…
Requesting that the alert for Tablespace Freespace be updated to take into consideration Tablespaces with AutoExtend ON and Max size set.
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.
It looks like you're new here. Sign in or register to get started.