Save 'Analysis' filters as favourite
It would be very helpful if I could save 'Analysis' graph after I select multiple counters. So the next time I could just click the Name and bring back the multi-counter analysis. In fact redgate can have some pre-canned favorites for Memory/IO counters etc. and others can contribute to different combinations of counters.
In SQL Monitor 5.0.2 we have added the navigational state of the Alert inbox to the URL string, meaning that Analysis filters can now be bookmarked and even shared. If you use the “As above” function, reapplying the same set of metrics to a different server is a single-click operation.
Morten Nilsen commented
I am not sure how the navigational state of the alert inbox relates to the analysis graphs, but if you say so..
SQL Monitor 5 has been release. A full UI refresh, but still no save button. This really would be a simple feature to add (I am a .NET developer, it really is simple to take an existing variable and persist it) that would be welcomed by every single SQL Monitor User.
Please take note red gate, my organisation has bought SQL Monitor licences (multiple each) for each of its sister companies. This is the only major feature we feel is missing.
Snorri Kristjansson commented
This feature is a MUST! It's silly not to be able to save your selection.
Seriously redgate. This is a tool that costs a not inconsiderable sum. Espcially if you monitor a large number of servers.
This seems like such a simple thing to implement. From the comments that Daniel has made we can tell that SqlMonitor already stores the selected filters in session. It would not be hard to take the AnalysisGraphState session variable and store it in the database! A simple drop down of stored states along side the "Compare Baseline" button (right align it, make it look nice) to reload the state and refresh the page would do the job......
"Mandatory" is appropriate (@Janet R), and "Critical" (@Wayne Brantley).
I have fewer servers than Janet (19) but to have to build the list for CPU Usage over the last 28 days every time I want it is a half-hour investment I'm not prepared to make! Yes, I read the workarounds. Do I want to have to edit that when an I.P. is changed, or a new customer is added? Nope... I expect the tool to have the ability to save any Analysis in a folder structure and be smart enough to recognize its own old syntax and convert it to new, telling me it has done so, and chive on!
56 votes and counting. When will "Enough" be achieved? Happy 2nd anniversary of Daniel's comment is rapidly approaching...
Janet R commented
I would say this is a mandatory for the tool to be really useful. Without this it is extremely frustrating having to set up each time. With 50 servers to monitor it would be unusable the way it is currently.
SQL Monitor allows you to run several customisable reports but there is no way currently to have a customizable dashboard which will allow you to pick the metrics you want to see on one page. This would benefit most people and if you could develop it so that you can create multiple dash boards for us on different screens even better especially if like us you have wall screens for display stats.
for the moment I am using the iMacros chome extension; but still not great (especially if I view the monitors from another machine)
agree that this is really a required feature. Monitoring screens that revert to just the cpu values are so unhelpfull.
Wayne Brantley commented
This is critical. Also, these saved items should be able to go on a user defined dashboard.
Glad it works! For automation, I'd use something like Greasemonkey for Firefox, or Tamplermonkey for Chrome. Here's a userscript that renders a selector for predefined templates into the SQL Monitor UI:
Still no timeline for you, I'm afraid
Your workaround does work, however I'm going to need to find a way to automate this and automatically refresh the graphs. Please share any timeline you may have on this enhancement. This will determine whether we wait, develop something internally or look into other solutions.
No further updates as yet to what I said below - we're still working to get this into our schedule.
I've looked into temporary workarounds that you can use today, what you can do (rather than manually clicking together your report each day) is to store the SessionState value AnalysisGraphState and paste it. Here are the instructions for Chrome:
1. Go to the analysis page and bring it into the shape that you want to store
2. Open the Chrome Developer Tools, [Ctrl][Shift][i]
3. Go to the tab "Resources" and drill into "Session Storage" -> <yoursqlmonitorui>
4. You'll see a grid where one row says AnalysisGraphState. Rightclick on the VALUE in that row and choose "Edit value"
5. Hit [Ctrl][c] to copy the value, and store it anywhere (eg in a text file)
6. When coming back to the analysis page the next day, repeat steps 2 to 4 but paste ([Ctrl][v]) the string you stored into the VALUE field, hit [Enter] and Refresh the page. Now your analysis graph should show you the correct selection of graphs.
Let me know if that helps to tide you over until we've implemented a template storage feature.
Are there any updates on this? Is it planned to have the favorite graphs addressable in the URL?
It would be extremely beneficial for us to see our favorite graph on the big screen. As out development team puts out new releases, they need to be aware of how their changes are affecting performance, good and bad. If I could put all my votes to this, I would.
That must have been extremely grating! Saving Analysis views is on our backlog along with a few other high-priority items, but I couldn't promise you a time frame - there are a lot of different edge cases to consider! But we understand that the lack of this feature is holding the Analysis page back and is causing people a lot of grief. We're on it!
Any news on this? It's is my most hated thing with SQLMonitor. Especially as we had a powercut last night and my monitoring PC (were I show the screens) died. So this morning I had to open four screens worth of browser windows and reset the monitor counters for each one!!
Any news on this?
Ignacio Jose commented
The Saving of user defined analysis graphs (UDAG) would save me a lot of time as I can then apply it the same save UDAG on any of my databases or SQL Server instances. It's painful having to remember each counter every time we need to review the current or historical status of an instance. Please give it more priority.
brendo bongers commented
Ability to save selection of the servers and counters.
I.e. for server SQL1, SQL2, SQL2, counters PLE and batches/second.
I.e. for server SQL1, SQL2, SQL2, IO, read latency, write latency.
Currently the selection of servers and counters/metrics has to be repeated every time.
On the Analysis tab it is possible to make a lot of changes to the UI while investigating a period of time and when working with a distributed team it is difficult to get team members on the same view without a lot of instruction and description of what to click.
Having a 'send link' function that lets someone jump straight to the same view (selected metrics, period of time, instance, server, etc) with one click would make for much simpler collaboration