It would be great if we can monitor HANA databases using DPA Module.
By adding an indicator check box where you could review each Tuning Advisor {Index/Query/Table} and then check which have been addressed or reviewed, this would allow for focus on any new items as not all items are quick fixes and may require a future deployment to address. The thought here is if you have reviewed and…
Although we can pick an hour and see details of all blocks, it would be handy to have a report to see what are the top blockers in the system. Root blockers don't usually appear on the waits page due to how they work. If a root blocker running for 2 mins blocks 10 executions of a different sproc, each lasting 30 seconds…
Within Tuning Advisors it would be nice to be able to filter by database like you can the day. The Table Tuning advisors already shows which database the table is in. I, as an app dev, want to hide all the ones that are not part of my application so I can concentrate on the ones that affect me. I just want to be able to…
Add avg time per execute to the “Most executed” view, And amount of execs to Long Running (Average) view. This would give a clear indication on how many times a long running query has been executed (in the Long Running (Average)) tab. Same for how long the queries take where there are a lot of executions. (Most executed…
We would love to see support for Microsoft's Azure Synapse product. There is currently no good way we've found to monitor performance the way you can with on-prem or Azure SQL. Understanding that Synapse databases don't support all of the same features and functionality, it would be fantastic to include those in our…
It will be benefitable if the SQL Deadlocks alerts is included in the DPA main dashboard. Having the alert on the main dashboard gets a faster respond then the email alerts. When the Deadlock alerts is discover, by clicking the alerts takes one to the SQL server source and the detail of the deadlock.
It would be nice if the SQL text window (or even other spots) had a CopyToClipboard option. I often copy/paste to send to another developer and its somewhat annoying to always roundtrip through notepad to remove the html.
DPA has a built in alert for SQL server called "Windows Service Not Running - SQL Server". This worked well in the past, however, Microsoft changed the Service Name of the SSRS service from "ReportServer" to "SQLServerReportingServices" when they released SQL 2019. This has meant that to have a group in DPA of your servers…
I can use SQL Profiler and view SQL Text with parameters. When we have an issue a lot of times it is not the query but rather the data inside the query is corrupt or too large. Without seeing the stored procedure parameters we cannot track down which record to look at. When you have no privacy concerns like medical,…
It looks like you're new here. Sign in or register to get started.