advertisement

DB CTSC SAP WinSQL

50 %
50 %
advertisement
Information about DB CTSC SAP WinSQL
Entertainment

Published on October 13, 2007

Author: Cannes

Source: authorstream.com

advertisement

Microsoft – The Reliable Platform for SAP Windows Server 2003, SQL Server and Business Intelligence:  Microsoft – The Reliable Platform for SAP Windows Server 2003, SQL Server and Business Intelligence Mario Mendiola Microsoft-SAP Technology Center Microsoft Corporation Tilo Boettcher SAP Program Manager CTSC Microsoft Corporation Slide2:  Microsoft and SAP Introduction Business Intelligence using SQL Server and SAP High Availability for SAP Environments 64-bit Computing for SAP Environments SQL Server for SAP SAP and Microsoft: Achievements:  SAP and Microsoft: Achievements Strategic Agreement: Microsoft and SAP to heavily invest in Webservices Agreement between Bill Gates and Hasso Plattner First R/3 Release on Windows NT MS SQL Server Support MS Exchange integration with R/3 3.1 April 93 April 94 July 95 Aug 95 Jan 97 Oct 97 Microsoft selects SAP for its global finance implementations DCOM Component Connector availability Oct 99 / Feb 00 Nov 01 Microsoft and SAP partner for mySAP.com and Windows 2000 launch Microsoft uses SCM to manufacture XBOX April 03 May 04 SAP NetWeaver announced with .NET support Jan 03 Windows Server 2003 support April 05 Microsoft and SAP announcing development and sales of the first joint product Microsoft and SAP – Working Together:  Microsoft and SAP – Working Together Microsoft runs SAP and SAP runs Microsoft Joint Development teams SAP and Microsoft each have deep technical experts working in Redmond and Walldorf Collaborative Technology Support Center (CTSC) Customer Solution Center Cross-company team of technical experts located in Walldorf Drives interoperability between SAP and Microsoft solution stacks Dedicated Field Resources Regional HQ in America, EMEA, Japan, and APAC SAP Center of Excellence – dedicated SAP Consultants SAP & Microsoft: 13 Successful Years:  SAP & Microsoft: 13 Successful Years Leading Operating System for the last 6 years Over 69,000 SAP installations on Windows Server (>57% of all SAP installations) 66% of new SAP installations on Windows, 42% of all on SQL Server Microsoft Windows share of new SAP installations Source: SAP AG Slide6:  $14.7B (USD); 64,600 employees 2,000 concurrent users $22.6B (USD); 73,164 employees Worldwide BW Implementation on 64-bit Windows/SQL $48B (USD); 234,000 employees APO 4.1; Migration from Unix Tru64 Alpha/Oracle $65.4B (USD); 253,000 employees 200,000+ SAP EP 6.0 Users. 1st SQL in Datacenter $18B (USD); 34,306 employees Migration from AIX/Oracle to Windows/SQL $40B (USD); 11,000 employees “Platform of the future for JTI” Fortune 500 Customers Running SAP on the Microsoft Platform $33.3B (USD); 40,000 employees SAP BW implementation on 64-bit Windows/SQL Windows Server & SQL Server Meets Needs of Largest SAP Workloads:  Windows Server & SQL Server Meets Needs of Largest SAP Workloads Time Pilgrim’s Pride SAP 4.6C/D Modules: SD, PP, FI, HR, IS-Oil functionality Database volume: >8.6 TB (Single Instance) SAP response time for online users ~1 second Between 900,000 and 1,100,000 SAP dialog steps/day Peak hour at 350,000 SAP dialog steps (month-end processing) 1,800 Concurrent Users Biggest table: 600GB (GLPCA) Windows Server & SQL Server – Meets Customers Highest Reliability Requirement:  Windows Server & SQL Server – Meets Customers Highest Reliability Requirement AKZO Nobel HQ in The Netherlands, 20 Large Factories ww in 85 Application Areas SAP Modules: FI/CO AM, PM, CCMS, CCS, CRM More than 2,000 concurrent SAP users 99.999% Availability Migration from UNIX/Oracle “Since November 2001, we have not experienced a minute of down-time” Ad Gieling - Infrastructure Information Manager (Fall 2003) Slide9:  High Availability for SAP Environments Business Intelligence using SQL Server and SAP Microsoft and SAP Introduction 64-bit Computing for SAP Environments SQL Server for SAP Slide10:  Storage Database Message Server Enqueue Server Server Application ABAP SCS Instance Message Server Enqueue Server J2EE SCS Instance Network MSCS Cluster for SCS Instance SAP Enqueue Replication MSCS Cluster for DB H/W failure SQL Server 2005 DB Mirroring MSCS Cluster Network Load Balancing MSCS Cluster for Server redundancy HA RAID configs in storage Windows Multipathing The Hierarchy of High Availability Solutions Microsoft Platform Reduces TCO and Improves ROI for SAP Projects:  Microsoft Platform Reduces TCO and Improves ROI for SAP Projects Can be 50-80% of Overall TCO SAP Platform / Infrastructure Costs “Moving ERP to SQL Server Yields Substantial Savings” Prepared by: Wipro PSA Practice, Inc., Boston, Massachusetts http://www.wipro.com/prodesign/focusareas/productstrategy/ Total Cost of Ownership – Customer Evidence:  Total Cost of Ownership – Customer Evidence Danfoss In 2002, Danfoss needed to double the capacity of the system. They considered Sun Solaris, IBM's AIX and HP-UX. After migrating their largest SAP instance to Windows and SQL Server, Danfoss scaled up to 1,600 concurrent users. Cut TCO by 50%, Improved performance by ~40% Database Server : 800Gb supporting 4500 named users SAP Modules: Core R3, PP, SD, FI, MM SQL Server Offers Lower TCO in Every Cost Category Slide13:  64-bit Computing for SAP Environments Business Intelligence using SQL Server and SAP Microsoft and SAP Introduction High Availability for SAP Environments SQL Server for SAP So why the need for 64-bit?:  So why the need for 64-bit? 32-bit applications All 32-bit applications are limited to a 4GB virtual address space An application can utilize 2GB (3GB using /3gb) of the 4GB. Remainder is reserved for OS addresses Using AWE, some applications can use larger amounts of memory by mapping additional memory into the virtual address space 64-bit applications Huge, flat virtual address space No mapping needed for large memory access SAP Solutions Benefit from 64-Bit:  SAP Solutions Benefit from 64-Bit Very large amounts of physical main memory Each process can access virtually unlimited amounts of memory Less fine tuning of parameters Databases can access very large caches Less servers are required Immediate benefits for mySAP components: Unicode will require more than 2GB address space SCM APO LiveCache will need 64 Bit No memory limitations for complex batch jobs Slide16:  16 Many SAP 64-bit Win/SQL SAP Deployments SAP on Itanium-Based Systems:  SAP on Itanium-Based Systems Runs since more than 4 years Hundreds of productive systems are on Windows Server 2003 (Itanium) and SQL Server SQL Server is SAP’s main development database for SAP on Itanium SAP Support for Windows/SQL Server on Itanium Support does start with main products using 4.6D kernel Full SAP NetWeaver 2004s stack available on IA64 What‘s Next: Windows Server „Longhorn“ and Itanium:  What‘s Next: Windows Server „Longhorn“ and Itanium Windows „Longhorn“ Server for Itanium Optimized for Database workload and LOB Workloads (SAP) Highest level of performance, reliability and scalability The leading alternative for RISC-based UNIX servers No implementation of Windows Server roles that don't apply to above workloads (fax server, Windows Media Services, Windows SharePoint Services, file and print servers, and others) SAP and Fujitsu are preferred partners for Windows „Longhorn“ Server on Itanium TAP program For more information on Windows „Longhorn“ Server on Itanium check: http://www.microsoft.com/windowsserversystem/windowsserver/bulletins/longhorn/itanium_bulletin.mspx 64-bit with Microsoft and AMD:  64-bit with Microsoft and AMD Microsoft and AMD provide a complete solution Address large memory beyond 4-GB limit Windows x64 utilizes key AMD technologies: Direct Connect Architecture Dual Core Processors AMD64 Processors compatible 32 & 64-bit Windows Enhanced Virus Protection / Data Execution Prevention Built into AMD64 & Windows x64 platform 10/13/2007 Windows Server 2003 x64 Editions:  Windows Server 2003 x64 Editions Increased adoption of x64 server hardware Run 32-bit applications at high speed See improved performance in memory-hungry applications Breakthrough performance & scalability for 64-bit applications Preserve existing investments in Windows-based technology Smooth transition to 64-bit computing 10/13/2007 Target x64 Server Workloads:  Target x64 Server Workloads Active Directory Web Serving Business Applications (e.g. SAP) 10/13/2007 How They Compare:  How They Compare 2 GB 8 TB 10/13/2007 How They Compare:  How They Compare 2 GB 8 TB 4000 x 10/13/2007 How They Compare:  How They Compare 2 GB 8 TB 4GB 10/13/2007 How They Compare:  How They Compare 2 GB 8 TB 10/13/2007 Where Will SQL Server 64-Bit Help? :  Where Will SQL Server 64-Bit Help? Memory Hungry Workloads NOTE: Database buffer pages have access to > 3GB limit even on 32-bit, by using AWE But AWE cannot be used for: Procedure cache / query plans Workspace Memory for large hash joins and hash aggregates Workspace Memory for large sorts and index build operations Per-connection memory Per-thread memory And AWE map / unmap operations cost CPU TCO for Databases in an SAP Environment:  TCO for Databases in an SAP Environment 27 Slide28:  DEMO ADS UME Components Windows 2003 Server SAP Enterprise Portal Active Directory Slide29:  www.microsoft-sap.com Slide30:  SQL Server for SAP Business Intelligence using SQL Server and SAP Microsoft and SAP Introduction High Availability for SAP Environments 64-bit Computing for SAP Environments SAP And Microsoft: Highlights:  31 April 93 Agreement between Bill Gates and Hasso Plattner April 94 First R/3 Release on Windows NT July 95 Microsoft selects SAP for its global finance implementations MS SQL Server Support Aug 95 SAP NetWeaver announced with .NET support Jan 03 … Strategic Agreement: Microsoft and SAP to heavily invest in Webservices May 04 April 05 Microsoft and SAP announcing development and sales of the first joint product codenamed Mendocino – now “Duet” SAP And Microsoft: Highlights 31 Platform Overview:  32 Platform Overview Largest SAP customers choosing and running on the Microsoft platform today 69,000 SAP installations on Windows, representing 57% of all existing installations 32,500 SAP installations on SQL Server, representing 27% of all existing installations SQL Server is reference platform for Windows development at SAP. SAP technical staff sit with SQL dev in Redmond. Microsoft runs SAP (licensed mySAP Business Suite) SAP runs Microsoft (re-signed Enterprise Agreement) 32 Slide33:  33 SQL Server 7.0 SQL Server 2005 SQL Server 2000 Lowest TCO Automatic Tuning Reliability and Security Integrated Business Intelligence High availability Security Developer productivity Native XML First to include Enterprise ETL and Deep Data Mining Performance, scalability focus XML support First to include Notification First to include Data Mining & Reporting Re-architecture of relational server Extensive auto resource management First to include OLAP & ETL Cross-release objectives SQL Server 6.0/6.5 Differentiation from Sybase SQL Server Windows integration First to include Replication 1st Generation 2nd Generation 3rd Generation SQL Server has been supported by SAP since the 1st generation. SQL Server 2005 was certified for SAP Feb 2006 SAP indicates that SQL Server 2005 is ready for the most demanding deployments:  34 SAP indicates that SQL Server 2005 is ready for the most demanding deployments Link: http://www.microsoft.com/sql/solutions/sap/default.mspx SQL on Windows is the platform of choice for new SAP deployments:  35 SQL on Windows is the platform of choice for new SAP deployments 69,000+ SAP deployments on Windows; over 52% of existing installs 42% of all new SAP deployments on SQL Server 32,500+ SAP deployments on SQL Server … and growing 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 Large SAP Customers on Windows and SQL:  36 Large SAP Customers on Windows and SQL Large Single Instance SAP Customers on Windows/SQL – #of concurrent users:  37 Large Single Instance SAP Customers on Windows/SQL – #of concurrent users Slide38:  38 Large SAP Customers on Windows/SQL, ordered by DB size Slide39:  39 Many SAP 64-bit Win/SQL SAP Deployments Slide40:  40 100+ Microsoft IT applications live today One SQL instance Staging DW for all Microsoft data 2.8 TB of Data, 1800+ Tables, 500 subscribing systems Sales Revenue Reporting and BI 9,000 users, 25,000 reports per week SAP Payroll – critical application! 2,300 SAP GUI users; 60,000+ total users 300,000+ dialog steps per day 0.5-0.6 second response time 99.98% Windows/SQL availability This availability includes downtime >90% of time on beta software Microsoft has been running its worldwide operations with SAP on SQL 2005 since Aug 2004 Microsoft SAP Landscape:  41 Microsoft SAP Landscape Best TCO for SAP deployments: SQL Server includes all key components:  42 Base Product Manageability High Availability Business Intelligence Multi-core Best TCO for SAP deployments: SQL Server includes all key components SQL Server 2005 provides ultra high availability for SAP deployments:  43 Fast & Predictable Failover Database Mirroring (NEW) Failover Clustering Always Online Online index operations (NEW) Fast recovery (NEW) Fine-grained online repairs (NEW) Database snapshots (NEW) High Throughput Data Access Snapshot isolation (NEW) SQL Server 2005 provides ultra high availability for SAP deployments Very large scalability: 93K concurrent users on a single 64-proc server. Certified by SAP:  44 10 times the largest SAP customer in the world Max number of concurrent users 93,000 26,000 HP Integrity Superdome The SAP certified Sales and Distribution three-tier standard application benchmark, using SQL Server 2005 and Windows Server 2003 running on HP and Intel hardware, delivered 93,000 concurrent users. This 64-processor benchmark, was certified on Nov 3, 2005, Very large scalability: 93K concurrent users on a single 64-proc server. Certified by SAP A large SAP implementation has, on average, 2,000 concurrent users Outstanding value: 18,000 concurrent users on standard a 4-proc server:  45 8X Improvement! No. of proc for 18,000 concurrent users 32 4 HP ProLiant The SAP certified Sales and Distribution three-tier standard application benchmark, using SQL Server 2005 and Windows Server 2003 running on HP and AMD hardware, delivered record-breaking value, with 18,000 concurrent users in a standard commodity 4-processor server. This 4-processor benchmark was certified on Jun 27, 2005. Outstanding value: 18,000 concurrent users on standard a 4-proc server Fastest ever SAP banking benchmark: 8.279 million postings to bank accounts per hour*:  46 Highest result ever in SAP banking benchmarks 8.279 million postings to bank accounts/hr, and 4.27 million balanced accounts/hour 8,279,000 HP and Microsoft delivered the first SAP certified Transaction Banking (TRBK) Standard three-tier Application Benchmark. The benchmark, certified on Dec 22, 2005, running SQL Server 2005 and Windows Server 2003 Datacenter, on a 16-processor db server, HP and Intel hardware, is based on SAP Release Account Management 3.0 (32 bit). The benchmark achieved 8.279 million postings to bank accounts per hour and 4.27 million balanced accounts per hour. Fastest ever SAP banking benchmark: 8.279 million postings to bank accounts per hour* * As of Dec 2005 Key SQL Server 2005 Features Used by SAP -- no need for any special db version --:  47 Key SQL Server 2005 Features Used by SAP -- no need for any special db version -- Ultra high availability Online operations 64-bit More SAP features Fast, predictable failover times Mirror data, no single HW point of failure Transparent failover Most operations online, no downtime window Fine grained online repairs Restore data at a page level Online index operations X64 and IA64 support 64-bit engine optimizations Break 32-bit memory limitations Ideal for Unicode implementations Equal disk data formats (32-bit & 64-bit), easy to upgrade SAP BW uses table partitioning – faster backup, scale out and speed BW cubes SNAC (SQL Native Access Client) for faster access SAP supports all their new products on SQL Server 2005 :  48 SAP supports all their new products on SQL Server 2005 SAP Note No. 905634, Jan 20 2006 Supported SAP products based on SAP_BASIS 6.20 and SAP_BASIS 6.40 BW 3.10 x86, IA-64 SCM 4.0 x86, IA-64 EBP/CRM 4.0 x86, IA-64 ECC 5.0 SR1 x86, IA-64, x64 NetWeaver'04 SR1 x86, IA-64, x64 SCM 4.1 x86, IA-64, x64 SRM 4.0 SR1 x86, IA-64, x64 CRM 4.0 SR1 x86, IA-64, x64 R3E 4.7 x200 SR1 x86, IA-64, x64 SolMan 3.2 SR1 x86, IA-64, x64 Note: NetWeaver'04 includes, among other components, BW3.5 and EP6.0. Upgrade? All 7.00 based SAP products, which are supported on SQL Server 2000, can be upgraded to SQL Server 2005. And R/3 4.6C? SAP plans to adapt R/3 4.6C to SQL2005 by mid 2006 Slide49:  DEMO Online Index Rebuild with SQL 2005 Components Windows 2003 Server SAP XI System SQL Server 2005 Slide50:  Business Intelligence using SQL Server and SAP SQL Server for SAP Microsoft and SAP Introduction High Availability for SAP Environments 64-bit Computing for SAP Environments SQL Server 2005 includes Reporting Services – simple reporting of any data:  51 Reporting Services Open, extensible enterprise reporting solution – access any vendor database Report authoring, management, delivery Office System integration VS.NET development environment SQL Server 2005 enhancements Integration with AS, IS, management tools Developer enhancements Improved report interactivity Rich end-user reporting Report Builder Extending the Reach of Reporting Services Ad hoc Reporting for the End-User SQL Server 2005 includes Reporting Services – simple reporting of any data SQL Server 2005 SP1 allows customers to use reporting services to add value to SAP BW data:  52 Real-time insight into business trends Better decision making across the org Comprehensive and cost-effective SQL Server 2005 SP1 allows customers to use reporting services to add value to SAP BW data Reporting Services Provides Insight From SAP BW Data:  53 Seamless Insight into SAP business data View SAP BW business content through reports Enterprise reporting across all business data Increase impact of SAP BW information High Quality Connectivity & Tools Long term commitment to interoperability Connectivity through “Microsoft .Net Data Provider for SAP NetWeaver BI” “Custom Query Designer” Comprehensive & Cost Effective SQL license includes Reporting Services Run-time license valid for ‘Unified Solution’ Full-use license valid for licensed SAP users New Data Provider to SAP NetWeaver BI New Visual Query Designer Reporting Services Provides Insight From SAP BW Data RS for SAP BW is certified by SAP*, as it uses standard integration components:  54 RS for SAP BW is certified by SAP*, as it uses standard integration components As of April 10th, 2006, it is in the final process of receiving the certification number from SAP Slide55:  DEMO BI using SQL and SAP Components Windows 2003 Server SAP BW SQL Analysis Services Business Scorecard Manager SAP and Microsoft are also providing additional value through integrating Office with SAP: “Duet”:  56 SAP and Microsoft are also providing additional value through integrating Office with SAP: “Duet” Time management Use Outlook calendar as front-end for SAP time reporting Budget monitoring Receive reports in your Outlook Inbox and work offline Leave management Add leave requests as calendar items integrated with SAP approval guidelines Org management Up-to-date information about employees integrated in Outlook contacts 56 Duet uses Microsoft SQL Server Express as the embedded engine to store data Slide57:  DEMO Duet V 1.0 Budget Monitoring Components Outlook Add-Ins Duet Server (Win 2003 based) mySAP Business Suite enhancements and NetWeaver 2004 Use case and benefits End to End scenario out of the box Pre configured for ESS scenarios SOA approach: Usage of Web Services, SSO and ESA Fast Track Easy to use Fully integrated, no development needed What is next?:  58 What is next? SAP Deployment Project Select System integrator, Hardware partner, and db. Microsoft frequently uses key System Integrators: Accenture, Avanade, Realtech, CapGemini, LogicaCMG and HP consulting. We also have worked with HW partners with SAP certified infrastructure: IBM, HP, Fujitsu and Dell. HW partners execute the HW sizing. Define business processes, select mySAP version. Consulting firms/System Integrators are key. This takes the largest amount of time in a SAP project Get trained. SQL Server Training SQL Server 2005 for the Oracle DBA Understand how MS runs its own SAP instance 3-day MS-SAP SQL Technical Training In-depth “How To” Technical Whitepaper Find out more about SQL and SAP. Read cases, find out what SAP says about SQL Server 2005, and get latest news on Reporting Services for SAP BW here Execute the technical migration. SAP deployments with < 2TB can be migrated over a weekend. Use specialized technical firms like Realtech or Avanade for complex technical migrations. Use only SAP certified firms that are certified for SAP migrations. Use the SAP provided migration tool, that takes the same amount of time to migrate from any database to any other database If you chose SQL Server 2005... Enjoy better TCO, reduced management complexity, most value (RS for SAP BW), zero cost hot-standby/backup SQL licenses Slide59:  www.microsoft-sap.com

Add a comment

Related presentations