dsccommunity / dsccommunity/SqlServerDsc

SqlAGReplica: SESSION_TIMEOUT parameter missing?

Open
#1,238 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement help wanted
Dominant language
PowerShell
Stars
385
Forks
224
PR merge metrics
No merged PRs in 30d

Description

ISSUE TITLE:
SqlAGReplica: SESSION_TIMEOUT parameter missing

ISSUE DESCRIPTION:
I don't see SessionTimeout parameter added. Is it part of any other resource?

Details of the scenario you tried and the problem that is occurring

Using 11.4.0.0

Verbose logs showing the problem

None

Suggested solution to the issue

NA

The DSC configuration that is used to reproduce the issue
    SqlAGReplica "AddReplica"
    {
        Ensure                     = 'Present'
        Name                       = node
        AvailabilityGroupName      = agname
        ServerName                 = nodename
        InstanceName               = sqlinstance
        PrimaryReplicaServerName   = nodename
        PrimaryReplicaInstanceName = nodename
        FailoverMode               = "Automatic"
        AvailabilityMode           = "SynchronousCommit"
    }
SQL Server edition and version the target node is running

SQL Server 2016

SQL Server PowerShell modules present on the target node

Name Version Path
SqlServer 21.0.17279 C:\Program Files\WindowsPowerShell\Modules\SqlServer\21.0.17279\SqlServer.psd1

The operating system the target node is running

OsName : Microsoft Windows Server 2016 Standard
OsOperatingSystemSKU : StandardServerEdition
OsArchitecture : 64-bit
WindowsBuildLabEx : 14393.2430.amd64fre.rs1_release_inmarket_aim.180806-1810
OsLanguage : en-US
OsMuiLanguages : {en-US}

Version and build of PowerShell the target node is running

Name Value
PSVersion 5.1.14393.2430
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14393.2430
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

Version of the DSC module that was used

Name Version Path
SqlServerDsc 11.4.0.0 C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\11.4.0.0\SqlServerDsc.psd1

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start at the SqlAGReplica resource and its parameter definitions, then compare the requested SESSION_TIMEOUT setting with the SQL Server 2016 availability-replica options and the installed SqlServer module. Confirm whether the resource should expose this setting; done means the supported or unsupported status is documented and any required resource coverage is updated.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell, sql
Domain
databases, devops
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.