SQL Servers

KMG-WLPP-SQL01

Build Notes

Properties
Monitoring
Capabilities	8
Recommendations	10
Tutorials

Virtual machine
Computer name	KMG-WLPP-SQL01
Operating system	Windows (Windows Server 2022 Datacenter)
VM generation	V2
VM architecture	x64
Agent status	Ready
Agent version	2.7.41491.1149
Hibernation	Disabled
Host group	-
Host	-
Proximity placement group	-
Colocation status	N/A
Capacity reservation group	-
Disk controller type	SCSI

Azure Spot
Azure Spot	-
Azure Spot eviction policy	-

Availability + scaling
Availability zone	1
Extended zone	-
Availability set	-
Scale Set	-

Security
Security type	Trusted launch
Enable secure boot	Enabled
Enable vTPM	Enabled
Integrity monitoring	Disabled

Health monitoring
Health monitoring	Enabled

Extensions + applications
Extensions	AADLogin, HealthExtension, Microsoft.Insights.VMDiagnosticsSettings, SqlIaasExtension
Applications	-

Networking
Public IP address	-
Public IP address (IPv6)	-
Private IP address	10.100.101.101
Private IP address (IPv6)	-
Virtual network/subnet	KMG-WLPP-VN01/PROD_DB
DNS name	-

Size
Size	Standard B8as v2
vCPUs	8
RAM	32 GiB

Source image details
Source image publisher	microsoftsqlserver
Source image offer	sql2022-ws2022
Source image plan	standard-gen2

Disk
OS disk	KMG-WLPP-SQL01_OsDisk_1_c6b439a399c0496ea46d52ef5315b160
Encryption at host	Disabled
Azure disk encryption	Not enabled
Ephemeral OS disk	N/A
Data disks	2

Auto-shutdown
Auto-shutdown	Not enabled
Scheduled shutdown	-

VM Details

Details

Disk Details

Details

Automation Template

Template

KMG-WLPP-SQL02

Build Notes

Properties
Monitoring
Capabilities	8
Recommendations	5
Tutorials

Virtual machine
Computer name	KMG-WLPP-SQL02
Operating system	Windows (Windows Server 2022 Datacenter)
VM generation	V2
VM architecture	x64
Agent status	Ready
Agent version	2.7.41491.1149
Hibernation	Disabled
Host group	-
Host	-
Proximity placement group	-
Colocation status	N/A
Capacity reservation group	-
Disk controller type	SCSI

Azure Spot
Azure Spot	-
Azure Spot eviction policy	-

Availability + scaling
Availability zone	2
Extended zone	-
Availability set	-
Scale Set	-

Security
Security type	Trusted launch
Enable secure boot	Enabled
Enable vTPM	Enabled
Integrity monitoring	Disabled

Health monitoring
Health monitoring	Enabled

Extensions + applications
Extensions	AADLoginForWindows, HealthExtension, Microsoft.Insights.VMDiagnosticsSettings, SqlIaasExtension
Applications	-

Networking
Public IP address	-
Public IP address (IPv6)	-
Private IP address	10.100.101.102
Private IP address (IPv6)	-
Virtual network/subnet	KMG-WLPP-VN01/PROD_DB
DNS name	-

Size
Size	Standard B8as v2
vCPUs	8
RAM	32 GiB

Source image details
Source image publisher	microsoftsqlserver
Source image offer	sql2022-ws2022
Source image plan	standard-gen2

Disk
OS disk	KMG-WLPP-SQL02_OsDisk_1_7aa46dcd346149ac83d669beea4b805d
Encryption at host	Disabled
Azure disk encryption	Not enabled
Ephemeral OS disk	N/A
Data disks	2

Auto-shutdown
Auto-shutdown	Not enabled
Scheduled shutdown	-

VM Details

Disk Details

Automation Template

Template

