Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 EnterpriseSQL Server 2016 Developer More

Improvement


This improvement enables you to configure SESSION_TIMEOUT value for a Distributed Availability Group (DAG) replica in Microsoft SQL Server 2016 and 2017. Before installing this update, when you try to change SESSION_TIMEOUT value, you may receive the following error message:


Msg 155, Level 15, State 1, Line LineNumber
'SESSION_TIMEOUT' is not a recognized ALTER AVAILABILITY GROUP option.

After applying this update, you can configure the SESSION_TIMEOUT value. For example:

CREATE AVAILABILITY GROUP [distributedag]

   WITH (DISTRIBUTED)

   AVAILABILITY GROUP ON

      'cag' WITH

   (

         LISTENER_URL = 'tcp://SQLServerName:5022',

         AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,

         FAILOVER_MODE = MANUAL,

         SEEDING_MODE = AUTOMATIC,

              SESSION_TIMEOUT = 10

      ),

      'nag' WITH

      (

         LISTENER_URL = 'tcp://SQLServerName:5022',

         AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,

         FAILOVER_MODE = MANUAL,

         SEEDING_MODE = AUTOMATIC,

               SESSION_TIMEOUT = 10

      );

GO

Resolution


Hotfix information

Hotfix for SQL Server 2016 SP1

A supported update is available. We recommend that all customers apply this update.

On-demand hotfix update package for SQL Server 2016 SP1

Cumulative update for SQL Server:

This issue is fixed in the following cumulative updates for SQL Server:

        Cumulative update 7 for SQL Server 2017

        Cumulative Update 2 for SQL Server 2016 SP2

        Cumulative Update 10 for SQL Server 2016 SP1

References


Learn about the terminology that Microsoft uses to describe software updates.