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:
| 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
You can add instances for monitoring in DMSO through
The user interface
Add 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
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
PowerShell Cmdlet
Add a DMSO Instance through PowerShell Cmdlet, check the example below Check the example below of PowerShell Cmdlet for adding an instance for monitoring :
| Code Block |
|---|
|
New-SQLdmMonitoredInstance -Path Instance1 -Cluster MgmtCluster -WindowsAuthentication -tags production,finance,critical |
Also, specify the Management Cluster in addition to the Instance name. Check the following exampleFinally, you can add a DMSO Instance through PowerShell Cmdlet:
| Code Block |
|---|
|
NewRemove-SQLdmMonitoredInstanceClusteredSQLdmMonitoredInstance -Path Instance1 -Cluster MgmtCluster -WindowsAuthentication -tags production,finance\Instances\ServerA |