The IDERA SQL Inventory Manager Overview tab is the home page of the product. This tab provides a high-level status of your registered instances, and health check recommendations for issues found across your environment.

Health Check Recommendations

IDERA SQL Inventory Manager performs health checks on your registered instances to help you monitor the most important issues across your environment. For more information about the health checks performed by IDERA SQL Inventory Manager, see What Health Check Recommendations are available with SQL Inventory Manager?

On this section of the Overview tab, IDERA SQL Inventory Manager shows you the most critical health check recommendations for your environment, grouped by health check type, and ordered by level of criticality, where:

If you have no health check recommendations, you will see the message: All instances are passing their health checks.

Click Show Details or click the name of the health check recommendation to:

To close this view of the details, click Hide Details.

When you have multiple instances listed under a single health check recommendation, you can dismiss the information for an individual database or instance but you can also choose to Dismiss the whole health check recommendation by clicking Dismiss at the top level of the recommendation.

Use Refresh to get the most updated information for a specific health check recommendation.

Dismissing a health check recommendation causes IDERA SQL Inventory Manager to ignore this recommendation temporarily. You do not get alerts until the health check passes and then goes into an alert status again.

When you dismiss a health check recommendation, a dialog window opens to confirm this action, you can enable the option Do not show this warning again so that IDERA SQL Inventory Manager does not prompt this warning message each time you dismiss a health check recommendation.

Exporting health check recommendation reports

At the top of the Health Check Recommendations section, you can find the Exporting reports option. Use this feature to export:

You have three formats for exporting your reports: PDF, XLS, and XML. Choose one of these options, and then click Export.

Databases Graphs

IDERA SQL Inventory Manager provides you bar graphs of the most important databases from your environment. You can get a view of the largest and busiest databases across your instances.

Instances

This section provides you with a table of all the registered instances on your environment. It displays information about the instances status, response time, SQL Server version, number and size of databases per instance. You can click any of the column headers to order the table by the respective field.

On this section, you can also add new instances by clicking the Add SQL Server instance option located on the top right section of this table. For more information on how to add instances, refer to Add SQL Server instances.

By clicking the gear icon next to an instance name, you can perform the following specific actions for that instance:

You can also access an instance details view by clicking directly its name. Go to Viewing instance details, for more information on this view.

Status Area

On the right side of the overview, IDERA SQL Inventory Manager provides a summary of the status and contents of your environment that includes:

Take into account that IDERA SQL Inventory Manager rounds off data so there may be minor discrepancies between the size data displayed in the Summary and Instances section of the Overview tab.

If you click on a tag name, IDERA SQL Inventory Manager displays a view of your environment's data size by instance, filtered with the respective tag.

Tags font size represents the most used tags. The bigger the font size, the greater the number of instances that belong to that tag.



SQL Inventory Manager Discover and visualize your SQL Server environment.
| | | | | | |