Support expanded tempdb settings in azurerm_mssql_virtual_machine

[ScottAtTR]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

SQL Virtual Machines now support tempdb settings for specifying

• data file count
• data file initial size
• data file growth size
• log file size
• log file growth size

The below arm template fragment was when creating image MicrosoftSQLServer:sql2019-ws2019:enterprise-gen2:latest.

                "StorageConfigurationSettings": {
                    "DiskConfigurationType": "[parameters('sqlStorageDisksConfigurationType')]",
                    "StorageWorkloadType": "[parameters('sqlStorageWorkloadType')]",
                    "SQLDataSettings": {
                        "LUNs": "[parameters('dataDisksLUNs')]",
                        "DefaultFilePath": "[parameters('dataPath')]"
                    },
                    "SQLLogSettings": {
                        "LUNs": "[parameters('logDisksLUNs')]",
                        "DefaultFilePath": "[parameters('logPath')]"
                    },
                    "SQLTempDbSettings": {
                        "DefaultFilePath": "[parameters('tempDbPath')]",
                        "DataFileCount": "[parameters('dataFileCount')]",
                        "DataFileSize": "[parameters('dataFileSize')]",
                        "DataGrowth": "[parameters('dataGrowth')]",
                        "LogFileSize": "[parameters('logFileSize')]",
                        "LogGrowth": "[parameters('logGrowth')]",
                        "LUNs": "[parameters('tempDisksLUNs')]"
                    },
                    "SQLSystemDbOnDataDisk": "[parameters('SQLSystemDbOnDataDisk')]"
                }

New or Affected Resource(s)

• azurerm_mssql_virtual_machine

References

• https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?tabs=windows2016#new-vms

[tikicoder]

Looks like the first part of this is done, and just need merged in
#15835

I actually created an updated based on that PR to include this
https://github.com/tikicoder/terraform-provider-azurerm/blob/sql_virtual_machine-api-upgrade/internal/services/mssql/mssql_virtual_machine_resource.go

I am testing locally presuming it works I Will push the PR.

[tikicoder]

I have created a PR based on some testing that seems to fix the issue.
#15945
My PR builds on the other PR, why reinvent the wheel if the wheel just needs a few improvements.

[tikicoder]

@manicminer please let me know if I can help or if I need to reevaluate my PR.