Use the following steps to upgrade your SQL Diagnostic Manager installation in a clustered environment.

SQL Diagnostic Manager 10.0 and later requires Microsoft SQL Server 2005 running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations.

Upgrade in a Microsoft Windows Server 2003 Clustered Environment  

To upgrade SQL Diagnostic Manager in a clustered environment:

  1. Log on to the cluster node using the Administrator account.
  2. In Cluster Administrator, select the resource group that contains the SQL Diagnostic Manager services.
  3. Take the SQLDM Management and Collection services off line.

Perform the following steps on each node, starting with the active node:  

  1. Upgrade SQL Diagnostic Manager components previously deployed to the node.
  2. In Windows Services, stop the SQLDM Collection, SQLDM Management, and SQLDM Predictive Analytics services.
  3. Set the SQLDM services to manually start, and then restart the services.

Once the previous steps are complete, perform the following steps on each cluster node:

  1. In Cluster Administrator, bring the SQLDM Management Service on line.
  2. Use the Management Service Configuration wizard to force the services to re-register on the active node.

Upgrade in a Microsoft Windows Server 2008 Clustered Environment

To upgrade SQL Diagnostic Manager in a clustered environment:

  1. Log on to the cluster node using the Administrator account.
  2. In the Failover Cluster Management tool, select the resource group that contains the SQL Diagnostic Manager services.
  3. Take the SQLdm Management and Collection services offline.

Perform the following steps on each node, starting with the active node:

  1. Upgrade SQL Diagnostic Manager components previously deployed to the node.
  2. In Windows Services, stop the SQLDM Collection, SQLDM Management, and SQLDM Predictive Analytics services.
  3. Set the SQL Diagnostic Manager services to manually start, and then restart the services.

Once the previous steps are complete, perform the following steps on each cluster node:

  1. Bring the SQLdm Management Service on line.
  2. Use the Management Service Configuration wizard to force the services to re-register on the active node.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >