dsccommunity / dsccommunity/SqlServerDsc
SqlAGReplica: SESSION_TIMEOUT parameter missing?
Nobody has claimed this yet.
- 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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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