Page History
Registering the SQL Diagnostic Manager services with Microsoft Failover Cluster Manager allows the Microsoft Cluster Service to manage the services in failover situations. The following configuration ensures the high availability of the services during a failover.
Below, you can find two sets of instructions to register the SQL Diagnostic Manager services as a clustered resource:
- Creating a new role for the SQL Diagnostic Manager services
- Adding the SQL Diagnostic Manager services to an existing role
Anchor | ||||
---|---|---|---|---|
|
This set of instructions helps you to configure the SQL Diagnostic Manager services in its own cluster. This option requires an available disk on the cluster to store the temporary files used by the SQLDM services.
- Launch Failover Cluster Manager on a node of the cluster. 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 prompts, type an uniquenetwork name and an IP address, and click Next
- Click Next on the Confirmation screen
- Click Finish on the Summary screen
- 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 the SQLDM services on the disk that was added
- Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
- Right-click on the SQLdm key, select New, click Key, and enter DataPath for the name
- Right-click on the DataPath key, select new, click String Value, and enter DataPath for the name
- Double-click on the string value and enter the path to the foderthat was created for the SQLDM services, click OK
- Go back to Failover Cluster Manager
- Right-click on the role, select Add Resource, 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 service and select Properties
- Go to 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 computername, and click Apply
Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\DataPath, and click OK
Warning There is a bug in Window 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\DataPath" -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
Anchor | ||||
---|---|---|---|---|
|
The following set of instructions helps you to add the SQL Diagnostic Manager services to an existing role:
- Launch Failover Cluster Manager on a node of the cluster. 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 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 screen
- Click Finish on the Summary screen
- Repeat steps 2-5 for thereimainingSQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
Right-click on one of the added SQLDM service, and select Properties
- Go to 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 computername, and click Apply.
Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\DataPath, and click OK
Warning There is a bug in Window 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\DataPath" -Cluster "SQLdmServices"
- Click Apply, and then click OK
- Repeat steps 7-13 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 s Clustered Resource, you need to Reconfigure the SQLDM Services and Repository Database.
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |