dsccommunity / dsccommunity/SqlServerDsc

Support for SQL Server 2016 - Tempdb files extra options during install

Open
#459 6 comments 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

I'm currently trying to install SQL Server 2016 using 6.x version of the xSQLServer module on a Win 2012 R2 using powershell 5.1. In this version some new flags have been added to create tempdb in a much more efficient way:

/SQLTEMPDBFILECOUNT=”8″ /SQLTEMPDBFILESIZE=”16″ /SQLTEMPDBFILEGROWTH=”256″ /SQLTEMPDBDIR=”C:\tempdb” “D:\tempdb” /SQLTEMPDBLOGFILESIZE=”256″ /SQLTEMPDBLOGFILEGROWTH=”0″ /SQLTEMPDBLOGDIR=”E:\tempdblog”

Are there any plans to add this to xSQLServerSetup?
Would be a great add!

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 by locating the xSQLServerSetup entry point and reviewing how it constructs SQL Server installation options. Add support for the listed SQL Server 2016 tempdb file, size, growth, and directory options, with completion demonstrated by coverage for the new installation behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell, sql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.