Azure Edsv4 based on the latest generation Intel CascadeLake CPU is now certified and supported for both Hana and NetWeaver AnyDB. Hana OLTP and OLAP are both certified.
The VM types available are:
VM Size |
vCPU |
RAM |
SAPS |
Hana Certification |
NW Certification |
Standard_E2ds_v4 |
2 |
16 |
3,142 |
- |
|
Standard_E4ds_v4 |
4 |
32 |
6,284 |
- |
|
Standard_E8ds_v4 |
8 |
64 |
12,569 |
- |
|
Standard_E16ds_v4 |
16 |
128 |
25,138 |
- |
|
Standard_E20ds_v4 |
20 |
160 |
31,422 |
|
|
Standard_E32ds_v4 |
32 |
256 |
50,275 |
|
|
Standard_E48ds_v4 |
48 |
384 |
75,413 |
|
|
Standard_E64ds_v4 |
64 |
504 |
100,550 |
|
|
Hana is certified for productive use on Eds_v4 VM sizes larger than E20ds_v4 in combination with Azure Storage options with the following conditions:
More information on Certification can be found in the SAP IaaS Hardware Certification Directory and more information about Hana Storage Configuration on Azure can be found here.
All Ev4 are certified and supported for NetWeaver on Azure Premium Storage and Azure UltraSSD Disk. Azure NetApp Filer service will be available for AnyDB later.
For a complete list of Certified VM Types for SAP Applications review SAP Note 1928533 - SAP Applications on Azure: Supported Products and Azure VM types
The check availability of these Virtual Machine types in nearby Azure Regions here
Note: As at July 2020 the Edsv4 and Ddsv4 only are supported. The Esv4 without an internal SSD disk is not supported.
The powershell script below can be used to confirm which VM types are available in an Azure region prior to deploying VMs. It is important to run this script using the actual subscription that host the VMs. After planning the VM Types and zones submit a quota request to begin deploying
Get-AzComputeResourceSku | where {$_.Locations.Contains("southeastasia") -and $_.LocationInfo[0].Zones -ne $null -and $_.ResourceType.Equals("virtualMachines")}
In the above example B-series is available in all 3 zones in Singapore, but Mv2 is available in zones 1 and 3.
Multi-SID clustering of up to 5 ASCS on the same two node cluster is now supported for both Suse and Redhat.
High availability for SAP NetWeaver on Azure VMs on SUSE Linux Enterprise Server for SAP applications multi-SID guide
High availability for SAP NetWeaver on Azure VMs on Red Hat Enterprise Linux for SAP applications multi-SID guide
It is highly recommended that prior to installing a Linux Multi-SID cluster a “test lab” installation is performed on some test VMs and great care must be taken to document IP address and port numbers.
Suse now supports the same STONITH mechanism that is implemented for Redhat. The Suse Pacemaker service is now able to connect to the Azure Fabric and restart a hung or fenced VM. This functionality requires an update to the Python/Python3 libraries and the package for the Azure SDK (python-azure-mgmt-compute on SLES12 ; python3-azure-mgmt-compute on SLES15).
After implementing these packages the Python versions can be verified via the commands
python --version
python3 --version
My colleague Anjan Banerjee has developed some very useful blogs based on real customer deployments. The topics for these blogs are based on questions from consultants. For example “Can I run Business Objects on SQL Azure DB PaaS?”.
SAP Single Sign-on : Kerberos/SPNEGO Setup for AS-JAVA
SAP On Azure : High-Availability Setup of SAP Content Server 7.53 with MaxDB in Windows Environment
SAP On Azure : HIGH AVAILIABILITY setup for SAP NETWEAVER with SAP ASE 16 DB on WINDOWS SERVER
The full list of blogs can be found here
Another useful blog from Etienne Dittrich can be found here
Several customer escalations have been traced to inadequate performance of the OS Boot Disk. Based on these support cases it is strongly recommended to use Premium Storage for the OS Boot Disk. The same limitations and constraints that exist for Standard storage and that are documented in SAP Note 2367194 - Use of Azure Premium SSD Storage for SAP DBMS Instance also apply to the OS Boot Disk.
The minimum recommended Premium Disk for a large high performance VM (such as E64v3 or higher) would be P15 or higher.
In extreme cases small OS Boot Disks using Standard storage can cause a VM to appear to freeze under high IO load.
Azure Storage options and features continue to expand and improve. Below is a brief list of features recently released and in preview:
https://www.suse.com/support/kb/doc/?id=7024299
https://www.suse.com/support/kb/doc/?id=7024298
A new blog will be released when Azure Files Premium for Windows and Linux is available for SAP customers
Modern releases of SQL Server supports direct backup to URL to multiple target blob files. The throughput to multiple blob files approach the Network Throughput Quota for a VM type. When the backup network traffic saturates the VM the VM may be unresponsive. Problems such as AlwaysOn initiating a failover may occur.
To prevent these issues the backup parameter MAXTRANSFERSIZE can be limited.
The precise value for MAXTRANSFERSIZE depends on the number of blob files, the VM size and other factors.
Test values MAXTRANSFERSIZE = 3145728 and monitor network throughput and stability. If the throughput is too high reduce the MAXTRANSFERSIZE value by half and retest.
BACKUP DATABASE <DB SID> TO
<URL PATH>
WITH COMPRESSION, BUFFERCOUNT = 4, MAXTRANSFERSIZE = 3145728, BLOCKSIZE = 65536, CHECKSUM, FORMAT, STATS = 5,
ENCRYPTION ( ALGORITHM = AES_256, SERVER CERTIFICATE = ' + @P_CERT +' );
Additional links are here and here
SQL Server 2019 is now Generally Available for NetWeaver systems. The minimum supported release for SAP applications is SQL Server 2019 CU3. It is generally recommended to apply the latest Support Pack and Cumulative Update available
New features in SQL Server 2019 can be found here
2779625 - Setting up Microsoft SQL Server 2019
2807743 - Release planning for Microsoft SQL Server 2019
2779607 - Configuration Parameters for SQL Server 2019
2922820 - DBSL Support for SQL Server 2019
2656107 - Support for Microsoft ODBC Drivers for SQL Server in SAP NetWeaver
Business Objects Supports both Windows Server 2019 and SQL Server 2019. In addition to SQL Server 2019 IaaS solution Azure SQL DB PaaS is fully supported for Windows platforms on SAP BO releases 4.2 SP8 and 4.3 and higher
In recent months many new features have become available for SAP customers. The list below is a very brief overview of recommended features and updated documentation
Azure Site Recovery is a very popular feature for SAP customers. The support matrix for Azure Site Recovery A2A can be found here
Use the “Find” function to search for support – for example to find “zone” to determine zone support.
ASR Azure to Azure now supports:
Transcontinental ASR (example: Primary in USA and DR in Europe) – contact Microsoft. Some customers have asked about “Tertiary ASR” which typically involves Zone-to-Zone ASR within a single region and then additional ASR to another Region. This is not possible as of July 2020.
Additional information on Azure Site Recovery for SAP solutions can be found here:
https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sap
The official SAP on Azure YouTube Channel contains a lot of Azure Data Factory, OData, PowerBI, Single Sign On, IoT Integration to SAP and other topics. Suggestions for additional topics for the YouTube channel can be posted in this blog or the YouTube channel comments section.
https://www.youtube.com/c/SAPonAzure/videos
Two interesting customer success stores are available. A large Pharmasuetical customer Zuellig Pharma moved their entire datacenter to Azure including a VLDB Suite on Hana system. This Suite on Hana system runs on Mv2 416 and 13 E32v3 application servers. The project was executed by T-Systems
A recent Press Release can be found here
Swiess Re has deployed a new S4 system on Azure. The partner was Cognizant – the SAP on Azure Microsoft Partner of the year 2020
The setup and configuration of SQL Server AlwaysOn has been fully automated and integrated into SWPM.
The previous versions of scripts such as sap_revlogin should not be used anymore as they may cause inconsistencies and support problems.
For all new installations, migrations, upgrades and homogeneous or heterogeneous system copies SAP Note 1772688 - SQL Server AlwaysOn and SAP applications should be followed.
Some recommended guidelines:
SAP has released Hana 2.0 Support Pack 5. New features can be found here
2932865 - SAP HANA 2 SPS05 Revision 050.00
2378962 - SAP HANA 2.0 Revision and Maintenance Strategy
2235581 - SAP HANA: Supported Operating Systems
SAP Monitor for Azure is now in Public Preview. Highly recommended to test this feature: https://azure.microsoft.com/en-us/blog/azure-monitor-for-sap-solutions-is-now-in-preview/
Learning Journey for SAP ASE
SAP ASE Learning Journey - Administration & Monitoring
SAP ASE Learning Journey - Installation & Upgrade
A utility to check the latency between Availability Zones
https://github.com/Azure/SAP-on-Azure-Scripts-and-Utilities/tree/master/AvZone-Latency-Test
SQL Server releases, support packs and cumulative updates
https://techcommunity.microsoft.com/t5/sql-server/bg-p/SQLServer/label-name/SQLReleases
Azure Backup for SAP Hana – support matrix
https://docs.microsoft.com/en-us/azure/backup/sap-hana-backup-support-matrix
https://docs.microsoft.com/en-us/azure/backup/backup-azure-vm-backup-faq
Recommended blog for Hana troubleshooting. Highly recommended to load scripts onto every Hana DB instance 1969700 – SQL Statement Collection for SAP HANA https://blogs.sap.com/2017/09/04/health-checks-of-hana-system/
Latest news about SAP Kernels
https://wiki.scn.sap.com/wiki/display/SI/SAP+Kernel%3A+Important+News
A very useful powershell script for parsing SAP NetWeaver trace files is below. Thanks to Ashley Zebrowski for providing this. Powershell is available for Windows and Linux https://docs.microsoft.com/en-us/powershell/azure/install-az-ps?view=azps-4.3.0
while($true) {
$s = Get-Content .\dev_w* | sls '<search string goes here>' -context 2 | out-string -stream | sls '2020'
$a = @()
foreach ($line in $s) {
$date = [datetime]::parseexact(($line -replace ' C ',''), 'ddd MMM dd HH:mm:ss:fff yyyy', $null)
$a += $date
}
clear
"Most recent connection drops:"
$a | sort -unique -descending | select -first 20 | %{$_.tostring('yyyy/MM/dd HH:mm:ss.fff K')}
}
Microsoft has released a new multi-platform RDP client that is highly recommended https://aka.ms/rdapps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.