The Instance Details view allows you to see specific information for an instance. SQL Inventory Manager displays the instance health check recommendations, top databases, relevant information, and also allows you to get access to the instance host server computer details and configuration settings.

Additionally, on the actions items bar, you can find the following options:

If you click the drop-down arrow next to the instance name, you can choose a different instance to access its respective details.

What information can you find on the Instance Details view?

Health Check Recommendations

This section provides you with specific health check recommendations for the selected instance. SQL Inventory Manager groups these health checks by type, and orders them by level of criticality; where:

You can choose to show details, hide details, dismiss, or refresh any health check recommendation. You can also export this information according to your required format. For more information on how to view health check recommendations for a specific instance, refer to Viewing Health Check Recommendations for a specific instance.

To view what health checks are performed by SQL Inventory Manager, refer to What Health Checks are available in SQL Inventory Manager?

Applications

SQL Inventory Manager periodically takes a sampling of the applications connecting to each SQL Server instance. This sampling occurs approximately once every hour. The Applications list on the Instance Details view includes the name of the application along with the timestamp of the most recent sampling that included that application. You can also manually add an application to track using Add Application. For more information about this feature, see Manage instance applications.

Click the gear icon next to the application name to select one of the following options:

Top bar graphs

These graphs provide insight of the most important databases for your instance, based on databases size and how busy they are (transactions per second).

SQL Inventory Manager shows you the following bar graphs:

Instance summary and status

On the right side of the Instance Details view, you can see a section that provides general information for your instance.

On this sidebar, you can see the following information for this instance:

Take into account that SQL Inventory Manager rounds off data so there may be minor discrepancies between the size data displayed in the Instance Summary and Databases section of the Instance Details view.

Click the pencil icon next to the Instance Summary title and you can access the options for editing your instance properties such as owner, location, comments, and credentials. For more information, refer to Edit instance properties.

Instance Databases

At the bottom section of the Instance Details view, SQL Inventory Manager displays a list of all databases available as well as any decommissioned databases on this instance.

The Databases list shows you information about the status, number of recommendations, type, data size, log size, and activity for each database.

Click the gear icon next to the database name to select one of the following options:

If you click directly on the database name, you can access the Database Details. For more information on what is available on these details, go to Viewing Database Details.

 

The Decommissioned Databases list shows you information about the decommission date, recommendations, database type, size, and activity for each database.

Click the gear icon next to the decommissioned database to select one of the following options:

If you click directly on the database name, you can access the Database Details. for more information on what is available on these details, go to Viewing Database Details.

 

Need more help? Search the Idera Customer Support Portal.

Idera WebsiteProductsPurchaseSupportResourcesCommunityAbout UsLegal