Page History
...
This set of instructions helps you to configure SQL Diagnostic Manager services in its own cluster using a Cluster Disk or Cluster Network shared folders. This option requires an available disk on the cluster to store the temporary files used by the SQLDM services.
Note |
---|
For cluster disks, the available disk on the cluster can be any visible disk to all nodes in the cluster; including a network disk reachable via the UNC path. |
- Launch Failover Cluster Manager on a node of the cluster.
Info For more information on how to launch the Failover Cluster Manager, check Installing the Failover Cluster Feature and Tools in Windows Server 2012
- Right-click on Role and select Create Empty Role.
- Right-click on New Role and select Properties.
- Specify a new name for the role and click OK.
- Right-click on the Role, select Add Resource, and click Client Access Point.
- When the New Resource Wizard opens, type an a unique network name and an IP address, and click Next.
- Click Next on the Confirmation screen.
- Click Finish on the Summary screen.
- Create a SQLdm DataPath:
- For a Cluster Disk:
- Right-click on the Role and select Add Storage.
- Select a disk, and click OK.
- In File Explorer, create a folder to be used by SQLDM services on the disk that was added.
Eg. P:\SQLdmDataPath
- For Cluster Network shared folder:
- On your network shared folder create a folder for SQLdm and ensure it has writing access to thisDataPath.
Eg. \\Server\SharedFolder\SQLdmDataPath
- On your network shared folder create a folder for SQLdm and ensure it has writing access to thisDataPath.
- For a Cluster Disk:
- Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
- Right-click the SQLdm key, select New, click Key, and enter Default for the name.
- Right-click the Default key, select new New, click String Value, and enter DataPath for the name.
- Double-click on the recently created DataPath string value and enter the path to the folder that was created for SQLDM services, click OK.
- Go back to Failover Cluster Manager.
- Right-click on the role, select Add Resource, and and click Generic Service.
- On the Select Service screen, select the SQLdm Collection Service, and click Next.
- Click Next on the Confirmation screen.
- Click Finish on the Summary screen.
- Repeat steps 17-20 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service.
- Right-click on one of the added SQLDM services and select Properties.
- Go to the Dependencies tab and add the following resources:
- Name
- IP Address
- Disk
Info You can skip adding the Disk resource only if a shared folder was used.
- Click Apply and go to the General tab.
- Check the box of Use the network name for the computer name, and click click Apply.
Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\Default, and click OK.
Warning There is a bug in Window Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the
PowerShell cmdlet to add the necessary setting.Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLdmCollectionService`$Default" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default" -Cluster "SQLdmServices"
- Click Apply, and then click OK
- Repeat steps 17-27 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
- Right-click on each SQLDM service and select Bring Online
...
- In File Explorer, create a folder to be used by SQLDM services on a disk that has been added as a cluster resource.
- Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
- Right-click the SQLdm key, select New, click Key, and enter Default for the name
- Right-click the Defaultkey, select new, click String Value, and enter DataPath for the name
- Double-click the string value and enter the path to the folder that was created for SQLDM services, click OK
- Launch Failover Cluster Manager on a node of the cluster. For more information on how to launch the Failover Cluster Manager, check
Newtablink alias Installing the Failover Cluster Feature and Tools in Windows Server 2012 url https://blogs.msdn.microsoft.com/clustering/2012/04/06/installing-the-failover-cluster-feature-and-tools-in-windows-server-2012/ - Right-click on an existing role, select Add Resource, and click Generic Service
- On the Select Service screen, select SQLdmCollection Service, and click Next
- Click Next on theConfimation the Confirmation screen
- Click Finish on the Summary screen
- Repeat steps 27-5 10 for the reimaining remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
Right-click on one of the added SQLDM serviceservices, and select select Properties
- Go to the Dependencies tab and add the following resources:
- Name
- IP Address
- Disk
- Click Apply and go to the General tab
- Check the box of Use network name for the computer name, and click click Apply.
Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\Default, and click OK
Warning There is a bug in Window Windows 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the
PowerShell cmdlet to add the necessary setting.Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLdmCollectionService`$Default" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default" -Cluster "SQLdmServices"
- Click Apply, and then click OK
- Repeat steps 712-13 17 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
- Right-click on each SQLDM service and select Bring Online
When you finish registering the SQL Diagnostic Manager services as Clustered Resources, you need to Reconfigure the SQLDM Services and Repository Database.