Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

SQL Elements offers a simple architecture which runs in your SQL Server environment with minimal configuration. The web based interface allows you to easily access the status of your environment from any computer at any location without adding or modifying your native SQL Server files or services.

SQL Elements consists of the following components:

SQL Elements User Interface

SQL Elements provides a web based user interface. This interface is used to view data about your monitored SQL Server instances, as well as to administer SQL Elements.

The web based user interface does not require IIS or other internet servers.

The user interface web service is self-hosting and through it you can find multiple views that help you to:

  • Discover instances in your environment and register those you wish to monitor.
  • Monitor availability, capacity, configuration, and performance data from your monitored instances, their respective databases, and host computers.
  • View health check recommendations and availability status for monitored instances and databases. 
  • Receive email alerts on availability and capacity issues. 
  • View instances information grouped by tags, owners, locations, and other filters.  

This Web Application can seamlessly be accessed through Internet Explorer 9 or later, Google Chrome, and Mozilla Firefox.

You can access SQL Elements web application through the following link:

http://<ServerName>:<web application port>

Where ServerName is the name of the machine on which you installed the SQL Elements services and the Web application port refers to the one you specified during installation, or by default port 9276.

Info
titleInfo

You have to grant new users access to be able to login into Idera SQL Elements web interface. For adding users go to Managing users in SQL Elements

SQL Elements services 

Idera SQL Elements uses the following windows services:

  • Idera Web Server
  • Idera Core Service
  • Idera SQL Elements Collection Service 

Idera SQL Elements uses the Collection Service account to gather information from monitored instances and their host computers. To change this default setting, go to Editing instances properties.

SQL Elements repositories

Idera SQL Elements creates the two following databases on installation:

  • Idera SQL Elements Repository
  • Idera Core Services Repository

These databases store information related to application users, configuration information, and data gathered for the monitored instances.

 

Below a diagram of Idera SQL Elements architecture: