Page History

2.3 Previous new features

Includes new patch list view

The new IDERA SQL Inventory Manager Patches view helps you manage SQL Server patches and keep your environment properly patched. The Patches view displays a list of your managed SQL Server instances including whether they are running a supported version of SQL Server. In addition, you can get information about the patches running on your SQL Server and whether additional hotfixes are available for your SQL Server level. For more information about the patches list view, see Reviewing SQL Server patches.

Supports the SQL Server AlwaysOn Availability Groups feature

IDERA SQL Inventory Manager 2.3 now allows DBAs to monitor their availability databases, nodes, and listeners through AlwaysOn Availability Clusters in SQL Server 2012 and newer. AlwaysOn automatically switches auditing from the primary to the secondary replica in the event of failure as well as failback to primary when it comes back online. This advantage prevents a loss of the audit data trail in the event of failure. IDERA SQL Inventory Manager allows you to view this information in the Explorer view.

For additional information about IDERA SQL Inventory Manager and the AlwaysOn Availability Groups feature, see Exploring your instances.

Introduces configurable health checks

New configurable health checks allow you to customize certain health checks to better suit your environment. These configurable checks include:

• Database at risk (Data)
• Database at risk (Logs)
• Volume at risk

Enhanced Discovery

Enhancing the SQL Server instance discovery features is an important aspect of IDERA SQL Inventory Manager. These updates include:

• New BI and reporting service discovery shows users where BI services are running in their environment, helping you keep track of the infrastructure external to the database servers themselves that they may need to bring under management.
• Discovery at the organizational unit (OU) level allows you to specify narrower slices of your domain for discovery, which is valuable in large,complex, or highly secured environments where broader discovery may cause issues.
• Exclude filters on domains allow you to prevent IDERA SQL Inventory Manager from running discovery on domains which are known not to be relevant or appropriate for discovery scans.

Improved IDERA SQL Inventory Manager user interface

IDERA SQL Inventory Manager features a new look and feel. Some changes include:

• Colors. New colors reflect updated IDERA branding rolled out across all IDERA products
• Navigation. The primary navigation moves away from product-specific tabs to a dropdown selection in the header adjacent to the IDERA logo. If you have multiple IDERA products installed in your environment, be sure to select the appropriate product before using any features.
• Administration menu. Common tasks previously accessed only on the Administration tab now are available from a new Administration menu on the right side of the menu bar.

Increased functionality offered in IDERA Dashboard

IDERA Dashboard functionality and offerings are expanded. IDERA Dashboard now includes:

• Global tags. Using IDERA Dashboard 3.0.x or later, users can create global tags that are available across all IDERA products using IDERA Dashboard. Local or product-specific tags still are available but cannot be used outside of their parent product. For more information about tags within IDERA SQL Inventory Manager, see Managing tags.
• Increased instance management. The IDERA Dashboard tracks instances discovered and managed by individual IDERA product. For more information about instances within IDERA SQL Inventory Manager, see Managing instances.