We’re delighted to announce that we’ve received our first entry to the design a dashboard competition. It’s a magnificent effort from Merrill Aldrich, who sent us a fully functional .NET application to demonstrate his ideas.
As can be seen, the UI neatly displays the health state of the SQL instances. In his explanatory notes, Merrill stated that
“most third-party monitoring solutions try to monitor everything and gather way too much information, when the most important things to watch can be gleaned from a few key performance data points”
He lists the following as the key data points to monitor:
- CPU Utilization
Page Life Expectancy and Pending Memory Grants (i.e. Memory Pressure)
Disk Latency and Disk Free Space
Duration and number of Blocked Processes
Failed Agent jobs
Errors from the log
Merrill says he’s happy to drill into more detail when necessary but these are the key indicators. Do you agree?
Although he humbly suggests it’s ‘barely a mock-up’, we immediately installed his application and added 3 test machines to be monitored…
(There would also be a text area to to display warnings from all monitored instances, such as failed agent jobs, or errors from the log, for example).
Thanks Merrill, we’re really impressed by the calibre of this submission! We like how the colour of the entire graph changes when the current level rises above a value. The UI is uncluttered but drew our eyes to the issues as soon as they occured. Thanks for sharing this with us.
So now tell us what you think? What elements of this design appeal? Is there anything missing that you couldn’t live without? Post your comments, or send us your own design (sketch, scribble, scrawl, or functional application) and we’ll post it for discussion.