SQL Response v2 will provide four main overviews of your system. Starting at the Global Overview page, you can drill down to a Machine overview, a SQL instance overview, and from there down to the database level. We’ve previously posted some of these overview designs for the Global, Machine and SQL Server levels.
The design below is a mock-up of how the overview page for a database might look. (Click to expand the image).
You will be able to click on an individual graph or metric to go to a dedicated page with more detail about that data, but what we’d like to know is –
is there anything not in this design that you’d really like to see at this overview level?
If you’ve drilled down this far, chances are you’re troubleshooting a problem? So perhaps you may need to see something about your tables (total number, growth, space) or your indexes, or connections? We’re trying to determine what would be the most useful information to display about each database, without cluttering the UI such that it’s too hard to find relevant information.
As ever, it would be great to hear your opinions…