Business Value - download.microsoft.com

Business Value - download.microsoft.com

SAP Technical Workshop THE AGILE BUSINESS Windows Server for SAP Solutions Elke Bregler Technologist, Enterprise Applications Microsoft Information Technology Agenda Taming the beast SAP Backbone Extend SAP with Web Applications Landscape Reporting Microsoft Platform SQL Configuration Security Metrics Upcoming projects Taming the beast Process Standard Business Process Best of Breed MSFT Technology/SAP Business processes Change control - Promote to Production strategy Simplify

Single System/Clients Single Sign-on Consolidation Dogfood (First and Best Customer) Extend and Empower Leveraging new technology Microsoft SAP Backbone (1/2) DCOM R/3 - SAP Enterprise 4.7 Vertex sales tax BSI payroll tax Esker - faxing SAP .Net Connector SQL Analysis & Reporting Services GTS 2.0 SAP Global Trade Services BW SAP Business Warehouse 3.2 SCEM SAP Supply Chain Mgmt. 4.0 APO SAP Advanced Planner and Optimizer 3.0a

Exchange 2003 Via SMTP Connector Tidal Job Scheduler Microsoft SAP Backbone (2/2) R/3 - SAP Enterprise 4.7 Finance: Financial Accounting, (Enterprise) Controlling, Corporate Finance Mgmt., Treasury, Real Estate, Project Systems FI CO EC CFM TR RE PS Human Resources: Benefits, Payroll, Organizational Mgmt., Personnel Time and Administration BN PY OM PT Supply Chain: Sales and Distribution, Material Management SD MM APO SAP Advanced Planner and Optimizer 3.0a Supply Network Planning and Demand Planning GTS SAP Global Trade Services Legal & Logistics Services Denied Party Screening PA BW -SAP Business

Warehouse 3.2 Finance Accounts Payable Policy Compliance Vendor Spend Org. Spend Treasury - Exchange Asset Management Supply Chain Product ID Recon. Screening Reports DP SNP 2.0 SCEM SAP Supply Chain Mgmt. LLS Event Management BW 4.0 EM SAP Statistics 1.9+ TB in a single, central database 2,300 GUI users; 57,000+ total users 200-600 concurrent users (seasonal)

300,000+ dialog steps per day 100,000+ batch jobs per month 0.7 seconds dialog response time 99.98% Windows/SQL availability 35% of uptime is on beta software Extend SAP with Web Apps Denied Party Screening R/3 SAP .Net Connector Finance MSMarket Intranet Procurement MSInvoice Internet Invoicing MSExpense Expense Reimbursement Supply Chain MSInquire Purchase & Payment Inquiry MSOrder Internet Order Status Human Resources HRWeb Personal Information Benefits Online benefit enrollment Paystub Electronic Paystub DirectDeposit Direct deposit Headtrax Organization self service MS Review Compensation Review MS Eval Performance Evaluation GTS Extranet R/3 User Access Corpnet Internet IPSec HTTP HTTP

SAPGUI ` User Web Server ` ` Web User Web User SAP Application Servers SAN Web Server SAP .Net Connector & SAPRouter HTTP 1.3Tb 1.9Tb 1.4TbDB ` PPTP SQL Server SAP .Net Connector & SAPRouter Partner SAPGUI User BIGIP Production SAP .Net Connector & SAPRouter

2 x 1Ghz 750Mb RAM File Server Cluster 2 x 2.4Ghz 4Gb RAM 5 Tb HP EVA SQL Server & Central Instance 4 x 1.5Ghz 8 Gb RAM BW 4 Dialog 2 x 3.0Ghz 4Gb RAM SQL Server 8 x 900 Mhz 16Gb RAM APO SQL Server 8 x 900Mhz 8Gb RAM SQL Server & Central Instance 4 x 1.8Ghz 8 Gb RAM 2.5 Tb HP StorageWorks SAN GTS

Central Instance 8 x 900 Mhz 16Gb RAM SCEM External Server Tax 4 x 1.5 Ghz 4Gb RAM Central Instance LiveCache 8 x 700Mhz 8 x 900Mhz 4Gb RAM 16Gb RAM Secondary SQL Server 2005 8 x 2Ghz 16Gb RAM Primary DB Server SQL Server 2005 8 x 2Ghz 16Gb RAM 2.5 Tb HP StorageWorks SAN Log Shipping Central Instance 4 x 1.9Ghz 4Gb RAM 3 Dialog 8 x 700Mhz 4Gb RAM 3 Dialog, 2 Batch, 1 CIF 8 x 900Mhz, 2Ghz 4Gb RAM

