I would like to see a better dashboard view
One where I can see a cumulative report of ALL of the instances being monitored with average totals for cpu/memory/disks utilization, across them all. Average success to failure ratios for Scheduled jobs (backups).
We implemented a new global dashboard in the 5.2 release, which shows an overview of all instances on one screen.
Daniel Robertson commented
It'd be great if more than just Operations and the DBA's got anything of use out of the dashboard. The development teams would benefit greatly from feedback on how certain aspects of their database / jobs are doing. e.g. Deadlocks, failed jobs and job performance. Development and product teams will have a greater benefit from visibility of this.
Could an ability to create users beyond Admin, Standard and read only be created? e.g. custom read only users that could be assigned visibility of certain servers and certain alerts / metrics. But also have a dashboard layout that is less noisy and more relevant to a product team. Something that would be able to give a top level view of everything in one screen that could be presented on a team TV screen.
This would not only help take some pain away from operations, but also provide some useful feedback directly to product teams to help them make better decisions on how to improve their stuff.
Thomas Rushton commented
...and allow for the sort order to be part of the URL.
Scenario: we want to put up a view of the SQL Monitor overview page on a large screen in the Ops area. Currently, the order of the servers in the display is alphabetical by server name, which means that you might not be seeing the problems. We would like to be able to give the ops board a URL to display the list sorted by Status (High first, then Medium, Low, OK, Unlicensed).
However, the DBAs working may want to sort by server name - after all, it's easier to find the servers for which they are responsible. Indeed, there are UserVoice suggestions out there to allow for filtering.
Some DBAs may want to sort by the number of outstanding issues - either to hit the main offenders quickly, or to knock off those with a single alert and get them out of the way.
On the Alert Inbox page, again, allow sorting of the alerts to aid with processing.
Janet R commented
As it says... if I am using SQL monitor, it is because I want primarily to monitor SQL instances, not servers...
It seems to me that the first page you go to should really be about monitoring SQL and the health of instances logged - or a priority instance, and not overall server stats. Server stats are relevant, but in my experience, not the first thing I look at if a SQL instance is struggling
Thanks for the suggestion and for providing an example of why this feature would be useful for you.
John Clark commented
I have the Global overview up on a giant monitor in the NOC... so I get a deadlock and now on the big screen the prod server is critical... the deadlock gets a victim and sql clears it... Until I go in and physically clear the alert the status shows as critical and everyone is really EXCITED... but seriously at this point now there is nothing wrong with this server... It needs to show that it is now ok on the next refresh but still have the uncleared alert in the uncleared count..
Very similar to New Relic, which provides a public iframe embed link for many of the graphs. This allows for populating a 3rd party "dashboard" with pertinent SQL Monitor graphs.
Here is a sample URL (does not resolve) generated from a button on the GUI of a graph on NR.
<iframe src="https://rpm.newrelic.com/public/charts/GUID" width="500" height="300" scrolling="no" frameborder="no"></iframe>
Thanks Ian for your suggestion.
Ian Brink commented
We would like to be able to embed part of the "Global View" page into an Iframe. Please refer to attached screen grab of what we would like. This will allow us to display overviews on monitoring screens located throughout our offices.
This will assist in providing a better global overview to management
Thank you for your feedback Steve.
I believe it would be very useful if you could implement a way to have specific users or roles default to a high-level / executive summary type page. For example, for the purpose of providing a meeting brief, upon login a user would only be able to view the Analysis tab and view a particular metric as opposed to having to log in, navigate to a specific tab, and manually select the data metrics they wish to view. Being able to customize these access levels would be fantastic....