SqlSetup: Missing Configuration Feature/Options : Tempdb File Configuration #1167
Comments
johlju
added
enhancement
|
@johlju could you please move this card to In Progress. |
|
@mdaniou Done! 😃 |
|
👍 |
|
@mdaniou In my private repo I have a tempdb class that now using to configure tempdb, happy to bring this to the party but may need some assistance in meeting your code standards and converting it to run as DSC. Happy to discuss |
johlju
added
in progress
|
@johlju see tempdb.ps1 |
|
@SQLHorizons love to look at that, but that link goes to a private repo (I got the invite, but haven't accepted yet) - since @mdaniou is working on this I think it would be better if you could share the code (and obfuscated any sensitive information) in a public gist, and under MIT license (add a LICENSE.md file to the gist as well). Then @mdaniou could see if it help him in his work. @mdaniou how are your progression with this issue? No rush, just curious 😃 |
|
Hi @SQLHorizons @johlju, I didn't start it yet. So feel free to take this on board. I was planning to work on it in October as I need to deploy a new environment under SQL2016 |
|
Was looking for this feature, so would be awesome when it is supported. Keep up the good work guys :) |
|
Don't worry I need it too asap so I'll get into this one during October hopefully. |
|
@mdaniou @johlju gist can be found here: https://gist.github.com/SQLHorizons/74d1ca7856a5c243f0ddebb73dfeabf3 |
|
@SQLHorizons Thanks for that! @mdaniou did the code help you in any way? |
|
@johlju I love the way @SQLHorizons uses the class to configure tempdb. I'll see what I can pick from the code however, I don't want to over-engineer it. I think that I should just add few rows like for the other switches. The simpler the better. |
|
@mdaniou Agreed. If we need maintain the tempdb there should be a new resource that does that. |
- Changes to SqlSetup
- Add parameters to configure the Tempdb files during the installation of the instance.
The new parameters are SqlTempdbFileCount, SqlTempdbFileSize, SqlTempdbFileGrowth,
SqlTempdbLogFileSize and SqlTempdbLogFileGrowth (issue #1167).
Details of the scenario you tried and the problem that is occurring
This issue is created to bring some improvements to the SqlSetup DSC Configuration. The idea is to report all the missing options in the resource to be allow the installation of all the features and to use all the options available in the SQL Server installer.
Options to add to the DSC Resource :
/SQLTEMPDBFILECOUNT
/SQLTEMPDBFILESIZE
/SQLTEMPDBFILEGROWTH
/SQLTEMPDBLOGFILESIZE
/SQLTEMPDBLOGFILEGROWTH
The DSC configuration that is using the resource (as detailed as possible)
SqlSetup
Version of the operating system and PowerShell the target node is running
Windows Server 2012/2012R2/2016
SQL Server edition and version the target node is running
SQL Server 2016/2017
What SQL Server PowerShell modules, and which version, are present on the target node.
Most recent version
Version of the DSC module you're using, or write 'dev' if you're using current dev branch
Most recent version
The text was updated successfully, but these errors were encountered: