pact - detailed design v1.3
TRANSCRIPT
-
8/16/2019 PACT - Detailed Design v1.3
1/52
PACT SAP Prod to Azure Project
Azure Detailed Design
-
8/16/2019 PACT - Detailed Design v1.3
2/52
Page ii
The descriptions of other companies’ products in this document, if an y, are provided only as a convenience to you. Any such references should not be considered an
endorsement or support by BNW Consulting, and BNW Consulting cannot guarantee their accuracy, and the products may change over time. Also, the descriptions are intended
as brief highlights to aid understanding, rather than as thorough coverage. For authoritative descriptions of these products, please consult their respective manufacturers.
This deliverable is provided AS IS without warranty of any kind a nd BNW MAKES NO WARRANTIES, EXPRESS OR IMPLIED, OR OTHERWISE.
All trademarks are the property of their respective companies.
Microsoft® and Windows® are either registered trademarks or trademarks of BNW Corporation in the United States and/or other countries, SAP® is either a trademark or aregistered trademark of SAP AG Germany.
The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
-
8/16/2019 PACT - Detailed Design v1.3
3/52
Part I: Contents
Part II: Information ........................................................................................................................................ 5
1 This Document .............................................................................................................................................................. 5
2 Version Control .............................................................................................................................................................. 5
3 Document Sign-Off ........................................................................................................................................................ 5
4 Reference Documents ................................................................................................................................................... 6
5 Glossary of terms .......................................................................................................................................................... 6
Part III: High-Level Summary .................................................................................................................. 7
1 SAP Azure Support Prerequisites .................................................................................................................................. 7
2 QA to Replace Pre-Prod ................................................................................................................................................ 7
3 Target Landscape Overview .......................................................................................................................................... 8
Part IV: Naming Conventions ................................................................................................................ 10
1 Datacenter Naming...................................................................................................................................................... 10
2 Landscape Naming...................................................................................................................................................... 10
3 Virtual Machine Naming............................................................................................................................................... 10
4 Azure Resources Naming ............................................................................................................................................ 11
Part V: SAP Server Hardening .................................................................................................................... 12
1 Management Stations .................................................................................................................................................. 12
2 RDP Port ..................................................................................................................................................................... 12
3 Rename local administrator account ............................................................................................................................ 12
Part VI: Windows Installations .............................................................................................................. 13 1 Windows Release Information ..................................................................................................................................... 13
2 Windows Settings ........................................................................................................................................................ 13
Part VII: Datacentre Replication for Azure ............................................................................................ 16
1 Database Replication to Azure .................................................................................................................................... 16
2 SAP Central Services Replication ................................................................................................................................ 16
3 SAP Application Servers Replication ........................................................................................................................... 16
4 SAP MaxDB Replication .............................................................................................................................................. 16
5 Azure Files Replication ................................................................................................................................................ 17
6 Other Replication Requirements .................................................................................................................................. 17
Part VIII: Azure Design ............................................................................................................................. 18
1 Resource Group .......................................................................................................................................................... 18
2 Public IP Addresses .................................................................................................................................................... 18
3 Network Security Group............................................................................................................................................... 18
-
8/16/2019 PACT - Detailed Design v1.3
4/52
4 Virtual Network ............................................................................................................................................................ 19
5 Storage Accounts ........................................................................................................................................................ 20
6 Availability Sets ........................................................................................................................................................... 22
7 Virtual Machine Storage .............................................................................................................................................. 22
8 Virtual Machines .......................................................................................................................................................... 23
9 Azure Internal Load Balancers ..................................................................................................................................... 29
10 Azure Resource Tagging ......................................................................................................................................... 30
11 Azure Backup Strategy............................................................................................................................................ 30
Part IX: SQLSERVER Instance Design ................................................................................................. 31
1 SQLSERVER Instance and Database Installation........................................................................................................ 31
2 SQLSERVER Cluster Setup ........................................................................................................................................ 36
3 SQLServer Backup Strategy ........................................................................................................................................ 38
Part X: SAP System Design ........................................................................................................................ 39
1 SAP Instance Installation ............................................................................................................................................. 39
2 SAP Binaries ............................................................................................................................................................... 40
3 SAP Instance Numbers ............................................................................................................................................... 41
4 SAP Central Services (ASCS & JSCS) Cluster ............................................................................................................ 43
5 SAP System ................................................................................................................................................................ 47
6 WebDispatcher ............................................................................................................................................................ 51
7 SAP Utility\Interface Server ......................................................................................................................................... 52
8 SAP Printing ................................................................................................................................................................ 52
9 SAPTrans .................................................................................................................................................................... 52
-
8/16/2019 PACT - Detailed Design v1.3
5/52
-
8/16/2019 PACT - Detailed Design v1.3
6/52
BNW Consulting | SAP Replatform - Detailed Design6
4 Reference Documents
Microsoft SQL Server Version List
http://blogs.technet.com/b/dataplatforminsider/archive/2014/09/25/using-ssds-in-azure-vms-to-store-sql-
server-tempdb-and-buffer-pool-extensions.aspx
Using SAP on Azure Virtual Machines (VMs)
OSS Note 2015553 - SAP on Microsoft Azure: Support prerequisites
1966681 - Release planning for Microsoft SQL Server 2014
http://blogs.msdn.com/b/saponsqlserver/archive/2013/06/30/1-microsoft-private-cloud-solution-for-sap-
hardware-network-amp-san.aspxhttp://blogs.msdn.com/b/saponsqlserver/archive/2013/06/30/6-microsoft-
private-cloud-solution-for-sap-configuration-of-cluster-shared-volumes-vhdx-disks-amp-luns.aspx
http://blogs.msdn.com/b/saponsqlserver/archive/2013/06/30/9-microsoft-private-cloud-solution-for-sap-
landscape-design.aspx
5 Glossary of terms
Term/Acronym Description
BPM Business Process Modelling
BPRE Business Process Reverse Engineer - a software component of SAP Solution Manager
IaaSInfrastructure as a service – the provision of infrastructure (networking, SAN, virtualisation layer, and a
running Virtual Machine. Management of all of the infrastructure is the responsibility of the IaaS provider.
PaaS
Platform as a Service – One level higher than IaaS, the software platform is provided as a service and
the PaaS provider takes responsibility for ensuring the platform is operational and the customer just
consumes the services and has no concern for the application platform underneath.
SAP Software Suite manufactured by SAP AG Germany
Sol Man SAP Solution Manager
VM Virtual Machine
PAM Platform Availability Matrix
SAV Software At Value
CSV Cluster Shared Volume
PAS Primary Application Server, first SAP instance installed in an SAP system
SAS Secondary Application Server – All subsequent SAP application servers installed after the PAS
.vhd Microsoft Format Virtual Hard Disk
.vhdx Microsoft Format Virtual Hard Disk (v2)
-
8/16/2019 PACT - Detailed Design v1.3
7/52
BNW Consulting | SAP Replatform - Detailed Design7
Part III: High-Level Summary
1 SAP Azure Support PrerequisitesTo run SAP in Azure in a fully supported state, SAP and Microsoft require that the Production SAP systems be deployed in the Hybrid-IT
scenario, where the Azure Virtual Networks are connected back to the customer’s enterprise network through the use of Site-to-Site VPN
or Azure ExpressRoute.
OSS Note 2015553 - SAP on Microsoft Azure: Support prerequisites
To ensure SAP systems support on Microsoft Azure Virtual Machine Services, the following prerequisites have to be met in order to
ensure full supportability and optimal performance:
Support contract prerequisitesWhen operating SAP production systems on Microsoft Azure Virtual Machine Services, you must have at a minimum ‘Microsoft
Premier Support’ contract in place with Microsoft.
Monitoring prerequisitesFull support requires enabling built-in SAP monitors to retrieve information about configuration and resource utilization from the
underlying Azure infrastructure.
Network prerequisites
Network SecurityFor any SAP production system installed on Azure, it is required that you operate in Virtual Private Network(s) which
is/are connected to your datacenters with Azure site-to-site or ExpressRoute connectivity.
Network PerformanceFor productive and non-productive 3-tier deployments, where application servers and the database server reside on
separate Azure VM instances and communicate via network, it is required that all Azure VM instances are located in
the same Azure Affinity Group and the same Azure Virtual Private Network.
It is NOT supported at all to run an SAP Application Server layer and DBMS layer split between on-premise and
Azure. Both layers need to completely reside either on-premise or in Azure. It is also NOT at all supported to have
SAP instances split between on-premise and Azure. Per individual SAP system, the DBMS and all SAP application
instance(s) must be in the same location, either Azure or on-premise.
Storage prerequisites
1. Virtual Hard Disks (VHDs) representing VMs and volumes mounted to a VM need to be grouped into Azure Storage Accounts.
2. VHDs which are mounted to a VM need to be located in the same Azure Storage Account with the VHD of the VM.3. Only VMs from the Standard Tier are supported. No Basic Tier SLAs of Azure VMs are supported for SAP systems.
2 QA to Replace Pre-ProdCurrently On-Premise Pre-Prod exists to provide similar architecture to Production, but this system is not fully utilised as a Pre-Prod
system where only limited testing occurs.
This Design is based around having QA replace Pre-Prod for BAU and Pre-Prod will be used as a Sandbox testing for the Production
move with the intent of deleting Pre-Prod post go-live.
This will allow QA to fully function is a landscape similar to Production and guarantee that all changes going into Production have been
tested on s imilar architecture.
This also allows full DR testing scenarios.
Pre-Prod will only exist in Azure as a Sandbox landscape to verify that we can move Production to Azure. Once go-live is completed Pre-
Prod will be deleted.
-
8/16/2019 PACT - Detailed Design v1.3
8/52
BNW Consulting | SAP Replatform - Detailed Design8
3 Target Landscape Overview
3.1 Production and QualityQuality architecturally similar to Production but can be sized down.
*Central services is showing a single system, PACT will have 6 separate Central services Clusters
-
8/16/2019 PACT - Detailed Design v1.3
9/52
BNW Consulting | SAP Replatform - Detailed Design9
3.2 Development
-
8/16/2019 PACT - Detailed Design v1.3
10/52
BNW Consulting | SAP Replatform - Detailed Design10
Part IV: Naming Conventions
1 Datacenter NamingDatacentre abbreviat ion:
Datacentre Naming Convention
Australia East (Sydney) SYD
Australia South East (Melbourne) MEL
2 Landscape Naming
Landscape Short Naming Convention Mid Naming Convention Long Naming Convention
Development D DEV Development
QA Q QA Quality
Pre-Production X PREPRD \ PPRD Pre-Product ion
Production P PROD Production
3 Virtual Machine NamingMax of 13chars
SAP
Description Naming Convention
SAP SQL Server SAP-SQLXX
SAP SCS Server SAP-SCSXX
SAP APP Server SAP-APPXX
SAP Non-Prod Server SAP-XX
SAP Livecache Server SAP-LCAXX
SAP Utility Server SAP-UTL
3.1 Cluster pairingVMs that are in clusters will be named in such a way that it is easy to identify the cluster pairs. How this will occur is using a naming
convention where the first node numerical number has 50 added to it.
Eg, Cluster node SAPSYD-SCS01 the cluster pair will be called SAPSYD-SCS51
-
8/16/2019 PACT - Detailed Design v1.3
11/52
BNW Consulting | SAP Replatform - Detailed Design11
4 Azure Resources NamingThis section refers to PACT Naming Standards 5.1 (draft)
Azure Resource Naming Convention
Resource Group _SAP_
Storage Account sapstorXX
Availability set ASET__
Load balancer LB__
Load balancer Health Probe -HealthProbe
Load balancer Frontend IP -Frontend
Load balancer Backend IP Pools -Backend
Load balancing rules (iLB End Point) _
Network interface -nicXX
-
8/16/2019 PACT - Detailed Design v1.3
12/52
BNW Consulting | SAP Replatform - Detailed Design12
Part V: SAP Server Hardening
1 Management Stations A dedicated SAP Management Station is required to administer the secured SAP system. The Management Station is a server outside
the SAP VLANs with special permission to Terminal Service to the SAP systems. The Management Station acts as a “gateway” or proxy
to allow access to the SAP systems.
Management Stations will be used to access and administer the SAP servers.
No direct access to the SAP Servers will be granted. All admins must log onto the Management server first.
Hostname IP Address
SRV-MGT-AZ-P10
SRV-MGT-AZ-P11
2 RDP Port
The default Windows Terminal Services (RDP) port is 3389. By changing the RDP port on each server to a secret port, unauthorised
access to an SAP server is much more difficult.
The RDP port is to be changed to a non-standard port --XXX--
3 Rename local administrator account
The local Windows server administrator account name is well known – “administrator”. It is recommended
to disable this account and create a new administrator account
This is done by default for Azure VMs.
-
8/16/2019 PACT - Detailed Design v1.3
13/52
BNW Consulting | SAP Replatform - Detailed Design13
Part VI: Windows Installations
1 Windows Release Information
Server Release Version Rollup Mode
SAP and SQLServers
Windows 2012R2 DataCenter 6.3 (Build 9600) March Build Full Gui
2 Windows Settings
2.1 Windows Time zoneTime zone for servers will be set to GMT+10.
Changing time zone as part of the migration will cause all scheduling in SAP to be incorrect and cause significant confusing with end
users using system reports.
2.2 Power ModesSet Power Mode to High Performance
2.3 Internet ExplorerInternet explorer is to removed from all SAP servers. There is no valid reason to have IE on any production SAP server.
dism /online /disable-feature /featurename:Internet-Explorer-Optional-amd64
2.4 Netbios
1431619 - Disable Netbios over TCP/IP in Windows environmentsNetbios to be disabled on all SAP Servers
2.5 Dynamic Port rangeSAP uses ports in the 50000-59900 range so we need move the windows dynamic port range to start at 60000 for SAP Servers.
netsh int ipv4 set dynamicport tcp start=60000 numberofports=5536
netsh int ipv4 show dynamicport tcp
-
8/16/2019 PACT - Detailed Design v1.3
14/52
BNW Consulting | SAP Replatform - Detailed Design14
2.6 TCP Chimney OffloadIn the SAP environment, TCP Chimney Offload caused problems that resulted in sporadic connection breakdowns between the SAP
application servers and database servers. Therefore, TCP Chimney offload should remain disabled.
Verify TCP Chimney Offload is disabled
Netsh int tcp show global
2.7 Receive Side ScalingRSS is able to distribute DPC handling of a single VMQ over multiple CPU threads on the host.
Enable RSS
Set Number of RSS queues to Auto
-
8/16/2019 PACT - Detailed Design v1.3
15/52
BNW Consulting | SAP Replatform - Detailed Design15
2.8 Shared Folder fix
http://support2.microsoft.com/kb/2820470
$Key = "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanWorkStation\Parameters"
If ( -Not ( Test-Path "Registry::$Key")){New-Item -Path "Registry::$Key" -ItemType RegistryKey -Force}
Set-ItemProperty -path "Registry::$Key" -Name "DisableCARetryOnInitialConnect" -Type "DWORD" -Value "1"
2.9 Windows Partition\Volume Setup
All additional disks will be created as GPT disks.
All Database Data and Log Volumes to be formatted with Allocation Unit Size of 64KB, all other SAP\SQLSERVER Volumes 4KB.
-
8/16/2019 PACT - Detailed Design v1.3
16/52
BNW Consulting | SAP Replatform - Detailed Design16
Part VII: Datacentre Replication for Azure
1 Database Replication to AzureDatabase layer to be replicated using SQLSERVER AlwaysON Availability Groups.
2 SAP Central Services ReplicationSAP Central Services to be replicated using SIOS
3 SAP Application Servers ReplicationSAP Application Servers will not be replicated, these will be prebuilt in the DR Datacentre.
4 SAP MaxDB ReplicationMaxDB databases will be replicated using MaxDB logroll.
-
8/16/2019 PACT - Detailed Design v1.3
17/52
BNW Consulting | SAP Replatform - Detailed Design17
5 Azure Files Replication Azure Files will be replicated via a Powershell script
6 Other Replication RequirementsMost other replication requirements will be handled v ia a Powershell script.
-
8/16/2019 PACT - Detailed Design v1.3
18/52
BNW Consulting | SAP Replatform - Detailed Design18
Part VIII: Azure Design
1 Resource GroupResource Groups used to group SAP Azure Services
Resource Group Location
SYD_SAP_PROD Sydney
SYD_SAP_PREPRD Sydney
SYD_SAP_QA Sydney
SYD_SAP_NONPROD Sydney
MEL_SAP_PROD Melbourne
MEL_SAP_PREPRD Melbourne
MEL_SAP_QA Melbourne
2 Public IP AddressesSAP has no requirement for Public IP Address.
All Public end points to be removed from SAP Virtual Machines.
3 Network Security GroupDo we want to use Network Security Groups to further isolate network traffic ?
Our preference is to use Windows Firewalls to control access to the Server, currently there is very little logging for Network Security
Groups.
Pact intends to utilise Barracuda Firewall Virtual Appliance within SYD/MELB Azure to provide extra layer of security.
-
8/16/2019 PACT - Detailed Design v1.3
19/52
BNW Consulting | SAP Replatform - Detailed Design19
4 Virtual NetworkVirtual Network Name to be used in Azure
vNet Name Address Space Resource Group
PACTVNET_SYD_2 10.202.0.0/21
PACTVNET_MEL_1 10.203.0.0/21
4.1 PACT_SYD_01 vNet SubnetsSubnets that will exist in the PACT_SYD_01 Virtual Network.
IP Range Subnet Name Usage
10.202.4.128/25 SAP-NonProd SAP Non-Production
10.202.4.0/25 SAP-Quality SAP Quality\Pre-Prod
10.202.3.0/24 SAP-Production SAP Production
10.100.8.0/24 Management Management Servers
4.2 PACTVNET_MEL_1 vNet Subnets
IP Range Subnet Name Usage
Subnet-1 Reserved
SAP-Quality SAP Quality\Pre-Prod
SAP-Production SAP Production
Management Management Servers
4.3 Routing All traffic will be forced down Express Route, this means we need to setup a local rule in the Routing table to direct all Azure URL traffic
directly to Azure. Otherwise traffic for Database Direct to Blob storage and Azure Files will route down ER then back up ER to Azure and
cause significant performance issues.
Add the following routes to the Routing table:
Description Address Next Hop
Azure Blob Storage *.blob.core.windows.net Internet
Azure Files *.file.core.windows.net Internet
-
8/16/2019 PACT - Detailed Design v1.3
20/52
BNW Consulting | SAP Replatform - Detailed Design20
5 Storage AccountsBest practice is to segregate SAP landscapes into different Storage Accounts to ensure IOPS is not limited.
Storage Accounts that will exist.
5.1 SYD_SAP Storage Accounts
Storage Account Name Description Type Resource Group Redundancy
sydsapdevlrsstor11 SAP Development SAP VMs Standard SYD_SAP_NONPROD Locally
sydsapdevbcklrsstor12 SAP Development Database Backups Standard SYD_SAP_NONPROD Locally
sydsapdevprmstor11 SAP Development Databases Premium SYD_SAP_NONPROD Locally
sydsapqal rsstor11 SAP QA SAP VMs Standard SYD_SAP_QA Locally
sydsapqabcklrsstor12 SAP QA Database Backups Standard SYD_SAP_QA Locally
sydsapqaprmstor11 SAP QA SQL Databases Node 1 Premium SYD_SAP_QA Locally
sydsapqaprmstor12 SAP QA SQL Databases Node 2 Premium SYD_SAP_QA Locally
sydsapqaprmstor13 SAP QA MaxDB Databases Premium SYD_SAP_QA Locally
sydsappprdlrsstor11 SAP Pre-Production SAP VMs Standard SYD_SAP_PREPRD Locally
sydsappprdbcklrsstor12 SAP Pre-Production Database Backups Standard SYD_SAP_PREPRD Locally
sydsappprdprmstor11 SAP Pre-Production SQL Databases Node 1 Premium SYD_SAP_PREPRD Locally
sydsappprdprmstor12 SAP Pre-Production SQL Databases Node 2 Premium SYD_SAP_PREPRD Locally
sydsappprdprmstor13 SAP Pre-Production MaxDB Databases Premium SYD_SAP_PREPRD Locally
sydsapprodlrsstor11 SAP Production SAP VMs Standard SYD_SAP_PROD Locally
sydsapprodbcklrsstor12 SAP Production Database Backups Standard SYD_SAP_PROD Locally
sydsapprodlrsstor13 SAPTrans Azure Files Standard SYD_SAP_PROD Locally
sydsapprodprmstor11 SAP Production SQL Databases Node 1 Premium SYD_SAP_PROD Locally
sydsapprodprmstor12 SAP Production SQL Databases Node 2 Premium SYD_SAP_PROD Locally
sydsapprodprmstor13 SAP Production MaxDB Databases Premium SYD_SAP_PROD Locally
sydsapmgtlrsstor11 SAP Management VMs Standard SYD_SAP_MGT Locally
-
8/16/2019 PACT - Detailed Design v1.3
21/52
BNW Consulting | SAP Replatform - Detailed Design21
5.2 MEL_SAP Storage Accounts
Storage Account Name Description Type Resource Group Redundancy
melsapqalrsstor11 SAP QA SAP VMs Standard MEL_SAP_QA Locally
melsapqabcklrsstor12 SAP QA Database Backups Standard MEL_SAP_QA Locally
melsapqaprmstor11 SAP QA SQL Databases Node 1 Premium MEL_SAP_QA Locally
melsapqaprmstor13 SAP QA MaxDB Databases Premium MEL_SAP_QA Locally
melsappprdlrsstor11 SAP Pre-Production SAP VMs Standard MEL_SAP_PREPRD Locally
melsappprdbcklrsstor11 SAP Pre-Production tabase Backups Standard MEL_SAP_PREPRD Locally
melsappprdprmstor11 SAP Pre-Production SQL Databases Node 1 Premium MEL_SAP_PREPRD Locally
melsappprdprmstor13 SAP Pre-Production MaxDB Databases Premium MEL_SAP_PREPRD Local ly
melsapprodlrsstor11 SAP Production SAP VMs Standard MEL_SAP_PROD Locally
melsapprodlrsstor11 SAP Production tabase Backups Standard MEL_SAP_PROD Locally
melsapprodlrsstor12 SAPTrans Azure Files Standard MEL_SAP_PROD Locally
melsapprodprmstor11 SAP Production SQL Databases Node 1 Premium MEL_SAP_PROD Locally
melsapprodprmstor13 SAP Production MaxDB Databases Premium MEL_SAP_PROD Locally
melsapmgtlrsstor11 SAP Management VMs Standard MEL_SAP_MGT Locally
-
8/16/2019 PACT - Detailed Design v1.3
22/52
BNW Consulting | SAP Replatform - Detailed Design22
6 Availability SetsTo ensure redundancy in Azure, Availability Sets will be used. This will force Azure to provision VM’s in different Fault Domains and
Upgrade Domains.
Production Database VM’s will exist in 1 Availability Set for each system.
Production SCS will exist in 1 Availability Set for each system.
Production Application VMs will exist 1 Availability Set
QA Database VM’s will exist in 1 Availability Set.
QA SCS VMs will exist in 1 Availability Set.
QA Application VMs will exist in 1 Availability Set
Non Production VM’s will exist in 1 Availability Set for each landscape, Eg 1 for Dev etc.
7 Virtual Machine Storage
7.1 Prod and QA SQL Servers
SQL servers have no requirement for additional storage.
SQL Instance will be directly installed on C: drive.
Database to be installed direct to Blob
7.2 Prod and QA SAP SCS ServersSAP SCS servers will have 1 x 1TB vhd assigned for each system and the SCS instance to be installed on this drive.
SAP ERS will be installed on C: drive.
7.3 Prod and QA SAP Application ServersSAP Application Servers will have 1 x 1TB vhd assigned as E: drive, SAP Instance will be installed on this drive.
7.4 Non-Prod SAP ServersNon-Prod SAP Servers will have 1 x 1TB vhd assigned as E: drive, SAP Instance will be installed on this drive.
SQL to be installed on C: drive.
Database to be installed direct to Blob
7.5 MaxDB Servers
Servers hosting a MaxDB database to have a P10 vhd assigned to the VM and the database installed on this vhd
7.6 Other ServersOther servers to have vhd’s assigned as required. Eg, SAP utility server for Interface, Archive directories.
-
8/16/2019 PACT - Detailed Design v1.3
23/52
BNW Consulting | SAP Replatform - Detailed Design23
8 Virtual MachinesIP Addresses for SAP Virtual Machines in Azure will be set to Static IP Addresses.
8.1 Production
8.1.1 SYD_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabil ity Set Storage Account
SAPSYD-PSQL01 Production SQL Node 01 sapsyd-psql01-nic1 X.X.X.X D14 SYD_SAP_PROD ASET_SAP_SQL sydsapprodlrsstor11
SAPSYD-PSQL51 Production SQL Node 02 sapsyd-psql51-nic1 X.X.X.X D14 SYD_SAP_PROD ASET_SAP_SQL sydsapprodlrsstor11
SAPSYD-PSCS01 Production SP1 SCS Node 01 sapsyd-pscs01-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SP1_SCS sydsapprodlrsstor11
SAPSYD-PSCS02 Production HRP SCS Node 01 sapsyd-pscs02-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_HRP_SCS sydsapprodlrsstor11
SAPSYD-PSCS03 Production SCP SCS Node 01 sapsyd-pscs03-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SCP_SCS sydsapprodlrsstor11
SAPSYD-PSCS04 Production POP SCS Node 01 sapsyd-pscs04-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_POP_SCS sydsapprodlrsstor11
SAPSYD-PSCS05 Production BIP SCS Node 01 sapsyd-pscs05-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_BIP_SCS sydsapprodlrsstor11
SAPSYD-PSCS06 Production SMP SCS Node 01 sapsyd-pscs06-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SMP_SCS sydsapprodlrsstor11
SAPSYD-PSCS51 Production SP1 SCS Node 02 sapsyd-pscs51-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SP1_SCS sydsapprodlrsstor11
SAPSYD-PSCS52 Production HRP SCS Node 02 sapsyd-pscs52-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_HRP_SCS sydsapprodlrsstor11
SAPSYD-PSCS53 Production SCP SCS Node 02 sapsyd-pscs53-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SCP_SCS sydsapprodlrsstor11
SAPSYD-PSCS54 Production POP SCS Node 02 sapsyd-pscs54-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_POP_SCS sydsapprodlrsstor11
SAPSYD-PSCS55 Production BIP SCS Node 02 sapsyd-pscs55-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_BIP_SCS sydsapprodlrsstor11
SAPSYD-PSCS56 Production SMP SCS Node 02 sapsyd-pscs56-nic1 X.X.X.X A5 SYD_SAP_PROD ASET_SMP_SCS sydsapprodlrsstor11
SAPSYD-PAPP01 Production SAP Application Server 01 sapsyd-papp01-nic1 X.X.X.X D14 SYD_SAP_PROD ASET_SAP_APP sydsapprodlrsstor11
SAPSYD-PAPP02 Production SAP Application Server 02 sapsyd-papp02-nic1 X.X.X.X D14 SYD_SAP_PROD ASET_SAP_APP sydsapprodlrsstor11
SAPSYD-PAPP03 Production SAP Application Server 03 sapsyd-papp03-nic1 X.X.X.X D14 SYD_SAP_PROD ASET_SAP_APP sydsapprodlrsstor11
SAPSYD-PLCA01 Production LiveCache Server 01 sapsyd-plca01-nic1 X.X.X.X DS11 SYD_SAP_PROD ASET_SAP_LCA sydsapprodprmstor13
SAPSYD-PUTL01 Production Utility Server 01 sapsyd-putl01-nic1 X.X.X.X A2 SYD_SAP_PROD ASET_SAP_UTL sydsapprodlrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
24/52
BNW Consulting | SAP Replatform - Detailed Design24
8.1.2 MEL_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabil ity Set Storage Account
SAPMEL-PSQL01 Production SQL DR Node 01 sapmel-psql01-nic1 X.X.X.X D11 MEL_SAP_PROD ASET_SAP_SQL melsapprodlrsstor11
SAPMEL-PSCS01 Production SCS DR Node 01 sapmel-pscs01-nic1 X.X.X.X A5 MEL_SAP_PROD ASET_SAP_SCS melsapprodlrsstor11
SAPMEL-PAPP01 Production SAP Application Server 01 sapmel-papp01-nic1 X.X.X.X D14 MEL_SAP_PROD ASET_SAP_APP melsapprodlrsstor11
SAPMEL-PAPP02 Production SAP Application Server 02 sapmel-papp02-nic1 X.X.X.X D14 MEL_SAP_PROD ASET_SAP_APP melsapprodlrsstor11
SAPMEL-PAPP03 Production SAP Application Server 03 sapmel-papp03-nic1 X.X.X.X D14 MEL_SAP_PROD ASET_SAP_APP melsapprodlrsstor11
SAPMEL-PLCA01 Production LiveCache Server 01 sapmel-plca01-nic1 X.X.X.X DS11 MEL_SAP_PROD ASET_SAP_LCA melsapprodprmstor13
SAPMEL-PUTL01 Production Utility Server 01 sapmel-putl01-nic1 X.X.X.X A2 MEL_SAP_PROD ASET_SAP_UTL melsapprodlrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
25/52
BNW Consulting | SAP Replatform - Detailed Design25
8.2 Pre-Production
8.2.1 SYD_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabi lity Set Storage Account
SAPSYD-XSQL01 Pre-Prod SQL Node 01 sapsyd-xsql01-nic1 X.X.X.X D14 SYD_SAP_PREPRD ASET_SAP_SQL sydsappprdlrsstor11
SAPSYD-XSQL51 Pre-Prod SQL Node 02 sapsyd-xsql51-nic1 X.X.X.X D14 SYD_SAP_PREPRD ASET_SAP_SQL sydsappprdlrsstor11
SAPSYD-XSCS01 Pre-Prod SX1 SCS Node 01 sapsyd-xscs01-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_SX1_SCS sydsappprdlrsstor11
SAPSYD-XSCS02 Pre-Prod HRX SCS Node 01 sapsyd-xscs02-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_HRX_SCS sydsappprdlrsstor11
SAPSYD-XSCS03 Pre-Prod SCX SCS Node 01 sapsyd-xscs03-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_SCX_SCS sydsappprdlrsstor11
SAPSYD-XSCS04 Pre-Prod POX SCS Node 01 sapsyd-xscs04-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_POX_SCS sydsappprdlrsstor11
SAPSYD-XSCS05 Pre-Prod BIX SCS Node 01 sapsyd-xscs05-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_BIX_SCS sydsappprdlrsstor11
SAPSYD-XSCS51 Pre-Prod SX1 SCS Node 02 sapsyd-xscs51-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_SX1_SCS sydsappprdlrsstor11
SAPSYD-XSCS52 Pre-Prod HRX SCS Node 02 sapsyd-xscs52-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_HRX_SCS sydsappprdlrsstor11
SAPSYD-XSCS53 Pre-Prod SCX SCS Node 02 sapsyd-xscs53-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_SCX_SCS sydsappprdlrsstor11
SAPSYD-XSCS54 Pre-Prod POX SCS Node 02 sapsyd-xscs54-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_POX_SCS sydsappprdlrsstor11
SAPSYD-XSCS55 Pre-Prod BIX SCS Node 02 sapsyd-xscs55-nic1 X.X.X.X A5 SYD_SAP_PREPRD ASET_BIX_SCS sydsappprdlrsstor11
SAPSYD-XAPP01 Pre-Prod SAP Application Server 01 sapsyd-xapp01-nic1 X.X.X.X D14 SYD_SAP_PREPRD ASET_SAP_APP sydsappprdlrsstor11
SAPSYD-XAPP02 Pre-Prod SAP Application Server 02 sapsyd-xapp02-nic1 X.X.X.X D14 SYD_SAP_PREPRD ASET_SAP_APP sydsappprdlrsstor11
SAPSYD-XAPP03 Pre-Prod SAP Application Server 03 sapsyd-xapp03-nic1 X.X.X.X D14 SYD_SAP_PREPRD ASET_SAP_APP sydsappprdlrsstor11
SAPSYD-XLCA01 Pre-Prod LiveCache Server 01 sapsyd-xlca01-nic1 X.X.X.X DS11 SYD_SAP_PREPRD ASET_SAP_LCA sydsappprdprmstor13
SAPSYD-XUTL01 Pre-Prod Utility Server 01 sapsyd-xutl01-nic1 X.X.X.X A2 SYD_SAP_PREPRD ASET_SAP_UTL sydsappprdlrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
26/52
BNW Consulting | SAP Replatform - Detailed Design26
8.2.2 MEL_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabi lity Set Storage Account
SAPMEL-XSQL01 Pre-Prod SQL DR Node 01 sapmel-xsql01-nic1 X.X.X.X D11 MEL_SAP_PREPRD ASET_SAP_SQL melsappprdlrsstor11
SAPMEL-XSCS01 Pre-Prod SCS DR Node 01 sapmel-xscs01-nic1 X.X.X.X A5 MEL_SAP_PREPRD ASET_SAP_SCS melsappprdlrsstor11
SAPMEL-XAPP01 Pre-Prod SAP Application Server 01 sapmel-xapp01-nic1 X.X.X.X D14 MEL_SAP_PREPRD ASET_SAP_APP melsappprdlrsstor11
SAPMEL-XAPP02 Pre-Prod SAP Application Server 02 sapmel-xapp02-nic1 X.X.X.X D14 MEL_SAP_PREPRD ASET_SAP_APP melsappprdlrsstor11
SAPMEL-XAPP03 Pre-Prod SAP Application Server 03 sapmel-xapp03-nic1 X.X.X.X D14 MEL_SAP_PREPRD ASET_SAP_APP melsappprdlrsstor11
SAPMEL-XLCA01 Pre-Prod LiveCache Server 01 sapmel-xlca01-nic1 X.X.X.X DS11 MEL_SAP_PREPRD ASET_SAP_LCA melsappprdprmstor13
SAPMEL-XUTL01 Pre-Prod Utility Server 01 sapmel-xutl01-nic1 X.X.X.X A2 MEL_SAP_PREPRD ASET_SAP_UTL melsappprdlrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
27/52
BNW Consulting | SAP Replatform - Detailed Design27
8.3 QA
8.3.1 SYD_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabi lity Set Storage Account
SAPSYD-QSQL01 QA SQL Node 01 sapsyd-qsql01-nic1 X.X.X.X D12 SYD_SAP_QA ASET_SAP_SQL sydsapqalrsstor11
SAPSYD-QSQL51 QA SQL Node 02 sapsyd-qsql51-nic1 X.X.X.X D12 SYD_SAP_QA ASET_SAP_SQL sydsapqalrsstor11
SAPSYD-QSCS01 QA ST1 SCS Node 01 sapsyd-qscs01-nic1 X.X.X.X A5 SYD_SAP_QA ASET_ST1_SCS sydsapqalrsstor11
SAPSYD-QSCS02 QA HRT SCS Node 01 sapsyd-qscs02-nic1 X.X.X.X A5 SYD_SAP_QA ASET_HRT_SCS sydsapqalrsstor11
SAPSYD-QSCS03 QA SCT SCS Node 01 sapsyd-qscs03-nic1 X.X.X.X A5 SYD_SAP_QA ASET_SCT_SCS sydsapqalrsstor11
SAPSYD-QSCS04 QA POT SCS Node 01 sapsyd-qscs04-nic1 X.X.X.X A5 SYD_SAP_QA ASET_POT_SCS sydsapqalrsstor11
SAPSYD-QSCS05 QA BIT SCS Node 01 sapsyd-qscs05-nic1 X.X.X.X A5 SYD_SAP_QA ASET_BIQ_SCS sydsapqalrsstor11
SAPSYD-QSCS51 QA ST1 SCS Node 02 sapsyd-qscs51-nic1 X.X.X.X A5 SYD_SAP_QA ASET_ST1_SCS sydsapqalrsstor11
SAPSYD-QSCS52 QA HRT SCS Node 02 sapsyd-qscs52-nic1 X.X.X.X A5 SYD_SAP_QA ASET_HRT_SCS sydsapqalrsstor11
SAPSYD-QSCS53 QA SCT SCS Node 02 sapsyd-qscs53-nic1 X.X.X.X A5 SYD_SAP_QA ASET_SCT_SCS sydsapqalrsstor11
SAPSYD-QSCS54 QA POT SCS Node 02 sapsyd-qscs54-nic1 X.X.X.X A5 SYD_SAP_QA ASET_POT_SCS sydsapqalrsstor11
SAPSYD-QSCS55 QA BIT SCS Node 02 sapsyd-qscs55-nic1 X.X.X.X A5 SYD_SAP_QA ASET_BIQ_SCS sydsapqalrsstor11
SAPSYD-QAPP01 QA SAP Application Server 01 sapsyd-qapp01-nic1 X.X.X.X D13 SYD_SAP_QA ASET_SAP_APP sydsapqalrsstor11
SAPSYD-QAPP02 QA SAP Application Server 02 sapsyd-qapp02-nic1 X.X.X.X D13 SYD_SAP_QA ASET_SAP_APP sydsapqalrsstor11
SAPSYD-QLCA01 QA LiveCache Server 01 sapsyd-qlca01-nic1 X.X.X.X DS11 SYD_SAP_QA ASET_SAP_LCA sydsapqaprmstor13
SAPSYD-QUTL01 QA Utility Server 01 sapsyd-qutl01-nic1 X.X.X.X A2 SYD_SAP_QA ASET_SAP_UTL sydsapqalrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
28/52
BNW Consulting | SAP Replatform - Detailed Design28
8.3.2 MEL_SAP
Hostname Description Primary Network Interface IP AddressVMSize
Resource Group Availabi lity Set Storage Account
SAPMEL-QSQL01 QA SQL DR Node 01 sapmel-qsql01-nic1 X.X.X.X D11 MEL_SAP_QA ASET_SAP_SQL melsapqalrsstor11
SAPMEL-QSCS01 QA SCS DR Node 01 sapmel-qscs01-nic1 X.X.X.X A5 MEL_SAP_QA ASET_SAP_SCS melsapqalrsstor11
SAPMEL-QAPP01 QA SAP Application Server 01 sapmel-qapp01-nic1 X.X.X.X D13 MEL_SAP_QA ASET_SAP_APP melsapqalrsstor11
SAPMEL-QAPP02 QA SAP Application Server 02 sapmel-qapp02-nic1 X.X.X.X D13 MEL_SAP_QA ASET_SAP_APP melsapqalrsstor11
SAPMEL-QLCA01 QA LiveCache Server 01 sapmel-qlca01-nic1 X.X.X.X DS11 MEL_SAP_QA ASET_SAP_LCA melsapqaprmstor13
SAPMEL-QUTL01 QA Utility Server 01 sapmel-qutl01-nic1 X.X.X.X A2 MEL_SAP_QA ASET_SAP_RTR melsapqalrsstor11
8.4 Development
Hostname Description Primary Network Interface IP AddressVMSize
Resource GroupAvailabilitySet
Storage Account
SAPSYD-DSQL01 Development SQL Server sapsyd-dsql01-nic1 X.X.X.X D12 SYD_SAP_NONPROD ASET_DEV sydsapdev lrsstor11
SAPSYD-DAPP01 Development SAP Instance Node sapsyd-dapp01-nic1 X.X.X.X D12 SYD_SAP_NONPROD ASET_DEV sydsapdev lrsstor11
SAPSYD-DLCA01 Development Livecache DB sapsyd-dlca01-nic1 X.X.X.X DS11 SYD_SAP_NONPROD ASET_DEV sydsapdev lrsstor11
SAPSYD-DUTL01 Development Utility Server 01 sapsyd-dutl01-nic1 X.X.X.X A2 SYD_SAP_NONPROD ASET_DEV sydsapdev lrsstor11
-
8/16/2019 PACT - Detailed Design v1.3
29/52
BNW Consulting | SAP Replatform - Detailed Design29
8.5 SAP Enhanced Monitoring1409604 – Virtualization on Windows: Enhanced monitoring
SAP enhanced monitoring within a Microsoft Azure Virtual Machine is required to be activated on all SAP Virtual Machines.
9 Azure Internal Load BalancersFor High Availability to work in Azure you need to create Internal Load Balancers that the fabric uses to redirect traffic to the correct
server.
9.1 Production
Internal Load Balancer SYD iLB Frontend IP Address SYD iLB Backend Pools
LB_SP1_SCS X.X.X.XX.X.X.X - sapsyd-pscs01-nic1X.X.X.X - sapsyd-pscs51-nic1
LB_HRP_SCS X.X.X.XX.X.X.X - sapsyd-pscs02-nic1X.X.X.X - sapsyd-pscs52-nic1
LB_SCP_SCS X.X.X.XX.X.X.X - sapsyd-pscs03-nic1X.X.X.X - sapsyd-pscs53-nic1
LB_POP_SCS X.X.X.X X.X.X.X - sapsyd-pscs04-nic1X.X.X.X - sapsyd-pscs54-nic1
LB_BIP_SCS X.X.X.XX.X.X.X - sapsyd-pscs05-nic1X.X.X.X - sapsyd-pscs55-nic1
LB_SMP_SCS X.X.X.XX.X.X.X - sapsyd-pscs06-nic1X.X.X.X - sapsyd-pscs56-nic1
9.2 Pre-Production
Internal Load Balancer SYD iLB Frontend IP Address SYD iLB Backend Pools
LB_SX1_SCS X.X.X.XX.X.X.X - sapsyd-xscs01-nic1X.X.X.X - sapsyd-xscs51-nic1
LB_HRX_SCS X.X.X.XX.X.X.X - sapsyd-xscs02-nic1X.X.X.X - sapsyd-xscs52-nic1
LB_SCX_SCS X.X.X.XX.X.X.X - sapsyd-xscs03-nic1X.X.X.X - sapsyd-xscs53-nic1
LB_POX_SCS X.X.X.XX.X.X.X - sapsyd-xscs04-nic1X.X.X.X - sapsyd-xscs54-nic1
LB_BIX_SCS X.X.X.XX.X.X.X - sapsyd-xscs05-nic1X.X.X.X - sapsyd-xscs55-nic1
9.3 Quality
Internal Load Balancer SYD iLB Frontend IP Address SYD iLB Backend Pools
LB_ST1_SCS X.X.X.XX.X.X.X - sapsyd-qscs01-nic1X.X.X.X - sapsyd-qscs51-nic1
LB_HRT_SCS X.X.X.XX.X.X.X - sapsyd-qscs02-nic1X.X.X.X - sapsyd-qscs52-nic1
LB_SCT_SCS X.X.X.XX.X.X.X - sapsyd-qscs03-nic1X.X.X.X - sapsyd-qscs53-nic1
LB_POT_SCS X.X.X.XX.X.X.X - sapsyd-qscs04-nic1X.X.X.X - sapsyd-qscs54-nic1
LB_BIQ_SCS X.X.X.XX.X.X.X - sapsyd-qscs05-nic1X.X.X.X - sapsyd-qscs55-nic1
-
8/16/2019 PACT - Detailed Design v1.3
30/52
BNW Consulting | SAP Replatform - Detailed Design30
10 Azure Resource TaggingFollowing tags will be used, but not limited to:
DEV
QA
PREPROD
PROD
11 Azure Backup Strategy Azure backups will adhere to current PACT Azure Backup strategy.
11.1 OS BackupsUse Azure Recovery Services to protect Azure VMs
11.2 File BackupsUse Azure Recovery Services to provide file system backups for the SAP Central Services and SAP Application servers.
11.3 SQL BackupsSQL Backups that are less than 1TB will backup directly to BLOB storage.SQL Backups that are greater than 1TB will backup to remote server and then be shipped off to BLOB storage.
-
8/16/2019 PACT - Detailed Design v1.3
31/52
BNW Consulting | SAP Replatform - Detailed Design31
Part IX: SQLSERVER Instance Design
1 SQLSERVER Instance and Database InstallationSQLSERVER instance installation will be performed as per SAP Installation guides.
SQL Server:For the installation of your SQL Server database software in a HA environment, use the installation guide for Installation of SQL Server in
an SAP Environment, which is available at:
http://service.sap.com/instguides -> Database Upgrades -> MS SQL Server
1.1 Release Information
1.1.1 SQLSERVER 2014
Microsoft SQL Release and Version that will be used:
Release: SQLSERVER 2014 SP1 CU5
Version: 12.00.4439
Microsoft SQL Server 2014 Service Pack 1 (SP1)
Cumulative Update 5 (CU5) for SQL Server 2014 Service Pack 1
1.2 AD Accounts and GroupsThe following Service user accounts will be used to run SQLSERVER.
Service User
SQL Server SAPSQLServer
SQL Server Agent SAPSQLAgent
SAPSQLServer Accounts are to be added to the following AD Group
Text User
SQL Server Group SAPSQLServer_Accounts
1.3 Transparent Data Encryption (TDE)Current Database are not encrypted, TDE to not be used at PACT
1.4 High Availability
SQLSERVER High-Availability will be provided by using AlwaysON SYNC.
There is no requirement to provide High Availability in Azure if in DR mode.
1.5 Disaster RecoverySQL SERVER Disaster Recovery will be provided by using AlwaysON with ASYNC updates to the Melbourne Azure Datacenter.
-
8/16/2019 PACT - Detailed Design v1.3
32/52
BNW Consulting | SAP Replatform - Detailed Design32
1.6 AlwaysOn Listener AlwaysON Listener will not be used by PACT due to all instances residing on a single server.
When multi iLB becomes available PACT should then consider using a Listener.
1.7 Windows Local Policies Add the SQLServer AD Group to the following User Rights Assignments local Policy
Grant “Lock Pages in Memory” permission to group SAPSQLServer_Group
Grant “Perform Volume Maintenance Tasks” permission to group SAPSQLServer_Group
-
8/16/2019 PACT - Detailed Design v1.3
33/52
BNW Consulting | SAP Replatform - Detailed Design33
1.8 Instance Installation A Named Installation will be performed as per SAP Installation guides.
SQLSERVER instance to be installed under C: Drive.
Exception: A minimal install of the SQLSERVER Instance will be performed. Only the Database Engine Services and Management
Tools will be installed. SAP Does not require any other feature.
1.9 Instance Trace Settings
1.9.1 SQLSERVER 2014
The following trace flags will be set as per 1986775 – Configuration Parameters for SQL Server 2014
-T617 Revert a behaviour in SQL Server’s Lock Manager
-T1117 Proportional File Auto-Growth
-T1118 Disabling TempDB multi-object extents
-T2371 Changes to automatic update statistics
-T2562 Faster CHECKDB runtime -T2549 Faster CHECKDB runtime
-T3226 Suppress successful backup operation log entries
-T9481 Enforce the old Cardinality Estimation algorithms
1.10 Memory SettingsMemory Mix and Max values will need to be defined as the SQLSERVER instance are running on a Virtual machine.
Min and Max to be set to VM RAM – 10%
-XXX- Memory settings will need to be defined or each instance. Need to check current usage.
-
8/16/2019 PACT - Detailed Design v1.3
34/52
BNW Consulting | SAP Replatform - Detailed Design34
1.11 Storage designWith SQLSERVER 2014 a new feature has been introduced that allows a a Database to store Datafiles and Tlog files directly on Blob
Storage. We will use this Direct to Blob feature to store the database.
TempDB and the Buffer Pool Extension will reside on the local non-persistent disk.
1.11.1 Storage Account Container Naming Convention
SQL Server 2014 containers for Azure Databases will be named as -database.
This will provide segregation for all databases.
1.11.2 TempDB Setup
With Azure D series virtual machines, the recommendation is to store TempDB on the Non-Persistent SSD Disk.
Naming convention for Non-Persistent TempDB folder: -TempDB
For non-BW SAP Database create 4 x 2GB TempDB Datafiles and 1 x 512MB TempDB Logfile
For BW SAP Database create 1 TempDB Datafile per CPU and 1 TempDB Logfile, sizing is dependent of BW Database size.
Naming convention for TempDB datafiles: TempDBdata.mdf\ndf
Naming convention for TempDB logfile: TempDBlog.ldf
-
8/16/2019 PACT - Detailed Design v1.3
35/52
BNW Consulting | SAP Replatform - Detailed Design35
1.12 Buffer Pool ExtensionsWith SQLSERVER 2014 a new feature has been introduced that allows an additional Buffer Pool to exist on the filesystem. This Buffer
Pool Extension allows the Buffer Pool in memory to spill out into high performing disk.
With Azure the recommendation is to store the Buffer Pool Extension on the Non-Persistent SSD Disk in standard storage and a
dedicated persistent drive in premium storage.
Naming convention for Non-Persistent Buffer Pool Extension folder: -BufferPool
Buffer Pool Extension sizing. DB Buffer x 6
-
8/16/2019 PACT - Detailed Design v1.3
36/52
BNW Consulting | SAP Replatform - Detailed Design36
2 SQLSERVER Cluster Setup
2.1 Hostnames and IP Addresses
2.1.1 Production
Description Nodes Cluster Name
Cluster
Name IPAddress
Production SQLServerSAPSYD-PSQL01SAPSYD-PSQL51SAPMEL-PSQL01
SAPGEO-PCLU01 X.X.X.X
2.1.2 Pre-Production
Description Nodes Cluster NameClusterName IPAddress
Pre-Production SQLServer SAPSYD-XSQL01SAPSYD-XSQL51SAPMEL-XSQL01
SAPGEO-XCLU01 X.X.X.X
2.1.3 Quality
Description Nodes Cluster NameClusterName IPAddress
Quality SQLServerSAPSYD-QSQL01SAPSYD-QSQL51SAPMEL-QSQL01
SAPGEO-QCLU01 X.X.X.X
-
8/16/2019 PACT - Detailed Design v1.3
37/52
BNW Consulting | SAP Replatform - Detailed Design37
2.2 Cluster Settings
2.2.1 Quorum
File Share Witness Quorum to be used where the File Share Witness is to reside in Azure.
Azure Sydney Servers to be configured with 1 vote each
Azure Melbourne Servers to be configured with 0 vote each
2.2.2 Parameters
Cluster parameters will be set to Relaxed settings as per Tuning Failover Cluster Network Thresholds
Windows Server 2012 and later:
Parameter
Fast Failover
(Default)
Relaxed
Maximum
SameSubnetDelay 1 second 1 second 2 seconds
SameSubnetThreshold 5 heartbeats 10 heartbeats 120 heartbeats
CrossSubnetDelay 1 second 2 seconds 4 seconds
CrossSubnetThreshold 5 heartbeats 20 heartbeats 120 heartbeats
-
8/16/2019 PACT - Detailed Design v1.3
38/52
BNW Consulting | SAP Replatform - Detailed Design38
3 SQLServer Backup StrategyProduction Backups retained for 1 month
Non-Prod Backups retained for 1 month
Landscape Full Diff Tlog
Production Weekly Daily 10mins
Quality Weekly Daily 1hr
Development Weekly Daily 30mins
-
8/16/2019 PACT - Detailed Design v1.3
39/52
BNW Consulting | SAP Replatform - Detailed Design39
Part X: SAP System Design
1 SAP Instance InstallationSAP installation will be performed as per System Copy Guide for SAP Systems Based on SAP NetWeaver Application Server on Windows Using Software Provisioning Manager 1.0
1.1 AD Accounts and GroupsThe following user accounts are required for SAP.
Text User
SAP Admin account adm
SAP Service account SAPService
Users are added to the following AD Group
Text User
SAP Group SAP__GlobalAdmin
-
8/16/2019 PACT - Detailed Design v1.3
40/52
BNW Consulting | SAP Replatform - Detailed Design40
2 SAP Binaries
2.1 SAP Kernel
2.1.1 7.22EXT Kernel
The following SAP Kernel will be used for all systems based on NW7.31 and below:
7.22 EXT stack 100: SAPEXE_100-70000603.SAR & SAPEXEDB_100-70000602.SAR
2.1.2 7.42 Kernel
The following SAP Kernel will be used for all systems based on NW7.4:
7.42 stack 300: SAPEXE_300-20012222.SAR & SAPEXEDB_300-20012221.SAR
2.2 SAP IGSThe following SAP IGS will be used:
SAP IGS 7.20_EXT SP10 (igsexe_10-20007794.sar)
SAP IGS HELPER (igshelper_4-10010245.sar)
2.3 SAP CRYPTOLIBThe following SAPCRYPTOLIB will be used:
COMMONCRYPTOLIB 8 patch 8448 (SAPCRYPTOLIBP_8448-20011729.SAR)
2.4 SAP HostAgentThe following SAP HostAgent will be used:
SAP HOST AGENT 7.21 SP11 (SAPHOSTAGENT11_11-20009417.SAR)
2.5 SAP MMCThe following SAP MMC will be used:
SAP MMC 7.42 SP2 (SAP_MMC_2-20012056.MSI)
2.6 SAP JVMThe following patch versions will be used where required:
SAP JVM 4.1 SP59 (SAPJVM4_59-10009724.SAR)
SAP JVM 5.1 SP106 (SAPJVM5_106-10004442.SAR)
SAP JVM 6.1 SP87 (SAPJVM6_87-10006998.SAR)
2.7 SAP WEB DISPATCHER The following Web Dispatcher version will be used:
SAP WEB DISPATCHER 7.42 SP325 (SAPWEBDISP_SP_325-80000043.SAR)
-
8/16/2019 PACT - Detailed Design v1.3
41/52
BNW Consulting | SAP Replatform - Detailed Design41
3 SAP Instance Numbers
3.1 Production Instance NumbersThe Instance numbers for each System and Instance will be derived from the following table:
ASID JSID ASCS AERS JSCS JERSApp
Servers
ERP SP1 00 50 00
HR ECC HRP 01 51 01
SRM SCP 02 52 02
EP POP 13 63 13
BW BIP 04 54 04
SolMan SMP 05 55 15 65 05
3.2 Pre-Production Instance NumbersPre-Production Instance Numbers will be based on the Production Instance Numbers.
ASID JSID ASCS AERS JSCS JERSApp
Servers
ERP SX1 00 50 00
HR ECC HRX 01 51 01
SRM SCX 02 52 02
EP POX 13 63 13
BW BIX 04 54 04
3.3 Quality Instance NumbersQuality Instance Numbers will be based on the Production Instance Numbers.
ASID JSID ASCS AERS JSCS JERSApp
Servers
ERP ST1 00 50 00
HR ECC HRT 01 51 01
SRM SCT 02 52 02EP POT 13 63 13
BW BIQ 04 54 04
-
8/16/2019 PACT - Detailed Design v1.3
42/52
BNW Consulting | SAP Replatform - Detailed Design42
3.4 Non-Production Instance Numbers ASCS and JSCS Instance numbers to be based off Production Instance numbers.
3.4.1 Development
ASID JSID ASCS AERS JSCS JERSApp
Servers
ERP SD1 00 30
HR ECC HRD 01 31
SRM SCD 02 32
EP POD 13 33
BW BID 04 34
SolMan SMD 05 15 35
-
8/16/2019 PACT - Detailed Design v1.3
43/52
BNW Consulting | SAP Replatform - Detailed Design43
4 SAP Central Services (ASCS & JSCS) Cluster
4.1 SAP SPOF’s (Single Point of Failure) ServicesThe design of the SAP system is to only have SPOF’s (Single Point of Failure) on the Cluster. The Primary Application Server (PAS) and
Secondary Application Servers (SAS) will reside on servers outside the Cluster.
SAP Components to be installed on the SCS Cluster Servers are:
ASCS (ABAP Message Server and Enqueue Server)
JSCS (Java Message Server and Enqueue Server)
Enqueue Replication Server
SAP Gateway
WebDispatcher
-
8/16/2019 PACT - Detailed Design v1.3
44/52
BNW Consulting | SAP Replatform - Detailed Design44
4.1.1 SAP Gateway
SAP Gateway will be added to the ASCS system, for Java only systems the SAP Gateway will be added to the JSCS. This will allow
automatic failover for the SAP Gateway which removes the Gateway as a SPOF.
Setting up the SAP Gateway will be done as per OSS Note 1010990 - Configuring a Standalone Gateway in an HA ASCS instance
SAP Gateway (gwmon) commands can be found in OSS Note 64016 – Using the SAP Gateway monitor GWMON
4.1.2 WebDispatcher
A WebDispatcher will be installed for each SAP System and will be made Highly Available by adding the WebDispatcher as a Service in
the SAP System HA Group.
The WebDispatcher will be installed by following OSS Note 1564222 – How to install the SAP Web Dispatcher in a Microsoft Failover
Cluster?
-
8/16/2019 PACT - Detailed Design v1.3
45/52
BNW Consulting | SAP Replatform - Detailed Design45
4.2 SCS Cluster Hostnames and IP Addresses
To provide High-Availability to the SAP Central Services layer in Azure you create a Load Balancer that tests
who is the active node for the cluster in a could service.
There is an Azure limitation of only 1 Load Balancer per Cloud service. To provide High-Availability for all SAP
Systems you need 2 SCS servers per SAP System
4.2.1 Production
Description Nodes Cluster NameClusterName IPAddress
Production SP1 SAP SCSSAPSYD-PSCS01SAPSYD-PSCS51
SAPGEO-PCLU02 X.X.X.X
Production HRP SAP SCSSAPSYD-PSCS02SAPSYD-PSCS52
SAPGEO-PCLU03 X.X.X.X
Production SCP SAP SCSSAPSYD-PSCS03SAPSYD-PSCS53
SAPGEO-PCLU04 X.X.X.X
Production POP SAP SCSSAPSYD-PSCS04SAPSYD-PSCS54
SAPGEO-PCLU05 X.X.X.X
Production BIP SAP SCS
SAPSYD-PSCS05
SAPSYD-PSCS55 SAPGEO-PCLU06 X.X.X.X
Production SMP SAP SCSSAPSYD-PSCS06SAPSYD-PSCS56
SAPGEO-PCLU07 X.X.X.X
4.2.2 Pre-Production
Description Nodes Cluster NameClusterName IPAddress
Production SX1 SAP SCSSAPSYD-XSCS01SAPSYD-XSCS51
SAPGEO-XCLU02 X.X.X.X
Production HRX SAP SCSSAPSYD-XSCS02SAPSYD-XSCS52
SAPGEO-XCLU03 X.X.X.X
Production SCX SAP SCS
SAPSYD-XSCS03
SAPSYD-XSCS53 SAPGEO-XCLU04 X.X.X.X
Production POX SAP SCSSAPSYD-XSCS04SAPSYD-XSCS54
SAPGEO-XCLU05 X.X.X.X
Production BIX SAP SCSSAPSYD-XSCS05SAPSYD-XSCS55
SAPGEO-XCLU06 X.X.X.X
4.2.3 Quality
Description Nodes Cluster NameClusterName IPAddress
Production ST1 SAP SCSSAPSYD-TSCS01SAPSYD-TSCS51
SAPGEO-TCLU02 X.X.X.X
Production HRT SAP SCSSAPSYD-TSCS02SAPSYD-TSCS52 SAPGEO-TCLU03 X.X.X.X
Production SCT SAP SCSSAPSYD-TSCS03SAPSYD-TSCS53
SAPGEO-TCLU04 X.X.X.X
Production POT SAP SCSSAPSYD-TSCS04SAPSYD-TSCS54
SAPGEO-TCLU05 X.X.X.X
Production BIT SAP SCSSAPSYD-TSCS05SAPSYD-TSCS55
SAPGEO-TCLU06 X.X.X.X
-
8/16/2019 PACT - Detailed Design v1.3
46/52
BNW Consulting | SAP Replatform - Detailed Design46
4.3 Cluster Settings
4.3.1 Quorum
File Share Witness Quorum to be used where the File Share Witness is to reside in Azure Sydney.
4.3.2 Parameters
Cluster parameters will be set to Relaxed settings as per Tuning Failover Cluster Network Thresholds
Windows Server 2012 and later:
Parameter Fast Failover
(Default)
Relaxed Maximum
SameSubnetDelay 1 second 1 second 2 seconds
SameSubnetThreshold 5 heartbeats 10 heartbeats 120 heartbeats
CrossSubnetDelay 1 second 2 seconds 4 seconds
CrossSubnetThreshold 5 heartbeats 20 heartbeats 120 heartbeats
4.4 SIOS LicensesThere will be 11 SAP SCS Clusters that will require SIOS to replicate the storage between nodes. 6 for Prod and 5 for PreProd\QA.
Each cluster has 2 nodes so this will require 22 SIOS licenses.
PreProd and QA will use the same license as QA will replace PreProd post go-live.
-
8/16/2019 PACT - Detailed Design v1.3
47/52
BNW Consulting | SAP Replatform - Detailed Design47
5 SAP System
5.1 Production
5.1.1 SAP Central Services
SAP
System
SCS Virtual Host
(Client Access Point) SAP User Network DNS Alias
SP1 SAPGEO-PSP1 X.X.X.X SAPSP1
BIP SAPGEO-PHRP X.X.X.X SAPHRP
SCP SAPGEO-PSCP X.X.X.X SAPSCP
HRP SAPGEO-PPOP X.X.X.X SAPPOP
POP SAPGEO-PBIP X.X.X.X SAPBIP
SMP SAPGEO-PSMP X.X.X.X SAPSMP
5.1.2 SAP Application Servers
Hostname Description SAP User Network
SAPSYD-PAPP01 App Server 1 X.X.X.X
SAPSYD-PAPP02 App Server 2 X.X.X.X
SAPSYD-PAPP03 App Server 3 X.X.X.X
SAPMEL-PAPP01 DR App Server 1 X.X.X.X
SAPMEL-PAPP02 DR App Server 2 X.X.X.X
SAPMEL-PAPP03 DR App Server 3 X.X.X.X
5.1.3 Primary Application Servers
SAP System Hostname
SP1 SAPSYD-PAPP01
BIP SAPSYD-PAPP02
SCP SAPSYD-PAPP03
HRP SAPSYD-PAPP02POP SAPSYD-PAPP01
SMP SAPSYD-PAPP03
5.1.4 Livecache Servers
SAP System Hostname
LCP SAPSYD-PLCA
-
8/16/2019 PACT - Detailed Design v1.3
48/52
BNW Consulting | SAP Replatform - Detailed Design48
5.2 Pre-Production
5.2.1 SAP Central Services
SAP SystemSCS Virtual Host
(Client Access Point)SAP User Network DNS Alias
SX1 SAPGEO-PSX1 X.X.X.X SAPSX1
BIX SAPGEO-PHRX X.X.X.X SAPHRXSCX SAPGEO-PSCX X.X.X.X SAPSCX
HRX SAPGEO-PPOX X.X.X.X SAPPOX
POX SAPGEO-PBIX X.X.X.X SAPBIX
5.2.2 SAP Application Servers
Hostname Description SAP User Network
SAPSYD-XAPP01 App Server 1 X.X.X.X
SAPSYD-XAPP02 App Server 2 X.X.X.X
SAPSYD-XAPP03 App Server 3 X.X.X.X
SAPMEL-XAPP01 DR App Server 1 X.X.X.X
SAPMEL-XAPP02DR App Server 2 X.X.X.X
SAPMEL-XAPP03 DR App Server 3 X.X.X.X
5.2.3 Primary Application Servers
SAP System Hostname
SX1 SAPSYD-XAPP01
BIX SAPSYD-XAPP02
SCX SAPSYD-XAPP03
HRX SAPSYD-XAPP02
POX SAPSYD-XAPP01
5.2.4 Livecache Servers
SAP System Hostname
LCX SAPSYD-XLCA
-
8/16/2019 PACT - Detailed Design v1.3
49/52
BNW Consulting | SAP Replatform - Detailed Design49
5.3 Quality
5.3.1 SAP Central Services
SAP SystemSCS Virtual Host
(Client Access Point)SAP User Network DNS Alias
ST1 SAPGEO-PST1 X.X.X.X SAPST1BIQ SAPGEO-PHRT X.X.X.X SAPHRT
SCT SAPGEO-PSCT X.X.X.X SAPSCT
HRT SAPGEO-PPOT X.X.X.X SAPPOT
POT SAPGEO-PBIQ X.X.X.X SAPBIQ
5.3.2 SAP Application Servers
Hostname Description SAP User Network
SAPSYD-TAPP01 App Server 1 X.X.X.X
SAPSYD-TAPP02 App Server 2 X.X.X.X
SAPMEL-TAPP01 DR App Server 1 X.X.X.X
SAPMEL-TAPP02 DR App Server 2 X.X.X.X
5.3.3 Primary Application Servers
SAP System Hostname IP Address
ST1 SAPSYD-TAPP01 X.X.X.X
BIQ SAPSYD-TAPP02 X.X.X.X
SCT SAPSYD-TAPP01 X.X.X.X
HRT SAPSYD-TAPP02 X.X.X.X
POT SAPSYD-TAPP01 X.X.X.X
5.3.4 Livecache Servers
SAP System Hostname IP Address
LCT SAPSYD-TLCA X.X.X.X
-
8/16/2019 PACT - Detailed Design v1.3
50/52
BNW Consulting | SAP Replatform - Detailed Design50
5.4 Development
SAP System Description HostnameIPAddress
DNS Alias
SD1 SD1 Development SAPSYD-DAPP1 X.X.X.X SAPSD1
HRD HRD Development SAPSYD-DAPP1 X.X.X.X SAPHRD
SCD SCD Development SAPSYD-DAPP1 X.X.X.X SAPSCD
POD POD Development SAPSYD-DAPP1 X.X.X.X SAPPOD
BID BID Development SAPSYD-DAPP1 X.X.X.X SAPBID
SMD SMD Development SAPSYD-DAPP1 X.X.X.X SAPSMD
Livecache Livecache Development SAPSYD-DLCA1 X.X.X.X
-
8/16/2019 PACT - Detailed Design v1.3
51/52
BNW Consulting | SAP Replatform - Detailed Design51
6 WebDispatcherThe WebDispatcher will be installed by following OSS Note 1564222 – How to install the SAP Web Dispatcher in a Microsoft Failover
Cluster?
6.1 WebDispatcher Naming ConventionThe naming of the WebDispatcher will be as follows:
First Letter: W
Second Letter: SAP System Type using the following values:
P – Production
X – Pre-Production
D – Development
Q – QA
C - Consolidation
T – Training
S – Sandpit
Third Letter: Instance number loosely based on the table in section Production Instance Numbers
6.2 Production WebDispatcher A WebDispatcher will be installed for each system using the table below.
Message Server
Instance NrWebDispatcher
SID
WebDispatcher
Inst_Nr
WebDispatcher
icm http port
SP1 00 WP0 70 8200
HRP 01 WP1 71 8201
SCP 02 WP2 72 8202
POP 13 WP3 73 8213
BIP 04 WP4 74 8204
SMP 05 WP5 75 8205
6.3 Pre-Production WebDispatcherWebDispatcher will be installed for each system.
Pre-Production WebDispatcher Instance Numbers will be based off the Production WebDispatcher Table but using the Pre-Production
SAPSIDs.
6.4 Non-Production WebDispatcherWebDispatcher will be installed for each Non-Prod system.
Non-Production WebDispatcher Instance Numbers will be based off the Production WebDispatcher Table but using the Non-Production
SAPSIDs.
-
8/16/2019 PACT - Detailed Design v1.3
52/52
7 SAP Utility\Interface ServerPACT have a requirement for a SAP Utility Server. There is a user requirement to provide HA for the Utility Server in Azure.
This server will host the following components:
Host SAPRouter
Host the SAP custom Temporary working area. Eg, RP1 share
Host Sky software Jellco palletiser
Synchronisation scripts for Azure files will also run on the utility server.
8 SAP PrintingPrint devices are created directly on all app servers.
This is not best practice but is required due to custom code.
9 SAPTransSAPTrans will be hosted on Azure Files
This will provide a Highly-Available SAPTrans with triple redundancy without the requirement for an additional Virtual Machine.
All SAP Servers will have access to the SAPTrans share.