You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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 that 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:



  • No labels