{
    "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
        "extensions_Microsoft_Insights_VMDiagnosticsSettings_xmlCfg": {
            "type": "SecureString"
        },
        "extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountName": {
            "type": "SecureString"
        },
        "extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountKey": {
            "type": "SecureString"
        },
        "extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountEndPoint": {
            "type": "SecureString"
        },
        "virtualMachines_KMG_WLPP_SQL02_name": {
            "defaultValue": "KMG-WLPP-SQL02",
            "type": "String"
        },
        "disks_KMG_WLPP_SQL02_OsDisk_1_7aa46dcd346149ac83d669beea4b805d_externalid": {
            "defaultValue": "/subscriptions/c192f809-f6a4-4462-969a-00ddb9ba8354/resourceGroups/KMG-WLPP-In-Between/providers/Microsoft.Compute/disks/KMG-WLPP-SQL02_OsDisk_1_7aa46dcd346149ac83d669beea4b805d",
            "type": "String"
        },
        "disks_KMG_WLPP_SQL02_DataDisk_0_externalid": {
            "defaultValue": "/subscriptions/c192f809-f6a4-4462-969a-00ddb9ba8354/resourceGroups/KMG-WLPP-In-Between/providers/Microsoft.Compute/disks/KMG-WLPP-SQL02_DataDisk_0",
            "type": "String"
        },
        "disks_KMG_WLPP_SQL02_DataDisk_1_externalid": {
            "defaultValue": "/subscriptions/c192f809-f6a4-4462-969a-00ddb9ba8354/resourceGroups/KMG-WLPP-In-Between/providers/Microsoft.Compute/disks/KMG-WLPP-SQL02_DataDisk_1",
            "type": "String"
        },
        "networkInterfaces_kmg_wlpp_sql02409_z2_externalid": {
            "defaultValue": "/subscriptions/c192f809-f6a4-4462-969a-00ddb9ba8354/resourceGroups/KMG-WLPP-In-Between/providers/Microsoft.Network/networkInterfaces/kmg-wlpp-sql02409_z2",
            "type": "String"
        }
    },
    "variables": {},
    "resources": [
        {
            "type": "Microsoft.Compute/virtualMachines",
            "apiVersion": "2024-07-01",
            "name": "[parameters('virtualMachines_KMG_WLPP_SQL02_name')]",
            "location": "westeurope",
            "tags": {
                "Department": "DigitalDevelopment"
            },
            "zones": [
                "2"
            ],
            "identity": {
                "type": "SystemAssigned"
            },
            "properties": {
                "hardwareProfile": {
                    "vmSize": "Standard_B8as_v2"
                },
                "additionalCapabilities": {
                    "hibernationEnabled": false
                },
                "storageProfile": {
                    "imageReference": {
                        "publisher": "microsoftsqlserver",
                        "offer": "sql2022-ws2022",
                        "sku": "standard-gen2",
                        "version": "latest"
                    },
                    "osDisk": {
                        "osType": "Windows",
                        "name": "[concat(parameters('virtualMachines_KMG_WLPP_SQL02_name'), '_OsDisk_1_7aa46dcd346149ac83d669beea4b805d')]",
                        "createOption": "FromImage",
                        "caching": "ReadWrite",
                        "managedDisk": {
                            "storageAccountType": "Premium_LRS",
                            "id": "[parameters('disks_KMG_WLPP_SQL02_OsDisk_1_7aa46dcd346149ac83d669beea4b805d_externalid')]"
                        },
                        "deleteOption": "Detach",
                        "diskSizeGB": 127
                    },
                    "dataDisks": [
                        {
                            "lun": 0,
                            "name": "[concat(parameters('virtualMachines_KMG_WLPP_SQL02_name'), '_DataDisk_0')]",
                            "createOption": "Attach",
                            "caching": "ReadOnly",
                            "writeAcceleratorEnabled": false,
                            "managedDisk": {
                                "storageAccountType": "Premium_LRS",
                                "id": "[parameters('disks_KMG_WLPP_SQL02_DataDisk_0_externalid')]"
                            },
                            "deleteOption": "Detach",
                            "diskSizeGB": 1024,
                            "toBeDetached": false
                        },
                        {
                            "lun": 1,
                            "name": "[concat(parameters('virtualMachines_KMG_WLPP_SQL02_name'), '_DataDisk_1')]",
                            "createOption": "Attach",
                            "caching": "None",
                            "writeAcceleratorEnabled": false,
                            "managedDisk": {
                                "storageAccountType": "Premium_LRS",
                                "id": "[parameters('disks_KMG_WLPP_SQL02_DataDisk_1_externalid')]"
                            },
                            "deleteOption": "Detach",
                            "diskSizeGB": 256,
                            "toBeDetached": false
                        }
                    ],
                    "diskControllerType": "SCSI"
                },
                "osProfile": {
                    "computerName": "[parameters('virtualMachines_KMG_WLPP_SQL02_name')]",
                    "adminUsername": "kmgadmin",
                    "windowsConfiguration": {
                        "provisionVMAgent": true,
                        "enableAutomaticUpdates": false,
                        "patchSettings": {
                            "patchMode": "Manual",
                            "assessmentMode": "ImageDefault",
                            "enableHotpatching": false
                        }
                    },
                    "secrets": [],
                    "allowExtensionOperations": true,
                    "requireGuestProvisionSignal": true
                },
                "securityProfile": {
                    "uefiSettings": {
                        "secureBootEnabled": true,
                        "vTpmEnabled": true
                    },
                    "securityType": "TrustedLaunch"
                },
                "networkProfile": {
                    "networkInterfaces": [
                        {
                            "id": "[parameters('networkInterfaces_kmg_wlpp_sql02409_z2_externalid')]",
                            "properties": {
                                "deleteOption": "Detach"
                            }
                        }
                    ]
                },
                "diagnosticsProfile": {
                    "bootDiagnostics": {
                        "enabled": true
                    }
                }
            }
        },
        {
            "type": "Microsoft.Compute/virtualMachines/extensions",
            "apiVersion": "2024-07-01",
            "name": "[concat(parameters('virtualMachines_KMG_WLPP_SQL02_name'), '/Microsoft.Insights.VMDiagnosticsSettings')]",
            "location": "westeurope",
            "dependsOn": [
                "[resourceId('Microsoft.Compute/virtualMachines', parameters('virtualMachines_KMG_WLPP_SQL02_name'))]"
            ],
            "tags": {
                "Department": "DigitalDevelopment"
            },
            "properties": {
                "autoUpgradeMinorVersion": true,
                "publisher": "Microsoft.Azure.Diagnostics",
                "type": "IaaSDiagnostics",
                "typeHandlerVersion": "1.5",
                "settings": {
                    "StorageAccount": "wlppstor01",
                    "xmlCfg": "[parameters('extensions_Microsoft_Insights_VMDiagnosticsSettings_xmlCfg')]"
                },
                "protectedSettings": {
                    "storageAccountName": "[parameters('extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountName')]",
                    "storageAccountKey": "[parameters('extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountKey')]",
                    "storageAccountEndPoint": "[parameters('extensions_Microsoft_Insights_VMDiagnosticsSettings_storageAccountEndPoint')]"
                }
            }
        }
    ]
}