pact - detailed design v1.3

Upload: jagdish-modi

Post on 05-Jul-2018

217 views

Category:

Documents


0 download

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.