Page History

SQL Diagnostic Manager allows you to easily add and remove DMSO Instances from your Installations. You can add or remove Instances to the DMSO Management through:

• User Interface.
• PowerShell Cmdlet.

Anchor
UserInterface UserInterface

User Interface

Add a DMSO 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 instance.

Also, you can remove monitored instances through the user Tree View by right-clicking the DMSO Instance to remove and selecting the Delete option.

Image Added

Anchor
PowerShell PowerShell

PowerShell Cmdlet

Add a DMSO Instance through PowerShell Cmdlet, check the example below :

New-SQLdmMonitoredInstance -Path Instance1 -Cluster MgmtCluster -WindowsAuthentication -tags production,finance

Finally, you can add a DMSO Instance through PowerShell Cmdlet:

Remove-SQLdmMonitoredInstance -Path \Instances\ServerA

Add new monitored instances to DMSO

You can add instances for monitoring in DMSO in two different ways:

1. Through the user interface: Add an instance to the Management Cluster which is current at the time of addition
   
2. Through a new cluster-aware PowerShell Cmdlet:
   

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

   New-SQLdmMonitoredInstance -Path Instance1 -WindowsAuthentication

   -tags production,finance,critical

   Also, specify the Management Cluster in addition to the Instance name. Check the following example:

   New-SQLdmMonitoredInstanceClustered -Path Instance1 

   -Cluster MgmtCluster -WindowsAuthentication -tags production,finance

ADD REMOVE INSTANCES

View Management Clusters

...