Document Details

$ResourceGroupName = "MyResourceGroup" $location = "MyRegion" $SAPSID = "PR2" $DiskSizeInGB = 512 $DiskName = "$($SAPSID)ASCSSharedDisk" $NumberOfWindowsClusterNodes = 2 # For SAP deployment in an availability set, use this storage SkuName value $SkuName = "Premium_LRS" # For SAP deployment in an availability zone, use this storage SkuName value $SkuName = "Premium_ZRS" $diskConfig = New-AzDiskConfig -Location $location -SkuName $SkuName -CreateOption Empty -DiskSizeGB $DiskSizeInGB -MaxSharesCount $NumberOfWindowsClusterNodes $dataDisk = New-AzDisk -ResourceGroupName $ResourceGroupName -DiskName $DiskName -Disk $diskConfig ################################## ## Attach the disk to cluster VMs ################################## # ASCS cluster VM1 $ASCSClusterVM1 = "pr1-ascs-10" # ASCS cluster VM2 $ASCSClusterVM2 = "pr1-ascs-11" # Next free LUN $LUNNumber = 1 # Add the Azure shared disk to Cluster Node 1 $vm = Get-AzVM -ResourceGroupName $ResourceGroupName -Name $ASCSClusterVM1 $vm = Add-AzVMDataDisk -VM $vm -Name $DiskName -CreateOption Attach -ManagedDiskId $dataDisk.Id -Lun $LUNNumber Update-AzVm -VM $vm -ResourceGroupName $ResourceGroupName -Verbose # Add the Azure shared disk to Cluster Node 2 $vm = Get-AzVM -ResourceGroupName $ResourceGroupName -Name $ASCSClusterVM2 $vm = Add-AzVMDataDisk -VM $vm -Name $DiskName -CreateOption Attach -ManagedDiskId $dataDisk.Id -Lun $LUNNumber Update-AzVm -VM $vm -ResourceGroupName $ResourceGroupName -Verbose

Get-Disk | Where-Object PartitionStyle -Eq "RAW" | Format-Table -AutoSize # Example output # Number Friendly Name Serial Number HealthStatus OperationalStatus Total Size Partition Style # ------ ------------- ------------- ------------ ----------------- ---------- --------------- # 3 Msft Virtual Disk Healthy Online 512 GB RAW

# List all disks Get-ClusterAvailableDisk -All # Example output # Cluster : pr1clust # Id : c469b5ad-d089-4d8f-ae4c-d834cbbde1a2 # Name : Cluster Disk 2 # Number : 3 # Size : 549755813888 # Partitions : {\\?\GLOBALROOT\Device\Harddisk3\Partition2\}

$SAPSID = "PR2" # SAP <SID> $SAPClusterGroup = "SAP $SAPSID" Move-ClusterGroup -Name $SAPClusterGroup

# Format SAP ASCS disk number 3, with drive letter S $SAPSID = "PR2" $DiskNumber = 3 $DriveLetter = "S" $DiskLabel = "$SAPSID" + "SAP" Get-Disk -Number $DiskNumber | Where-Object PartitionStyle -Eq "RAW" | Initialize-Disk -PartitionStyle GPT -PassThru | New-Partition -DriveLetter $DriveLetter -UseMaximumSize | Format-Volume -FileSystem ReFS -NewFileSystemLabel $DiskLabel -Force -Verbose # Example output # DriveLetter FileSystemLabel FileSystem DriveType HealthStatus OperationalStatus SizeRemaining Size # ----------- --------------- ---------- --------- ------------ ----------------- ------------- ---- # S PR2SAP ReFS Fixed Healthy OK 504.98 GB 511.81 GB

# Add the disk to the cluster Get-ClusterAvailableDisk -All | Add-ClusterDisk # Example output # Name State OwnerGroup ResourceType # ---- ----- ---------- ------------ # Cluster Disk 2 Online Available Storage Physical Disk

Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource -SAPSID PR2 -ProbePort 62002

Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource -SAPSID PR2 -ProbePort 62012 -IsSAPERSClusteredInstance $True

function Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource { <# .SYNOPSIS Set-AzureLoadBalancerHealthProbePortOnSAPClusterIPResource will set a new Azure Load Balancer health probe port on the SAP $SAPSID IP cluster resource. .DESCRIPTION Set-AzureLoadBalancerHealthProbePortOnSAPClusterIPResource will set a new Azure Load Balancer health probe port on the SAP $SAPSID IP cluster resource. It will also restart the SAP cluster group (default behavior), to activate the changes. You need to run it on one of the SAP ASCS/SCS Windows cluster nodes. The expectation is that the SAP group is installed with the official SWPM installation tool, which will set the default expected naming convention for: - SAP cluster group: SAP $SAPSID - SAP cluster IP address resource: SAP $SAPSID IP .PARAMETER SAPSID SAP SID - three characters, starting with a letter. .PARAMETER ProbePort Azure Load Balancer health check probe port. .PARAMETER RestartSAPClusterGroup Optional parameter. Default value is $True, so the SAP cluster group will be restarted to activate the changes. .PARAMETER IsSAPERSClusteredInstance Optional parameter. Default value is $False. If it's set to $True, then handle the clustered new SAP ERS2 instance. .EXAMPLE # Set the probe port to 62000 on SAP cluster resource SAP AB1 IP, and restart the SAP cluster group SAP AB1 to activate the changes. Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource -SAPSID AB1 -ProbePort 62000 .EXAMPLE # Set the probe port to 62000 on SAP cluster resource SAP AB1 IP. SAP cluster group SAP AB1 is not restarted, so the changes are not active. # To activate the changes, you need to manually restart the SAP AB1 cluster group. Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource -SAPSID AB1 -ProbePort 62000 -RestartSAPClusterGroup $False .EXAMPLE # Set the probe port to 62001 on SAP cluster resource SAP AB1 ERS IP. SAP cluster group SAP AB1 ERS is restarted to activate the changes. Set-AzureLoadBalancerHealthCheckProbePortOnSAPClusterIPResource -SAPSID AB1 -ProbePort 62000 -IsSAPERSClusteredInstance $True #> [CmdletBinding()] param( [Parameter(Mandatory=$True)] [ValidateNotNullOrEmpty()] [ValidateLength(3,3)] [string]$SAPSID, [Parameter(Mandatory=$True)] [ValidateNotNullOrEmpty()] [int] $ProbePort, [Parameter(Mandatory=$False)] [bool] $RestartSAPClusterGroup = $True, [Parameter(Mandatory=$False)] [bool] $IsSAPERSClusteredInstance = $False ) BEGIN{} PROCESS{ try{ if($IsSAPERSClusteredInstance){ #Handle clustered SAP ERS instance $SAPClusterRoleName = "SAP $SAPSID ERS" $SAPIPresourceName = "SAP $SAPSID ERS IP" }else{ #Handle clustered SAP ASCS/SCS instance $SAPClusterRoleName = "SAP $SAPSID" $SAPIPresourceName = "SAP $SAPSID IP" } $SAPIPResourceClusterParameters = Get-ClusterResource $SAPIPresourceName | Get-ClusterParameter $IPAddress = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "Address" }).Value $NetworkName = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "Network" }).Value $SubnetMask = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "SubnetMask" }).Value $OverrideAddressMatch = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "OverrideAddressMatch" }).Value $EnableDhcp = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "EnableDhcp" }).Value $OldProbePort = ($SAPIPResourceClusterParameters | Where-Object {$_.Name -eq "ProbePort" }).Value $var = Get-ClusterResource | Where-Object { $_.name -eq $SAPIPresourceName } #Write-Host "Current configuration parameters for SAP IP cluster resource '$SAPIPresourceName' are:" -ForegroundColor Cyan Write-Output "Current configuration parameters for SAP IP cluster resource '$SAPIPresourceName' are:" Get-ClusterResource -Name $SAPIPresourceName | Get-ClusterParameter Write-Output " " Write-Output "Current probe port property of the SAP cluster resource '$SAPIPresourceName' is '$OldProbePort'." Write-Output " " Write-Output "Setting the new probe port property of the SAP cluster resource '$SAPIPresourceName' to '$ProbePort' ..." Write-Output " " $var | Set-ClusterParameter -Multiple @{"Address"=$IPAddress;"ProbePort"=$ProbePort;"Subnetmask"=$SubnetMask;"Network"=$NetworkName;"OverrideAddressMatch"=$OverrideAddressMatch;"EnableDhcp"=$EnableDhcp} Write-Output " " #$ActivateChanges = Read-Host "Do you want to take restart SAP cluster role '$SAPClusterRoleName', to activate the changes (yes/no)?" if($RestartSAPClusterGroup){ Write-Output "" Write-Output "Activating changes..." Write-Output " " Write-Output "Taking SAP cluster IP resource '$SAPIPresourceName' offline ..." Stop-ClusterResource -Name $SAPIPresourceName sleep 5 Write-Output "Starting SAP cluster role '$SAPClusterRoleName' ..." Start-ClusterGroup -Name $SAPClusterRoleName Write-Output "New ProbePort parameter is active." Write-Output " " Write-Output "New configuration parameters for SAP IP cluster resource '$SAPIPresourceName':" Write-Output " " Get-ClusterResource -Name $SAPIPresourceName | Get-ClusterParameter }else { Write-Output "SAP cluster role '$SAPClusterRoleName' is not restarted, therefore changes are not activated." } } catch{ Write-Error $_.Exception.Message } } END {} }