Page History

Supports core licensing for SQL Server 2012 and later

Users who have SQL Server 2012 and later instances using core licensing now can take advantage of the following additional core license-specific features and support available in IDERA SQL Inventory Manager 2.2:

• Supporting tables that help you identify core factors  
• Additional core-specific information displayed in the SQL Server Licensing view
• Ability to edit Microsoft SQL Server license details

For more information about using SQL Server core licensing within IDERA SQL Inventory Manager, see How to manage SQL Server licensing.

Supports MS SQL Server 2016

IDERA SQL Inventory Manager 2.2 and later support hosting repositories and monitoring instances using SQL Server 2016. For more information about supported platforms, see Software requirements.

...

2.3 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.

2.3 Fixed issues

• Anchor
  SQLELEM-9805 SQLELEM-9805

  IDERA SQL Inventory Manager 2.

...

• 3 includes

...

Allows configuration for some health checks

Users now can configure the alert threshold settings for the following health checks to customize alerts for particular environments:

• Database backup is not current
• SQL Server is down
• SQL Server is slow

...

• code improvements that resolve a Java heap space error experienced by some users upgrading from previous versions of IDERA SQL Inventory Manager.

• Anchor
  SQLELEM-9635 SQLELEM-9635

  Users who upgrade from a previous version of IDERA SQL Inventory Manager (previously named SQL Elements) no longer see a ServiceUser account with MONITORING GROUP type in the database. This was a legacy account that now is deleted.

• Anchor
  SQLELEM-1750 SQLELEM-1750

  IDERA SQL Inventory Manager now allows users to log in using integrated security through their Windows login credentials.

• Anchor
  SQLELEM-9634, SQLELEM-9633, SQLELEM-13854 SQLELEM-9634, SQLELEM-9633, SQLELEM-13854

  Users now can successfully log in with user names containing special characters as well as use special characters when updating the name or location of their SQL Server instances.

• Anchor
  SQLELEM-13839 SQLELEM-13839

  Resolves an issue that caused IDERA SQL Inventory Manager to run scans on domains other than those selected.