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
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
* * 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.
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.
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...
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.
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....
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.
Ready to download the document? Go ahead and hit continue!