Page History

...

• Create a separate cluster resource group to host SQLdm SQLDM services. A separate group allows the SQLdm SQLDM services to fail without causing other resources in the group to failover.
• Before you create this separate cluster resource group, gather a dedicated IP, NetBIOS name, and a dedicated disk for the cluster resource group.
• SQLdm SQLDM Collection, Management, and Predictive Analytics services can run as generic services on your newly-created cluster resource group.
• The system may request the network Name and network IP as part of cluster configuration.

Install

...

SQLDM Services on Cluster Nodes

You must install the SQLdm SQLDM services on each cluster node for the services to work correctly when a failure occurs on the primary cluster node hosting the SQLdm SQLDM services.

To install SQLdm SQLDM services on cluster nodes:

1. Log on with an administrator account to the computer on which you want to install SQLdmSQLDM.
2. Run Setup.exe in the root of the SQLdm SQLDM installation kit on the first cluster node.
3. Click SQL Diagnostic Manager on the Quick Start window.
4. On the Welcome window of the setup program, click Next.
5. Review and accept the license agreement by clicking I accept the terms in the license agreement, and then click Next.
6. Accept the default installation folder, or click Change to specify a different folder, and then click Next.
7. Select the Typical setup type, and then click Next.
8. Select the SQL Server instance and enter a database name.
9. Enter the service account information, and then click Next.
10. Click Install.
11. In Windows Services, stop the SQLdm SQLDM Management service and set the Startup type to Manual.
12. In Windows Services, stop the SQLdm SQLDM Collection service and set the Startup type to Manual.
13. In Windows Services, stop the SQLdm SQLDM Predictive Analytics service and set the Startup type to Manual.

Repeat the previous steps on each cluster node. Point to the SQLdm SQLDM Repository installed on the first node.

...

1. Select a disk that is configured in the Cluster Resource Group and create a directory on that disk that you want to use to hold local data for the services.
2. On the primary node, edit the registry and add a new key named Default to the key \Software\Idera\SQLdm. In this key, add a string value called DataPath. Set its value to the full path to the data directory created in step 1 (as shown in the image at the end of the steps).
3. In the Failover Cluster Management tool, right-click Roles> Configure Role....
4. Click Next in the Before You Begin tab of the High Availability wizard.
   • In the Select Role tab, select Generic Service.
   • In the Select Service tab, select the SQLdm Management Service.
   • Enter the network name and IP address for the SQLdm services.
   • Select the clustered storage that hosts the path defined in step 1.
   • Provide the Registry Replication defined in step 2.
   • Verify the settings and click Next to complete the wizard.
5. In Roles, click the newly created service name and stop Role.
6. In Roles, select the newly created service name and select the Resources tab found at the bottom.
7. Right-click on the SQLdm SQLDM Management Service and select Properties
   • On the Dependencies tab, add the name of service and disk, and then click Apply.
   • On the General tab, select Use Network Name for computer name, and then click OK.
   • To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
     Add-ClusterCheckpoint -ResourceName "SQLdm Management Service (Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"
8. In Roles, right-click the newly created service and select Add a Resource and then select Generic Service
9. Select the SQLdm SQLDM Collection Service.
10. Select Next and finish out the wizard.
11. Right-click on the SQLdm SQLDM  Collection Service and select Properties.
    • On the Dependencies tab, add the name of service and disk, and then click Apply.
    • On the General tab, select Use Network Name for computer name, and click OK.
    • To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
      Add-ClusterCheckpoint -ResourceName "SQLdm Collection Service (Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"
12. In Roles, right-click the newly created service and select Add Resource and then select Generic Service
13. Select the Predictive Analytics service from the list of resources
14. Select Next and then Finish to exit the wizard
15. Right-click on the SQLdm SQLDM Predictive Analytics Service and select Properties.
    
    • On the Dependencies tab, add the name of service and disk, and then click Apply.
    • On the General tab, select Use Network Name for computer name, and click OK.
    • To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
      Add-ClusterCheckpoint -ResourceName "SQLdm Predictive Analytics Service(Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"
16. In Windows Services, bring the SQLdm SQLDM Management service resource online.
17. In Windows Services, bring the SQLdm SQLDM Collection service resource online.
18. In Windows Services, bring the SQLdm SQLDM Predictive Analytics service resource online.
19. On the active node on which you installed the SQLdm SQLDM services, use the Management Service Configuration wizard (Start > All Programs > Idera IDERA > SQL diagnostic manager Diagnostic Manager > Tools > Management Service Configuration Wizard) to force the services to re-register.
20. Test the configuration from the Management Service Configuration wizard before finishing the wizard.
    
    

Complete the Cluster Configuration in SQL Diagnostic Manager

Start the SQLdm SQLDM Desktop Client and select SQLdm SQLDM Repository. If the SQLdm SQLDM Repository is clustered make sure to use the virtual server name for the SQL Server hosting the SQLdm SQLDM Repository.