The most recent content from our members.
To receive updates on the DPA roadmap, JOIN thwack and BOOKMARK this page Here is a partial list of the things we are currently working on. Your comments and feedback are always welcome and have been vital in shaping Database Performance Analyzer into the product it is today. We are always listening, so please forward your…
Since databasses report missing index data, it would be nice to see this in DPA so we can associate the largest wait time sql with missing index data. Provide analysis about current indexes on a table Show unused or underused indexes. 10/12/16 - changed header and description to reflect the feature better This feature has…
I can see how I can compare wait stats from time periods (e.g. Wednesday on Server1 from 1PM-2PM with Thursday on the same server at the same time) but I cannot find a way to do this with resources. As an example, It would be helpful to be able to view what the CPU usage was yesterday between 8 and 9 AM so I can compare…
Next week I'm flying down to Orlando, Florida to spend a week filling my brain with all things MS: Ignite. I'm especially excited about this trip because it is one of the first times as a Head Geek that I'm traveling to a server- and application-centric show. To be sure, we get our fair share of questions on SAM, DPA, SRM,…
Allow users to quickly see the server configuration, including hardware specifications for the database server.
Enhance the Oracle explain plan so it contains all the useful data (as in Ignite 6.5).I would like to see functionality similar to what dbms_xplan offers - so predicate information and notes in addition to a better-formatted execution plan. Cost and cardinality estimates (with an option for pulling actual execution…
The current Top SQL report averages usage of queries over the entire period of the request graph. This can lead to some misleading trend information. Consider the situation where a heavily used Top SQL query has a new version created and an application update switches most of the usage to the new version. The day after the…
This is an action script for managing Solarwinds DPA as a resource in Oracle Grid Infrastructure (CRS). Add this script on a shared directory available to all nodes of your RAC cluster and make it executable for the database owner, then add a resource for Solarwinds with: $CRS_HOME/bin/crsctl add resource solarwinds_DPA…
I logged into DPA with the same login I always use, and although the names of the SQL statements were still there, it prompted me to watch the videos again and all the custom chart displays I had were gone...in fact, just a few OS and VM charts are there, no SQL charts. Any reason this would happen? Has this randomly…
If I am running a release, I don't want the ignite monitor to be blacked out but I would like to be able to blackout specific alerts. This would also help with development environments where I may want to know if the database is down after hours but have all other alerts be blacked out.
It looks like you're new here. Sign in or register to get started.