SQL Diagnostic Manager now communicates with multiple Diagnostic Manager Scale-Out (DMSO) Management Installations, consolidating the data from across them to present a single unified view. That means that SQL Diagnostic Manager monitors any instance by a single management installation at any given time, providing a mapping of each monitored instance to the given Management Installations.

Also, the Diagnostic Manager Scale-Out is enabled for larger environments than before,  making it easier to manage your instances. This implementation does not affect the performance of utilizing multiple Windows consoles simultaneously, and users can use any existing functionality within Diagnostic Manager to display or administer across all nodes as in a single repository installation. This process is achieved thanks to the Metadata and Database components.

The management experience of multiple installations through SQL Diagnostic Manager effectively summarizes and collects data through all the owned instances.

Remember that you can use any existing functionality to display or administer across all Diagnostic Manager Nodes as a single repository installation, such as

  • Server Views allow you to monitor multiple instances using different views such as heatmap, thumbnails of mini-monitors, an instances' list and their details, or instances' list with their server properties.

    The Thumbnail view is limited to 300 servers. You can add new tags or select some servers from the server tree to filter and display a specific selection.

  • Tags let you organize and view servers from your SQL DMSO Installations.
  • Import and Export feature that allows you to import and share alert templates, alert responses, custom reports, and custom counters XML files.
  • Application Security manages the security resources for DMSO users, DBAs, Operators, administrators, and others.
  • VM Configuration and Mapping
  • Custom Counters display a variety of performance metrics for one or more of your DMSO instances. You can add additional performance metrics or remove the default ones.

    All custom counters are available for DMSO Installations.

  • Alert Templates allow you to configure alert settings to inform and warn you about approaching issues for one or more DMSO instances.
  • Azure Profiles feature lets you view and manage registered Azure profiles from your DMSO Installations.
  • Grooming allows you to schedule and configure SQL DSMO Repository grooming for one or more instances from the DMSO Installations.
  • Manage License lets you manage the License Keys of the DMSO Installations.
  • Analyze your DMSO Instances.

You can pick different servers from the instances list (using a tag or selecting them directly from the server tree). It does not matter if they belong to different cluster environments or if it is a local instance; SQL Diagnostic Manager will monitor them as if they were a single instance.

Also, you can perform the following items across all DM Repositories as though it was one SQL Diagnostic installation:

You can also upgrade your SQL Diagnostic Manager Scale-Out Installations by following the steps on Upgrade DMSO Servers from Existing DM Installation.