Use the following steps to upgrade your SQLdm installation in a clustered environment.

SQLdm 9.0 and later requires Microsoft SQL Server 2005 running on the computer that hosts the SQLdm Repository database for all installations.

Upgrade in a Microsoft Windows Server 2003 Clustered Environment  

To upgrade SQLdm 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 SQLdm 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 SQLdm 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 SQLdm 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 SQLdm services.
  3. Take the SQLdm Management and Collection services offline.

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

  1. Upgrade SQLdm 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. 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 > >
  • No labels