R/3 1 Batch/1 Dialog 4 x 2.2 Ghz 16Gb RAM x64 Server Test SVC File Servers 2 x 2.4Ghz 2Gb Ram Sharepoint Test 4 Way 1.8Ghz 2Gb Ram SCEM Test & Dev Central Instance 4 x 2.5 Ghz 16Gb Ram SQL Server & Central Instance 4 x 1.5Ghz 8 Gb RAM GTS Test & Dev SQL Server 4 x 2.5 Ghz 16Gb Ram BW Test & Dev SQL Server & Central Instance 4 x 1.8Ghz 8 Gb Ram LiveCache 8 x 900Mhz

16Gb Ram HP EVA Storage Area Network B11 Log Shipping APO Test 3 Dialog 8 x 900Mhz 4Gb RAM Central Instance & SQL Server 4 x 2.5 Ghz 8Gb Ram SQL Server 8 x 2.0Ghz 16Gb RAM R/3 Prod 2 Dialog 2 x 3.0Ghz 4Gb Ram SQL Server 8 x 2.0Ghz 16Gb RAM Central Instance 4 x 1.9Ghz 4Gb Ram 1 BTC/1 DIA 4 x 2.2 Ghz 16 Gb RAM x64 Server

4 SAP .Net Connector & SAPRouter 2 x 1.0Ghz 1Gb Ram R/3 Test 3 DIA, 2 BTC, 1 CIF 4&8 x 900Mhz to 1.8Ghz 4Gb RAM Disaster Recovery Remote data center Silicon Valley All primary test instances Log shipping from all production instances Re-deploy in a catastrophic event Log Shipping Feature of SQL Server x64 Server Dialog 8 x 900Mhz 4Gb Ram Batch 8 x 900Mhz 4Gb Ram 1 BTC/1 DIA 4 x 2.2 Ghz 16 Gb RAM x64 Server Benefits

Server consolidation Data center costs less (less U count) Cheaper than i64 server No memory constraints (3GB) anymore Faster than 2 old servers with 8 CPUs each R/3 Transport & Refresh Production Periodic Refresh Tech Sandbox App Sandbox Dryrun Development Refresh = Database restore with custom basis table preserved Transports Test Weekly Refresh Reporting SQL Warehouse R/3 Regional Business Distribution Consumers Extracts

BW GTS SQL Server Analysis Services Office Web Components or SQL Views SQL Server Reporting Services Microsoft Platform IIS 6.0 ASP.Net SAP .Net Connector GTS BW APO SCEM R/3 Reporting Services NLB Server Cluster Analysis Services x32-bit x64-bit SQL Disk Configuration LTO

12 200gb logical disks (Raid 0+1) 1 SQL file per disk (H: - S:) 3 Drive LTO Array LTO (2*3 LTOs) SAN H: I: J: Full Backup once a week; Daily differential on disk SQL Configuration Best Practices Engineer SQL and disk configuration Drive count RAID levels Separate Data, Log, Tempdb, backups Format 64k block sizes on data drives Use multiple logical drives and files to spread out the I/O (also has a big impact on backup throughput) Grow SQL files regularly to leverage proportional fill Monitor Software Update Services IPSec Hardening

Microsoft Baseline Security Analyzer (Auto) Update Security = Diligence! Review Patching Antivirus Network Security SAP Metrics Workload Dialog Steps Dialog and Update response times SAP Database Growth Availability December-04 November-04 October-04 September-04 August-04 July-04 June-04 May-04 April-04

March-04 February-04 January-04 December-03 November-03 October-03 September-03 August-03 July-03 June-03 May-03 April-03 March-03 February-03 January-03 December-02 November-02 October-02 September-02 August-02 July-02 February-02

January-02 December-01 November-01 October-01 September-01 August-01 Millions Workload Dialog Steps per month 25 20 15 10 Others Update RFC DIALOG 5 0 December-04 November-04 October-04 September-04 August-04 July-04

June-04 DB Server Upgrade to 8 way 2Ghz May-04 April-04 March-04 February-04 January-04 December-03 R/3 Enterprise Upgrade November-03 October-03 September-03 August-03 July-03 June-03 May-03 April-03 3.0 March-03 3.5

February-03 January-03 Seconds Dialog, Update, RFC Avg. Response Time 4.0 Batch/GBI Locking (Not SQL 2005) 2.5 2.0 DIALOG UPDATE RFC 1.5 1.0 0.5 0.0 R/3 Database Growth 2,000 SQL Server 2005 Beta 2 1,600 R/3 Enterprise Upgrade 1,400 Pre-upgrade data conversion

