You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

The following instructions guide you through the installation of SQL Diagnostic Manager in a Windows Server 2012 based clustered environment.

Things to consider before you install SQL Diagnostic Manager in a clustered environment

  • Create a separate cluster resource group to host SQLDM services. A separate group allows the SQLDM services to fail without causing other resources in the group to failover
  • To create a cluster resource group you need to gather a dedicated IP, NetBIOS name, and a dedicated disk
  • SQLDM Collection, Management, SQLdm Rest Service, and Predictive Analytics services can run as generic services on your newly-created cluster resource group

Next, follow the steps described in the links below to complete the installation of SQL Diagnostic Manager on a Windows Server 2012 clustered environment:

  1. Install SQL Diagnostic Manager on a node
  2. Register the SQL Diagnostic Manager services as a Clustered Resource
  3. Reconfigure the SQL Diagnostic Manager Services and Repository Database
  4. Install the IDERA Dashboard and Register the SQL Diagnostic Manager with the IDERA Dashboard


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