Versions Compared

Key

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

SQL Diagnostic Manager allows you to easily add and remove DMSO Instances from your Cluster Environments.

Add Instances to DMSO Management Clusters

Add DMSO

...

Instances to the DMSO Management clusters through:

Anchor
UserInterface
UserInterface
User Interface

You can add instances for monitoring in a DMSO through (more information) pasos y algunos screenshots (fijarnos en el demo)

The user interface

Instance through the User Interface using the Add Servers Wizard, you can find it

  • By selecting the Manage Servers under the Files menu
  • By right-clicking the DMSO Cluster and selecting Manage Servers...

 Configure your instance as it was a normal instanceAdd an instance to the Management Cluster which is current at the time of addition.

Note

To determine which repository is used, you may need to allow the current value of the ActiveRepositoryConnection property
 in the DesktopClient.Properites.Settings class.

A new cluster-aware PowerShell Cmdlet

Check the example below of PowerShell Cmdlet for adding an instance for monitoring:

Code Block
languagepowershell
New-SQLdmMonitoredInstance -Path Instance1 -WindowsAuthentication -tags production,finance,critical

Anchor
PowerShell
PowerShell
PowerShell Cmdlet

You can add a DMSO Instance through PowerShell Cmdlet, check the example below Also, specify the Management Cluster in addition to the Instance name. Check the following example :

Code Block
languagepowershell
New-SQLdmMonitoredInstanceClustered -Path Instance1 -Cluster MgmtCluster -WindowsAuthentication -tags production,finance

Removing Instances from DMSO Management Clusters

You can remove monitored instances through the user interface.

Follow these instructions to remove an instances

Cluster Tree View by right-clicking the DMSO Instance to remove and selecting the Delete option.

Image Added(explain more steps)