1,200 Archiving 1,000 800 Size Used SQL 6.5 - 7.0 Upgrade 600 400 SQL 7.0 - 2000 Upgrade 200 1997 1998 1999 2000 2001 2002 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q4 Q1 Q2

Q2 Q3 Q1 Q2 Q3 Q4 Q1 Q3 Q4 Q3 Q4 Q1 Q2 Q4 Q1 Q2 Q3 0 Q3 Q4 Q1 Q2 Gigabytes 1,800 2003 2004 2005 Best Practices All servers (dev, test, prod) housed in production data centers Homogenous environment OS & DB Platform Hardware

Quarterly Release Cycles Leverage for platform upgrades, SPs Keep SPs up to date SAN consolidation Upcoming Projects Business HR - Talent Management Volume Licensing and Pricing Xbox Silicon Operations management App2App scenario for managing Xbox supply chain BizTalk 2004 + BizTalk Adapter for mySAP Business Suite Technical/Operations SQL Server 2005 Data Mirroring 64 Bit Servers Unicode Consolidation

x64 (AMD) 4 way 16Gb RAM consolidation Replacing two 8 way Xeon 4Gb Ram Dual Instance Tidal Software Microsoft Operations Manager SAP integration (Horizon) Enterprise Scheduler batch management MIIS Management Agent for SAP Thank You! For more information visit: www.microsoft-sap.com Server Counts Application R/3 SQL App Web File Misc Total Prod. 3 9 7 2

4 25 Test 2 8 4 2 1 17 Dev 1 Sandbox 3 6 Prod. 1 4 * 1 (LC) 6 Test

1 5 * 1 (LC) 7 Dev 1 1 * 1 (LC) 3 Sandbox 1 2 * 1 (LC) 4 BW All

3 GTS Prod 2 2 Test/Dev 2 2 Sandbox 1 APO Total 21 39 2 3 2 11 56 20 * 3 3

* * 4 9 * * 4 * * 1 15 4 9 88 * Servers shared between environments 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Recently Viewed Presentations

  • URL's for free Flowcharting software - UNC Asheville

    URL's for free Flowcharting software - UNC Asheville

    Flowchart - Graphically depicts the logical steps to carry out a task and shows how the steps relate to each other. Pseudocode - Uses English-like phrases with some simplified programming terms to outline the program.
  • United States History - cpb-us-e1.wpmucdn.com

    United States History - cpb-us-e1.wpmucdn.com

    Gabriel Prosser's Rebellion. Before the election of 1800 took place, another event in the summer demonstrated the conflict surrounding the unresolved issue of slavery. Gabriel Prosser led a rebellion of slaves in Richmond, Virginia, they intended to take over Richmond...
  • Management Sciences New Graduate Student Orientation

    Management Sciences New Graduate Student Orientation

    1. Departmental Contacts. Computer Systems Administrator. Mr. Vu Huynh, [email protected], CPH 4318. Secretary to the Chair. Ms. Gini Kennings, [email protected] ...
  • Nuclear Chemistry Topics:

    Nuclear Chemistry Topics:

    Radioactive Decay. Certain isotopes of certain elements, such as Uranium-235, have unstable nuclei. These are called radioactive isotopes; given some time, these unstable nuclei will undergo radioactive decay to give off energy and become more stable.
  • MOVE TITLES TO LEGIBLE SPOT OVER IMAGE - Citrus Heights

    MOVE TITLES TO LEGIBLE SPOT OVER IMAGE - Citrus Heights

    Chapter 1 - Introduction . Chapter 2 - Market Demand Analysis. Chapter 3 - Transit Service Overview. Chapter 4 - Evaluation of Existing Bus Service Performance. Chapter 5 - Paratransit Services ... Ensure Citrus Heights is connected to the regional...
  • Audience Appeal  Shakespeare demonstrated the Elizabethan belief that

    Audience Appeal Shakespeare demonstrated the Elizabethan belief that

    Macbeth isn't one of the king's ancestors, so he can't be the good guy, in spite of his fairly long peaceful rule (1040-1057). Banquo was an ancestor of James and is shown in the play to be a virtuous person....
  • A Turkey for Thanksgiving

    A Turkey for Thanksgiving

    Our phonics pattern of the week is the vowel teams of ay and ai. We usually use ay at the end of words, while ai is used in the middle of words. Remember that with vowel teams, when 2 vowels...
  • LINE - cabarrus.k12.nc.us

    LINE - cabarrus.k12.nc.us

    You are more concerned with capturing the ACTION rather than drawing accurately. It captures the movement of the subject rather than recording the details of the form. DESCRIPTIVE LINES ... Scumbling: Practice Assignment. Line Technique worksheet.