Page History

...

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.
   Image RemovedImage Added
3. Accept the terms and conditions of the End-User License Agreement, and click Next.
   Image Removed Image Added 
   
   
4. Select the SQLDM Console, SQLDM Services and Repository, and the IDERA Dashboard components SQLDM Web Console components and click Next.
   Image Removed Image Added 
   
   
5. Enter the credential to be used by the IDERA services and click Next.
   Image Removed Image Added 
   
   
6. Review the ports that are to be used by the IDERA Dashboard SQLDM Web Console services and click Next.
   Image Removed Image Added 
   
   
7. In the IDERA Dashboard Repository Database screen specify the listener name Specify the SQL Server instance and database name for the SQL Diagnostic Manager Repository and click Next.
   Image Removed
   Specify the listener name Image Added 
   
   

8. In case you want to monitor more than one SQL Diagnostic Manager installation, check the Use Index Database checkbox, specify the SQL Server instance and database name

   for the SQL Diagnostic Manager Repository Database

   , set the credential configuration of your preference, and click Next.

   
   Image Removed

   Otherwise, skip this step by clicking Next.
   Image Added 
   

9. Provide the installation directory for the

   IDERA Dashboard

   SQL DM Web Console and SQL Diagnostic Manager

   , enter a Display name, check the availability of the name,

   and click Next.

   Image Removed  Image Added 
   
   
10. If the specified paths do not exist on the system, the following window prompts. Click Yes to proceed.
    Image Modified
    
    
11. Click Install to start the installation.
    Image Removed Image Added 
    
    
12. After the installation has been completed, disable the Launch IDERA SQL Diagnostic Manager checkbox and click Finish.

Image RemovedImage Added

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.
   Image Modified
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.
   Image Modified
   
   
6. On the Select Database tab, select the IderaDashboardRepository and SQLdmRepository databases, and click Next.
   Image Modified
   
   
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.
   Image Modified
   
   
10. On the Summary screen, verify the actions you selected in the previous steps, and click Finish.
    Image Modified
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

...

1. To validate the SQL Diagnostic Manager configuration, launch the Desktop Client.
2. Go to Image Removed Image Added > 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.

...