Page History

This procedure guides The following steps guide you through the installation of installing 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.
   Image Added
3. Accept the terms and conditions of the End-User License Agreement, and click Next.
   Image Added
   
   
4. Select the SQLDM Console, SQLDM Services and Repository, and the IDERA Dashboard components and click Next.
   Image Added
   
   
5. Enter the credential to be used by the IDERA services and click Next.
   Image Added
   
   
6. Review the ports that are to be used by the IDERA Dashboard services and click Next.
   Image Added
   
   
7. In the IDERA Dashboard Repository Database screen specify the listener name and database name and click Next.
   Image Added
   
   
8. Specify the listener name and database name for the SQL Diagnostic Manager Repository Database and click Next.
   Image Added
   
   
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.
   Image Added
   
   
10. If the specified paths do not exist on the system, the following window prompts. Click Yes to proceed.
    Image Added
    
    
11. Click Install to start the installation.
    Image Added
    
    
12. After the installation has completed, disable the Launch IDERA SQL Diagnostic Manager checkbox and click Finish.

Image 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 Added
3. Perform a full backup of the IderaDashboardRepository and SQLdmRepository databases.
4. Right-click the appropriate availability group and select Add Database...
   Image Added
5. On the Introduction screen of the Add Database to Availability Group wizard, click Next.
   Image Added
   
   
6. On the Select Database tab, select the IderaDashboardRepository and SQLdmRepository databases, and click Next.
   Image Added
   
   
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 Added
   
   
10. On the Summary screen, verify the actions you selected in the previous steps, and click Finish.
    Image Added
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 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.
   
   Image Added
   
   If you see the listener and port as shown in the image above, you have successfully configured the repository databases in an availability group

1. Deploy the SQL Diagnostic Manager Repository targeting a node that is part of an availability group. For example, Node 1\Instance A.
2. Move the SQL Diagnostic Manager Repository to an availability group in the primary replica with Listener Y and port 300 (as example). To review how to create an availability group, see Microsoft document Creating and Configuring a New Availability Group.
3. A new license key for Listener Y, Port 300 is required. See Capturing an availability group's listener name and port designation to send your request to IDERA Sales.
Using the SQLdm Management Service Configuration wizard modify the target repository to Listener Y, port 300.
Image RemovedSave changes, and then restart the SQL Diagnostic Manager services. This process takes approximately 5 minutes.
Image Removed
4. Upon opening the SQL Diagnostic Manager Console, the system recognizes that you are trying to access the selected node without the proper license and throws an error message.
5. Click the Manage Licenses button of the error message and type the new license for Listener Y, Port 300. Open the SQL Diagnostic Manager Console, go to Help > Manage Licenses in the Toolbar menu, and the License Keys window displays. Type the new license key in the available space, and then click Enter.