Deploy SQL Diagnostic Manager in a high availability group

The following steps guide you through the installation and deployment of SQL Diagnostic Manages and the IDERA Dashboard while hosting the repository databases in an AlwaysOn environment.

Install SQL Diagnostic Manager in an AlwaysOn Environment

1. In the IDERA SQL Diagnostic Manager Quick Start window, click Install SQL Diagnostic Manager.
2. In the Welcome to the SQL Diagnostic Manager Setup Wizard screen, click Next.
   
3. Accept the terms and conditions of the End-User License Agreement, and click Next.
   
   
   
4. Select the SQLDM Console, SQLDM Services and Repository, and the IDERA Dashboard components and click Next.
   
   
   
5. Enter the credential to be used by the IDERA services and click Next.
   
   
   
6. Review the ports that are to be used by the IDERA Dashboard services and click Next.
   
   
   
7. In the IDERA Dashboard Repository Database screen specify the listener name and database name and click Next.
   
   
   
8. Specify the listener name and database name for the SQL Diagnostic Manager Repository Database and click Next.
   
   
   
9. Provide the installation directory for the IDERA Dashboard and SQL Diagnostic Manager, enter a Display name, check the availability of the name, and click Next.
   
   
   
10. If the specified paths do not exist on the system, the following window prompts. Click Yes to proceed.
    
    
    
11. Click Install to start the installation.
    
    
    
12. After the installation has completed, disable the Launch IDERA SQL Diagnostic Manager checkbox and click Finish.

Configure the Databases for High Availability

1. Open SQL Server Management Studio (SSMS) on the primary node and connect the listener name.
2. Set the Recovery Model of the IderaDashboardRepository and SQLdmRepository databases to Full.
   
3. Perform a full backup of the IderaDashboardRepository and SQLdmRepository databases.
4. Right-click the appropriate availability group and select Add Database...
   
5. On the Introduction screen of the Add Database to Availability Group wizard, click Next.
   
   
   
6. On the Select Database tab, select the IderaDashboardRepository and SQLdmRepository databases, and click Next.
   
   
   
7. On the Connect to Replicas tab, connect to the other replica(s) in the availability groups by clicking Connect... next to the Server Instances, and click Next.
8. On the Select Data Synchronization tab, select one of the following options for your environment, and click Next.
   1. Automatic Seeding
   2. Full database and log backup
   3. Join only
   4. Skip initial data synchronization
9. On the Validation screen, ensure that all tests are successful and click Next.
   
   
   
10. On the Summary screen, verify the actions you selected in the previous steps, and click Finish.
    
11. The Results screen displays the summary of the performed actions and their results, click Close to exit the wizard.
12. In SSMS connect to the secondary replica(s) and ensure that the databases were added successfully.
13. On the server where SQL Diagnostic Manager is installed, restart the services listed below:
    1. IDERA Dashboard Core Service
    2. IDERA Dashboard Web Service
    3. SQLdm Collection Service
    4. SQLdm Management Service
    5. SQLdm Predictive Analytics Service
    6. SQLdm Rest Service

Validate SQL Diagnostic Manager configuration

1. To validate the SQL Diagnostic Manager configuration, launch the Desktop Client.
2. Go to > Manage License. In the New Key section, you should see the name of the listener and the port instead of the primary node name.
   
    
   
   If you see the listener and port as shown in the image above, you have successfully configured the repository databases in an availability group.

IDERA |  Products | Purchase | Support | Community | Resources | About Us | Legal