We frequently get high-severity "Blocking process" alerts via email for a SSRS database that I'd like to ignore. We sometimes get so many alerts that the new SQL Monitor sends, "You've received more than 30 of these alerts in the past 24 hours so we're going to stop sending them for a while." Unfortunately the alerts caused by the SSRS database mean our Inbox is full of noise and we miss our important application database alerts.
Please add the ability to filter which User/Application/Database cause these alerts to be raised, similar to some other alerts that support Regular Expression filters.1 vote
Generate scheduled reports on every added instance.
For example: A weekly health report or Weekly long running query report or monthly Database growth report etc.3 votes
The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.
Issue submitting first time. if duplicate please close.3 votes
On that alert (fragmented index), you see a table name. It would be helpful to see the schema to which that table belongs.
Medium Fragmented indexes
Raised on: XXXXXXXX > RedGateMonitor
Time raised: 26 Jun 2016 1:00 AM (UTC-04)
Database name: RedGateMonitor
Total number of indexes: 332
Indexes above fragmentation threshold: 3
Indexes last checked: 26 Jun 2016 1:00 AM
Index Table name Fragmentation(%) No. of pages
Cluster_SqlServer_ServerWaits_UnstableSamples_Id_CollectionDate Cluster_SqlServer_ServerWaits_UnstableSamples 96 1175
Cluster_SqlServer_SqlProcess_UnstableSamples_Id_CollectionDate Cluster_SqlServer_SqlProcess_UnstableSamples 96 3288
Cluster_SqlServer_TopQueries_UnstableSamples_Id_CollectionDate Cluster_SqlServer_TopQueries_UnstableSamples 99 1758
Dashboard element sorting should be fixed preferably in alphabetical order. The whole idea of a dashboard should be to provide an at a glance view of the state of your server set. When you change the order from servername when all is green to some other order because something has triggered an alert on a server I have to spend extra time figuring out which server has an issue because the sort order has changed.1 vote
I've love the ability to integrate SQL monitor with Power Bi for building dashboards of analysis graphs. Since Power BI is offering a powerful way to setup dashboards with metrics users/managers care about this would be a great way to enhance many analytical report options by outsourcing the creation of those to users more and more, and offering the integration with power bi to make it easy to do.
SQL Sentry offers an integration with their cloud product to work with their metrics and Power BI in case you want to evaluate how it might be used. https://www.sqlsentry.com/Company/News-Article/20150505-power-bi-content-pack-sql-sentry7 votes
Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.
I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.1 vote
lookups and the index that didn't have the columns include
Report the issues based on impact number1 vote
Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?3 votes
The new global dashboard is great but it is harder to read at a glance then the old dashboard. Please add in a classic dashboard option.3 votes
The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under *normal* circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.
Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).
Those new cards look very nice, BUT, they do not show anything about the alerts raised on the instance!
That's a shocking omission, IMO.
Please add something that shows the alerts, like the old Overview page did, like counts by severity, with colors!3 votes
The write-up about the 5.2 Alias feature waxes almost lyrical about how much we would like it...
Until you open the Analysis page and see the old names - in my case unintelligible I.P. addresses. Sad, very sad...
Please make Aliases utterly pervasive, as in Analysis, Configuration => Monitored Servers (I.P. list), emails (just to make sure they're not overlooked).3 votes
We have already started a piece of works that attempts to plug a few gaps where aliases are not be displayed in various places in the UI.
Click on CPU part of the server block on global dashboard (version 5.2) leads me to serveroverview instead of graph
I would suspect to go to the graph (analysis tab) after I click on the CPU part of a serverblock (in Global Dashboard), instead of the server overview1 vote
As an administrator, I want to be able to select one or more groups for displaying on the new global dashboard (added in version 5.2). Now you see all groups or one group.1 vote
Long-running query alerts
Example: Creation of ability for you to filter the queries it alerts on based on a regular expression
Possible closely related feature request:
Display deadlocks alerts in a more graphical and easier to understand way.6 votes
I would like to keep production server performance data for a month or more but the dev server data can be purged after a couple of weeks.3 votes
Add the ability to display the results of a query when generating an alert from a custom metric3 votes
I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.1 vote
- Don't see your idea?