Versions Compared

Old Version 1

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

Key

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

Click here for 1.0 Documentation

 

Idera SQL Elements 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. 

...

The following issues are known in version 1.1 of SQL Elements:

Known issues in version 1.

...

2

General issues 

  • SQL Elements may display the message "!!! missing resource key = [com.ider....]" when the Core service goes down and any action is performed on the Instances tab.
  • SQL Elements supports authentication between internal services, this feature is disabled by default. To enable it, user needs to change configuration in two places. Authentication mechanism may or may not work depending upon user's security policy settings.
  • SQL Elements sessions do not expire anymore if users remain on the application. If they leave the application for more than thirty minutes their session will time out and users will need to log in again.

Installation and configuration

...

Adding, discovering instances

  • SQL Elements is currently not validating the information entered for IP addresses and DNS names. Users must be careful with the information they enter since invalid IP addresses or DNS names will cause the discovery to not work properly.
  • If SQL Server instances are added using UseOleforWMI:True, IP and mac addresses may not be collected and may be shown as blank.
  • When new tags are added in the Add SQL Server Instance wizard, SQL Elements may not display these newly added tags when accessing the See all tags option.

Monitoring

General

  • SQL Elements may count SQL Server instances as down until it finishes completing their initial data gathering.
  • Some WMI properties in Windows XP and Windows 2003 are not available so it is possible that SQL Elements will not collect the respective information.

Explorer view

...

  • The discovery process may take into account host computers without default SQL Server instances. 

  • Take into account that if you choose WMI as a method for scanning, you may have some limitations with the number of SQL Server instances discovered. For more information on how to view and change port ranges, click here.

Monitoring

...

Health Checks recommendations

  • The Refresh option allows to get the latest information from Instances or Health Check Recommendations. When clicking this option, a request for running a background refreshing job is requested and the "Refreshing" status is displayed. This job may take some time so manual refresh is required.To receive alert notifications, email addresses need to be provided. The field where these email addresses are specified may not validate the correct email format.

Dashboard

  • Data from each instance and health check recommendation in the Dashboard can be refreshed; however, there is no option yet to refresh all instances or recommendations at once.The data size of instances that are down may still be taken into account in the data size information of the Dashboard and Instance tab.

Instance details view

  • The side bar of the Instance Details view of an instance with "Unknown Error" or "Unresponsive" state may not display the latest information collected.
  • Information that SQL Elements was not able to collect such as SQL Server version, Host Server, databases, size, etc., may be displayed with zero value or as blank in the Instance Details view.
    • SQL Elements gathers Driver information taking into account only the server hosting the instance. There is no distinction between drivers that are in a clustered resource group or not. Consequently, it is possible that in a clustered instance, SQL Elements will display "No drives found" in the Computer Details.

Previous known issues in 1.1

Previous known issues in 1.0

...