Skip to content

Service Design

Niels Grove-Rasmussen edited this page Apr 2, 2017 · 2 revisions

SQLAdmin has these central components that other components are using or supporting.

Inventory

The SQLAdmin Inventory is the central metadata repository with details on all known SQL Server installations in the organisation.

There are no plans for a inventory in SQLAdmin Local on SQL Server Database Engine installations as there will not be a Database Engine installation on all SQL Server nodes.

The SQLAdmin Inventory data can be accessed through the Graphical User Interface (GUI) SQLAdmin Anchor, called SQLAnchor.

There have been some talks about a thin and more general user interface called SQLDisplay. This is still just a discussion subject.

Collector

The SQLAdmin Collector is central to collecting SQL Server information to the SQLAdmin Inventory. At least in the given domain. The idea is that there is one central Collector in the organisation, that collect from both nodes in the same domain and from SQLAdmin Collectors in other domains.

Agent

The SQLAdmin Agent collects SQL Server information on the local node. If there are several SQL Server installations on the same node, they are handled by the one and the same SQLAdmin Agent.

Clone this wiki locally