Page History
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 | ||
---|---|---|
| ||
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
...
The SQL Server Licensing widget displays an unnecessary bracket character in the the # of Sockets field field.Anchor SQLELEM-13708 SQLELEM-13708
The number of discovered instances does not match in the Dashboard and the Discovered Instances tab.Anchor SQLELEM-13561 SQLELEM-13561
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 DE45646 DE45646
...
IDERA SQL Inventory Manager fails to collect transactional activity on some databases.Anchor SQLELEM-9632 SQLELEM-9632
IDERA SQL Inventory Manager occasionally displays the same application multiple times under different application IDs/names in the Applications list.Anchor SQLELEM-13557 SQLELEM-13557
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-9649 SQLELEM-9649
Some users may receive an unexpected exception error when clicking clicking Save after after making a change in the Manage Health Check.Anchor SQLELEM-13714 SQLELEM-13714
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-9614 SQLELEM-9614
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-13559 SQLELEM-13559
Users who have AlwaysOn Availability Group environments may notice errors caused by the unreadable state of the secondary cluster node.Anchor SQLELEM-9630 SQLELEM-9630
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 DE45724 DE45724
...
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 DE45721 DE45721
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.Anchor DE45725 DE45725
Reporting issues
Reports exported to XML may not include the correct summary count as displayed in the PDF/XLS.Anchor SQLELEM-13710 SQLELEM-13710
Reports exported to PDF/XLS/XML do not include the the # of Cores, Core Factor, and and Possible Core Licenses values values.Anchor SQLELEM-13709 SQLELEM-13709
...
Excerpt |
---|
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |