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,…
If I want to set up a blackout period for a specific alert from 2am - 4am every night, I have to create seven separate blackouts.
Hello! I was showing a DPA support engineer the differences between DPA blackouts and Orion maintenance schedules. It would be awesome to see a recurring blackout option showing a calendar with specific date and time ranges. Support case for this was: 00584719. I looked around on Thwack, but really did not see anything. Hi…
It looks like you're new here. Sign in or register to get started.