Versions Compared

Key

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

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 Cluster Environment multiple installations through SQL Diagnostic Manager effectively hides the number and size of the DM Management Clusters, collecting 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, among them: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.

    Note

    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.
  • Server Views 
  • Tags
  • Import and Export
  • Application Security
  • 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.

    Info

    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
  • Prescriptive Analysis
  • Keys of the DMSO Installations.
  • Analyze your DMSO Instances.
Info

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:

Info

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

Info

For all the functionalities above, SQL Diagnostic Manager allows you to pick a specific Cluster from a list.