Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

IDERA DERA SQL Inventory Manager provides fundamental information on your SQL Servers to help you manage and keep track of your database environment without having to be an expert in Microsoft SQL Server. It gives a broad enterprise-wide view of all your SQL Servers through automated discovery as well as simple, actionable information about the state of your environment. View core information such as how many databases exist, whether they are being backed up, get access to options like availability monitoring, and notification emails so you can take action as needed.

IDERA strives to ensure our products provide quality solutions for your SQL Server needs. If you need further assistance with any issue, please contact contact Technical Support.

The following issues are known in this version of IDERA SQL Inventory Manager:  


Note
titleUpgrading from a previous version

Because of the addition of roles, all user accounts in a previous version of the product are added to the IDERA Dashboard but are not assigned a role and cannot access IDERA SQL Inventory Manager until the administrator changes the account permissions. Note that the administrator is the account specified during the IDERA Dashboard installation.

To change user account permissions, go to IDERA Dashboard > Administration > Manage Users. Edit a user account. Select the IDERA SQL Inventory Manager product, and then assign a role of Product Administrator, Product User, or Product Guest. Click Save, and then repeat these steps for each user account.

Now grant the user accounts access to the instances in your environment. Go to SQL Inventory Manager > Administration > Manage Users. Click the link for the name of the user account. In the Access to SQL Server Instances section of the Edit Users window, select whether you want to grant the user account access to all instances or a selection of instances. If you want to grant access to only selected instances, choose those instances using whether the tag or instance name. Click Save.

For more information about user accounts and roles, see Managing users in the IDERA Dashboard.

Known issues in version 2.

...

4

Database backup is not current Dialog

The Select All Checkbox for "Available Databases" may stop working randomly after performing various operations on the page.

Charge back report - Sub charge report collapses when sorted

When sorting any column on a sub charge table the sub charge report collapses automatically.

SIM group users have no access to shared instances

Individual Group Users are unable to see shared instances assigned to their group.

TOP DATABASES BY ACTIVITY (TRANSACTIONS/SEC)

Not all instances display values for activity.

Discovery status log shows invalid page count.

The Discovery Status Log page count includes blank pages.

Patch filtering for SQL Server 2008 includes SQL Server 2008 R2

When filtering views or viewing hotfixes for SQL Server 2008, SQL Server 2008 R2 versions are included in the list.

DB on Availability Group view selection occasionally fails to display secondary node information

The DB on Availability Group view selection in the Explorer view fails to display secondary node information when an availability group is in a resolving state or when the secondary node is offline.

DB on Availability Group page Status information update is not immediate after a failover

Status information on the DB on Availability Group page may take up to an hour to update after a failover


Previous known issues

Installation and upgrade issues

...

  • Anchor
    SQLELEM-13708
    SQLELEM-13708
    The SQL Server Licensing widget displays an unnecessary bracket character in the the # of Sockets field field.
  • Anchor
    SQLELEM-13561
    SQLELEM-13561
    The number of discovered instances does not match in the Dashboard and the Discovered Instances tab.
  • Anchor
    DE45646
    DE45646
    In IDERA Dashboard, the Manage Instances view under the Administration view displays both monitored and unmonitored instances instead of only monitored instances. All users will be able to access the list of instances in the Instance Detail tab under IDERA Dashboard; however, only users with specific Dashboard access will be able to see the instance details. In IDERA SQL Inventory Manager, the Managed tab under the Instances view correctly displays only monitored instances.

...

  • Anchor
    SQLELEM-9632
    SQLELEM-9632
    IDERA SQL Inventory Manager fails to collect transactional activity on some databases.
  • Anchor
    SQLELEM-13557
    SQLELEM-13557
    IDERA SQL Inventory Manager occasionally displays the same application multiple times under different application IDs/names in the Applications list.
  • Anchor
    SQLELEM-9649
    SQLELEM-9649
    When a user disables monitoring for a database, the associated Health Check Recommendations update correctly, but then do not update correctly when monitoring is re-enabled even if the user attempts to restart the service.
  • Anchor
    SQLELEM-13714
    SQLELEM-13714
    Some users may receive an unexpected exception error when clicking clicking Save after  after making a change in the Manage Health Check.
  • Anchor
    SQLELEM-9614
    SQLELEM-9614
     SQL Server 2000 only: IDERA SQL Inventory Manager may display that the database consistency is not checked for some SQL Server 2000 databases although the checks are run. An additional run of the checks does not update this value.
  • Anchor
    SQLELEM-13559
    SQLELEM-13559
    IDERA SQL Inventory Manager may display a foreign key constraint error message when a user attempts to edit or enter a value in some custom inventory fields.
  • Anchor
    SQLELEM-9630
    SQLELEM-9630
    Users who have AlwaysOn Availability Group environments may notice errors caused by the unreadable state of the secondary cluster node.

  • Anchor
    DE45724
    DE45724
    In environments with a large number of monitored instances, the Health Check Recommendations are not immediately updated when you decommission and recommission databases. There will be a slight delay for the health check recommendations to refresh.

...

  • Anchor
    DE45721
    DE45721
    In order to set up user account for email alerts, you first must set up and enter individual email addresses in the IDERA SQL Inventory Manager Manage Administration page. User accounts added using the Manage Users link in the IDERA Dashboard Administration tab do not have their associated email address appear when viewing the account in the IDERA SQL Inventory Manager Manage Users and Subscriptions window.

  • Anchor
    DE45725
    DE45725
    In order to select the All Instances option for user permissions, you must select the hyperlink for that user account in the Manage Users and Subscriptions window. Select Select All Instances, and then click click Save.

Reporting issues

  • Anchor
    SQLELEM-13710
    SQLELEM-13710
    Reports exported to XML may not include the correct summary count as displayed in the PDF/XLS.
  • Anchor
    SQLELEM-13709
    SQLELEM-13709
    Reports exported to PDF/XLS/XML do not include the the # of Cores, Core Factor, and and Possible Core Licenses values values.

...


Excerpt
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >