Share this page

# SQL server Always On support

The SQL Server Always On availability groups (AG) solution is supported. When you create a schema, a database backup is created and added to the availability group. This solution ensures that you can still use the system when a database fails, because the system switches automatically and seamlessly to a backup.

In this topic:

## Overview of SQL Server AG support

The SQL Server AG feature is a high-availability disaster-recovery solution. This solution ensures a failover environment for a discrete set of databases. This solution maximizes the availability of a set of databases at the enterprise level.

Only the high availability groups are supported. Read-scale availability groups are not supported.

For details about this availability feature, see the Microsoft documentation.

Back to top

## Before you use the solution

Before you migrate projects to your availability group in the production environment, try it in your test environment and do performance test to make sure the SQL Server Always on group cluster is capable of the workload.

Task | Details
--- | ---
Prioritize the projects to migrate | For a 4 core SQL Server Always on availability group instance, to avoid worker thread exhaustion, we recommend the maximum number of active projects is 70. Therefore, prioritize the projects to migrate. Focus on your important projects that cannot afford downtime. The project number limit is decided by the max worker threads used by Always On availability groups. For details about max worker threads, see the Microsoft documentation about "Prerequisites, Restrictions, and Recommendations for Always On availability groups" and "Configure the max worker threads Server Configuration Option".
Extra disk and network I/O performance buffer | You need to have extra disk and network I/O performance buffer in your SQL Server availability group cluster. Do performance tests after you migrate projects to your test environment to make sure the SQL Server Always On group cluster can handle your workload.

Back to top

## Prerequisites

Prepare the following before enabling the SQL Server AG support.

- Set up an SQL Server Always On availability group listener and an availability group cluster.

- The system connects to the group listener with JDBC. Make sure the database user has all the permissions, which are described in the User Permissions for Connecting to a Microsoft SQL Database Server section of the installation guide. See Install.

- If you are using SQL authentication, sync the SQL Server login user "td" from OpenText Application Quality Management to all the replicas before creating or importing projects in your Always On availability group.

Back to top

## Enable SQL Server AG support

To enable the SQL Server AG support, add the following connection properties in the SQL Server connection URL.

Property | Description
--- | ---
multiSubnetFailover | Set this property to true when you connect to the group listener. This is required by SQL Server JDBC.
alwaysOnGroup | Set this property to your availability group name. The property value tells whether the projects that are connected to the current database server are in Always On mode.
backupFolder | Set this property to the path of your backup folder on the SQL Server instances. All SQL Server instances must use the same path. Note: In Windows, end the path with a backward slash (\). In Linux, end it with a forward slash (/).

SQL Server connection URL example:

Copy code

    jdbc:sqlserver://192.168.0.10;multiSubnetFailover=true;
    alwaysOnGroup=alm_ag;backupFolder=\\storage01\SQLServerSync\

Back to top

## Migrate a project to AG

Use one of the following methods to migrate a project to your availability group.

- Export the project and then import it.

  For details, see Export a project and Create a project by importing from a project file.

- Restore the project and update the database user information:

  1. Restore the project. For details, see Restore backed up projects.

  2. Copy the project database to the Always On primary instance.

  3. Fully back up the project database (use the full recovery model) and run the following SQL command to update the database user information.

     The user "td" is for SQL authentication mode and the user "dbo" is for Windows authentication mode.

     Copy code

         use yourdb;
         exec sp_change_users_login 'Update_One','td','td';
         exec sp_change_users_login 'Update_One','dbo','dbo';

  4. Add the database to your Always On availability group, and wait until it shows "synchronized" on all the replicas. Then you can use or upgrade your project.

Back to top

## Troubleshooting

You may encounter the following issues when using the SQL Server Always On availability groups solution.

Issue | Cause and Solution
--- | ---
Unable to connect to your project or restart the system after Always On availability groups failover. | This usually happens if you haven’t synchronized the SQL Server login user "td" to all the replicas of the group. If you are using the SQL Server SQL password authentication, make sure the SID of the user "td" is identical on every replica.
Unable to convert your project to Unicode. | You need to convert the project to Unicode before migrating it to an availability group. Alternatively, you need to select the Unicode project option when you create the project. After the project is created, you can’t convert it to Unicode in an availability group.
After you delete a project in Site Administration, its status is displayed as restoring in secondary replicas. | The project database needs to be dropped manually by your DBA in secondary replicas after you delete a project.

Back to top

See also:

- Verify, repair, upgrade, and restore projects

https://admhelp.microfocus.com Application Quality Management 8942
Tips to improve your search results... OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help 26.1 All View Local Help Center View Online Help Center Version: