Versions Compared

Key

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

SQL Diagnostic Manager Console now communicates with multiple DMSO Diagnostic Manager Scale-Out Management Clusters, consolidating the collected data to present it in a single view. 

Windows Console maintains knowledge and connections to a single SQL Repository and a single DM Management service. To access any data instance SQL DM Diagnostic Manager queries to a single DM repository. 

Image RemovedImage Added

With the existence of multiple DM Repositories and Management Services in cluster the installed environments, DMSO the Diagnostic Manager Scale-Out Manager maps cluster the installation layers. To do so, it relies on cluster metadata. 

DMSO

...

Metadata

DMSO Cluster Metadata describes which monitored instance is owned by a specific Management ClusterInstallation. Besides, Metadata is part of the mapping layer process. 

This process is achieved by:

  1. Intercepting references to the DM Repository and DM Management Service.
  2. Mapping the DM Repository and DM Management service reference information to the appropriate DM Repository or Repositories.
  3. Correctly assembling the data when more than one Repository contributes to the results.

DMSO

...

Database

DMSO Cluster Database stores and maintains the data collected by the metadata. This data may

  • Exist on a stand-alone server for performance and scalability reasons.
  • Be provisioned on one of the management ClustersInstallations

The DM Windows Console reads the instance to Management Cluster Installation mappings into memory and maintains these mappings as a cache to speed instance to Management Cluster Installation mappings.

DMSO Cross

...

Metadata

Some elements of the metadata utilized by the Diagnostic Manager are system-wide items, such as DMSO Users.

DMSO Users are defined in the context of the whole scale-out cluster deployment. All Management Clusters are provisioned with the same users which execute with the same level of permissions across all the clusters.installation deployment. 

Note
titleNote

When you add a DMSO user, SQL Diagnostic Manager provisions it across all Management Clusters with the same level of permissions.