dsccommunity / dsccommunity/SqlServerDsc
SqlSetup: Not supporting having tempdb on local disk for cluster install when SQL Server is 2012 an above
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Details of the scenario you try and problem that is occurring:
When doing a cluster install using SQL Server 2012 and above it is supported to have tempdb on local disks (instead if shared disks for older versions of SQL).
See article: https://logicalread.com/sql-server-tempdb-best-practices-placement-w01
The DSC configuration that is using the resource (as detailed as possible):
Configuration from issue #484
xSQLServerSetup ($Node.NodeName)
{
Action = "InstallFailoverCluster"
InstanceName = "MSSQLSERVER"
SetupCredential = $Credential
SourcePath = "c:\users\public\downloads\sql2016\source\"
Features = "SQLENGINE, REPLICATION, FULLTEXT, DQ"
InstanceID = "MSSQLSERVER"
UpdateEnabled = "True"
UpdateSource = "MU"
InstallSharedDir = "c:\Program Files\Microsoft SQL Server\"
InstallSharedWOWDir = "c:\Program Files (x86)\Microsoft SQL Server\"
InstanceDir = "C:\Program Files\Microsoft SQL Server\"
SQLSvcAccount = $SQLSvcAccount
AgtSvcAccount = $AgtSvcAccount
SQLCollation = "SQL_Latin1_General_CP1_CI_AS"
SQLSysAdminAccounts = "$SQLAdmin"
SecurityMode = "SQL"
SAPwd = $SACreds
InstallSQLDataDir = "W:\sql\binaries"
SQLUserDBDir = "W:\SQL\Data\COMMON"
SQLUserDBLogDir = "W:\SQL\Logs\LG_COMMON"
SQLTempDBDir = "H:\SQL\Data" # Local disk
SQLTempDBLogDir = "H:\SQL\Logs" # Local disk
FailoverClusterGroupName = "$FailoverClusterGroupName"
FailoverClusterIPAddress = "$FailoverClusterIPAddress"
FailoverClusterNetworkName = "$FailoverClusterNetworkName"
PsDscRunAsCredential = $Credential
}
Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
SQL Server 2012 and above
Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev
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 with the xSQLServerSetup configuration from issue #484, focusing on SQLTempDBDir and SQLTempDBLogDir when Action is InstallFailoverCluster. Check how SQL Server 2012 and later handle local tempdb paths during cluster installation. Done means the shown configuration installs successfully with tempdb data and log directories on local disks.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100