If you’ve been working with Azure Monitor or following along on our Azure Monitor Learning Path series – you may have realized that data visualization in Azure Monitor can sometimes be very confusing and decentralized. You have to click through a lot of different wizards, select from the visualization options provided (queries/workbooks/dashboards, etc) and it is on the whole a time-consuming process.
SquaredUp can simplify it all for you!
SquaredUp for Azure lets you create a bunch of different useful dashboards, very easily, and from a single console. SquaredUp's dashboarding tool also offers some cool features that triumph over the native options in the Azure Portal. But hey, don’t just take my word for it. Let me show you what I mean. 😊
We’ll start by creating a few simple dashboards – first in Azure Monitor, then in SquaredUp for Azure. Then we will compare our overall experience in terms of ease of creation, time spent, data visualization options, shareability, etc. I’ll start with a dashboard for Virtual Machines in this article, and move on to Application Insights in Part 2 and Cost Management in Part 3. Sound fun?
Let’s get into it!
- Azure Monitor
Azure portal vs SquaredUp dashboards
(Part 1 – VM Insights)
Task: Create a dashboard to show a comprehensive all-around view of my virtual machines hosted in Azure as well as on-prem VMs connected to Azure Log Analytics workspaces. It should show all my VM’s – with their (1) KPI counters, (2) health status, and their (3) cost analysis.
Let’s start with Azure Monitor and then move on to SquaredUp.
Like previously mentioned, there is no central console for dashboards here. So let’s try a few different ways.
First, let’s hit the “Dashboard” button on the home page:
I’m presented with a selection of tiles.
I see there’s a “metrics chart” tile to pick from. Let’s select it, that’ll come in handy for my KPIs.
Okay, now I’ll have to hit the “Done customizing” button on top and configure each metric tile separately.
Next, I’ll select my scope. Our task was to build a dashboard for all VMs in a subscription – so that’s what I shall choose here:
Okay – we’ve got a problem. I can’t seem to select multiple VMs at once here. Only one VM at a time. Uh-oh. Guess we’ll have to go one by one then.
So, let me add one VM in the Percentage CPU graph:
To add another server now, I’m going to have to click “Add metric” and repeat the same process all over again.
10 minutes later and I’ve only managed to get 3 of my VM’s in. Now imagine performing this series of steps potentially hundreds or even thousands of times depending on the number of VM’s you have. AND this is just for ONE of the metrics. *shudders*
Surely there’s a better way of doing this, you might be thinking. Let’s try workbooks. Browse into Azure Monitor > Workbooks:
Let’s create a new workbook. You can make a dashboard with a parameter, query, metric, etc. For now, let’s add a metric.
Okay, that’s much better! I can select multiple VMs here.
So after selecting a few VM’s (one check box at a time), I selected the metric I want to show by clicking on the “Add metric” button. I then saved this workbook, and pinned this view to my dashboard.
Let’s see how my dashboard is coming along.
Okay, let’s say we’ve “completed” the KPI display part of the dashboard. Though as you can imagine, depending on your need, you may need a bunch more metrics and a lot more VMs so you’ll have to go through that process that many times.
Onto the next task – a quick list of my VM’s in a subscription with their health status (say running/switched off status).
On the Dashboard service from the home page, there doesn’t seem to be any tile that can help me with this.
I found this pre-built workbook in the library called “Agent Health”, let’s see what it does.
Hmm…okay that looks useful. But a little more investigation reveals:
- I can’t drill down into all of these machines, clicking on the Azure resource just drops me into the resource.
- This is only for the machines with an agent installed, so my machines with no agent aren’t listed.
- It is made with a super complicated KQL (see below), so if I were to make any changes in the view, I’d have to wrestle with that query which honestly, is a little beyond my expertise. I’m sure some of you can relate!
Anyway, let’s pin this view to the dashboard for now.
Now, that dashboard doesn’t look optimized for display (with all the scroll bars and blank space), but you may be able to fix some of that by moving things around and adjusting the size.
Okay – last thing left to do now is the cost analysis! Let’s add that.
As always, starting from the Dashboard service – didn’t find anything.
Then moving on the Workbooks – again, didn’t find anything I could use.
Lastly, I’m trying the dedicated cost analysis service in Azure, “Cost Management”. Let’s see if I can do something from there.
I see a “Cost analysis” tab on the left, and a few filters to narrow down the results.
I changed the scope to the subscription I wanted, and added a filter to only show the virtual machines.
So I see it’s giving me a view of the combined cost of all VMs in the subscription. I was looking forward to see a VM-wise breakdown but this isn’t too bad, I guess.
If I click on “Cost by resource”, and then apply the filters again, I get a view like this:
Not very dashboard-like, but that’ll do.
After pinning that to the dashboard, this is the final result:
Phew! Done! I’ve completed the task. But mind you – I skipped adding many things in the process simply because it was too repetitive and time-consuming (such as adding more resources, more metrics, etc.).
So having done all that, here’s my verdict:
- There are many, many, many wizards to traverse, and on average, 15 clicks per wizard.
- That took a looong time.
- It required a fairly deep understanding of the portal.
- Finding things was not very easy.
- Too many options!
- These dashboards are more like “shortcuts”. They don’t offer much drill-down, if at all.
- End result is a “make-it-work-somehow” kind of display, without many good dashboard-like features.
Logging into SquaredUp, I can see the big old “Create dashboard” button – we can get straight to the task!
After hitting the + button, I’m presented with a bunch of tiles.
I’ll select the Status tile, since one of my tasks is to display the status of the VM.
As you can see, there are different formats we can use to display the status. Let’s choose the block format.
Following that, we select our scope:
Now this was VERY helpful. All I had to do was choose the subscription and simply filter my resources by their type! And that’s about it – I now have my status view ready.
You may remember, the one we did in Azure using workbook was only for VMs with agent. This one includes all the VMs. See the OPP-ORION VM in red above? That’s missing in the Azure dashboard.
Cool, task one complete!
Next up, the KPI.
Simply hit the + sign between the two orange dotted lines on the same page, and the panel for tile selection is presented again.
This time, I’ll choose the Performance tile.
There are a few formats to choose from – I’ll select the line graph.
Again, I chose the same scope.
Now as soon as I click the box under the metric section, I’m presented with the platform metrics concerning that resource type.
I’ll choose the Percentage CPU metric as we did in the portal.
And the graph has already rendered! Further down in options, I can choose to see only the top N results, so my graph isn’t too cluttered. I have chosen to view only 5.
And we’re done! That’s one metric down. Onto the next KPI.
I want to position this beside the other KPI, in the same row, so it’s easy to see. SquaredUp lets me do that very easily.
After dragging and adjusting the length of your new tile, configure it the same way as the last one, but with “Disk Read Operations/Sec” metric this time.
5 minutes on, and I’m done.
Task 2 – complete!
Onto the last task, cost analysis broken down per VM.
Hitting the orange + button at the bottom again, I’m presented with the tile selection panel. And one of them says Cost Management. Let’s see what it can do.
As usual, a few formats to choose from. That Treemap option sounds really fancy!
3 minutes into the future, and we’re done.
Sweet! This is much better. The boxes are even sized differently according to the difference in cost, so you can tell where your money is going at a glance.
We can also use another tile called the Matrix tile that basically combines all this in a single view.
And just like that, my dashboard is all done and ready to go!
Now that is one cool dashboard. But wait, that’s not all! It gets even better. You can actually drill down into these resources by clicking on them. Click on one, and you then jump into another set of visualizations – to what we call “perspectives”. They’re scoped to show the data that’s relevant to that particular resource, not just for Azure, but also for external resources. You can see on the top there are multiple perspectives, such as Insights, alerts on that resource, ServiceNow incidents on that resource and so on.
Alright. Now for my verdict on SquaredUp for Azure:
- Very easy to scope
- One place to operate from
- Very easily customizable
- Very quick to create
- Drill-down into various perspectives
- A “proper” dashboard instead of “shortcuts”
- Beautiful look and feel!
That is it for this part of our 3-part series on Azure dashboards. That took longer than we expected, but most of it was consumed by the Azure dashboard and its infinite wizards!
In the next part, we will try to make another dashboard – one all about applications!