480 likes | 615 Views
Delivering mission critical confidence. Raffaella Canobbio Microsoft Bruno Melandri EMC Andrea Saroli SAP. SQL Server 2012. MISSION CRITICAL CONFIDENCE. BREAKTHROUGH INSIGHT. CLOUD ON YOUR TERMS. Mission Critical statistics.
E N D
Delivering mission critical confidence Raffaella Canobbio Microsoft Bruno Melandri EMC Andrea SaroliSAP
SQL Server 2012 MISSION CRITICAL CONFIDENCE BREAKTHROUGH INSIGHT CLOUD ON YOUR TERMS
Mission Critical statistics Powering the #1 portal used by enterprises’ primary mission-critical application - IDC #1 database used by enterprises’ primary mission-critical application -IDC Uncontested Leader in TPC-E Benchmark Over 130,000 Transactions/Sec on a single server -Microsoft, SQL Server Customer Advocay Team 100% Uptime for two years -BWin Powering Nearly Halfof All New SAP Installations 1.6 PetaBytesin a single application - Pann-Stars
SQL Server 2012 gives you mission critical confidence Required 9s & data protection Blazing-fast performance Organizational compliance Peace of mind
Provides Required 9s of Availability Without Cost and Complexity Our business has to be online all the time….we were able to enable AlwaysOn in a matter of minutes. Mediterranean Shipping Company Greater Uptime Hardware Utilization Productivity 2x faster failover reduced downtime by half¹ New High Availability SolutionAlwaysOn ¹Source: Microsoft customer evidence: Mediterranean Shipping Company. 2x faster than Database Mirroring in SQL Server 2008 R2
Customers are already reaping the benefits The SQL Server 2012 online indexing capabilities alone save us up to 20 minutes a year in downtime, or 38.5 percent of allowable downtime. - David Smith, Director Service Architecture 50% Reduction in Failover Time 99.995% Availability 15% Improved DBA Productivity BENEFITS
10x Blazing-Fast PerformanceGain breakthrough & predictable performance backed by industry-leading benchmarks Now, up to Industry-Verified Increased & EnhancedPerformance Proactive Management Faster³ New Index ColumnStore
Customers are already reaping the benefitsBETH ISRAEL DEACONESS MEDICAL CENTER – Harvard medical school We began by copying our existing SQL Server 2008 R2 environment into SQL Server 2012, and simply by taking that step we saw faster performance. - Don Wood, Manager of Database Administration Beth Israel Deaconess Medical Center 88% Improvement in Performance 99.999% Availability IT Organization Ranked No 12 across All Industries in 2011 BENEFITS 1Source: Information Week 500
Security is key NIST Reported Common Vulnerabilities and Exposures Jan 2002 – Jun 2010 Most secure of any of the major database platforms. Source: ITIC 2011: SQL Server Delivers Industry-Leading Security Oracle DB2 MySQL SQL Server
Sql server 2012 provides Organizational Security & Compliance DATA PROTECTION CONTROL ACCESS COMPLIANCE
All with Peace of Mind World Class tools totest, deploy, migrate and upgrade Premier Support One Partner Committing Support For their Flagship Product Every 06 hours since November 2011 Recover Costs in 1 Year
In summary - Mission Critical Confidence with SQL Server 2012 Required 9s & data protection Blazing-fast performance Organizational compliance Peace of mind AlwaysOn for global HA with active, multiple secondaries, 2x faster failover & ease of use In-memory ColumnStore delivers astonishing Data Warehousing performance gains, 10x Windows Server Core edition support for increased security and greater uptime; more built-in auditing 70K+ Partners, Premier Support & System Center Advisor for proactive troubleshooting
enabling Mission Critical Systems with a great partner eco system
enabling Mission Critical Systems with a great partner eco system Bruno Melandri EMEA PracticeManager EMC
Why emc for microsoftmaximize the value of microsoft software investments Higher Quality of Service More Efficiency/ Lower Cost Faster to Time to Value
Benefiting from the flash era All of our data resides on EMC storage, which is the backbone of our mission critical Microsoft SQL Server environment. Using SymmetrixVMAXe with FAST VP enables us to leverage Flash drives to increase performance for faster response time to bidders. VFCache means we can extend the intelligence of FAST into the server—providing unparalleled responseto our bidders. - Brian Carpenter, Vice President of Information Technology, Heritage Auctions Up To 99.9999% availability SQL Server Performance Management Time Reduced by 50% Ability to triple workloads without impacting performance BENEFITS
EMC = Mission critical confidenceTransforming from static to dynamic infrastructure EMCAutomatedStorage Optimization EMCAutomated ServerOptimization SQL Server 2012 More Performance and More Users without Downtime SQL Server 2012 • 4X Throughput Increase With <3ms Latency • 60% Lower DB I/O Latency • 80% Faster Tuning • 50% More IO serviced W/In < 1ms • 3x more throughput per database SAP • 42% Performance Increase
EMC = Mission critical confidencetiered, automated protection Backup & Recovery Data Replication Accelerated Restart Snaps and Clones for recovery and multi-tasks Server failover/maintenance Self-service for DBAs Protect all application data tiers with one solution Recover applications to any point-in-time locally or remotely Simplified backup, recovery management for all Microsoft tiers De-duplicate backups to reduce cost and speed recovery Capability Policy-Based Replication Management Automated Continuous Availability De-Duplication Quality of Service
Why EMC for microsoft SQL server? 19+ Microsoft Gold and Silver Certified Competencies Recognized by Microsoft as a 21-Time partner of the Year Winner # 1 Storage Platform for Mission Critical Applications (IDC) #1 In Backup and Recovery
enabling Mission Critical Systems with a great partner eco system Amedeo Prodi SAP
SAP applications and sql serverdelivering mission critical confidence – today 20+ YEAR PARTNERSHIP 35,000+ SAP INSTALLATIONS ON SQL SERVER DATABASE SIZES APPROACHING 20 TB ? What Is Mission Critical
Case Study By using SQL Server database mirroring, we can increase resistance to system breakdowns. In addition, this makes it possible for us to carry out regular maintenance without stopping the entire system, which increases availability. - Haruhiko Kuroda, Deputy General Manager, Information Technology Promotion DIV. Supporting Over 6000 Named Users Global Deployment Across Many Offices Fully Operational within 60 minutes – Even During Power Reductions or Outages BENEFITS
High availability 99.999 % AVAILABILITY SQL SERVER ALWAYS ON ONLINE DATABASE MANAGEMENT
Performance CONTINUED OPTIMIZATION OF SQL SERVER FOR SAP SUPPORT FOR UP TO 256 PROCESSORS SQL SERVER COLUMN STORE
Scalability & security SQL SERVER AUDITING FRAMEWORK MOST EFFICIENT DATABASE COMPRESSION FEWEST SECURITY VULNERABILITIES
Partnering for customer success CO-LOCATED DEVELOPMENT RESOURCES TIGHTLY INTEGRATED FUNCTIONALITY ACCELERATED SOLUTIONS ALIGNED WITH CUSTOMER NEEDS PARTNERING BEYOND DBMS
Modernizing your enterprise with hybrid it Francesco Diaz Microsoft Gianluca Gamberoni HP
SQL Server 2012 MISSION CRITICAL CONFIDENCE BREAKTHROUGH INSIGHT CLOUD ON YOUR TERMS
Enterprise challenges driving hybrid it Drive greaterIT efficiency Reduce timeto solution Scaledynamically Balance performancewith cost Ensure compliance
Hybrid it | Definitions Hybrid IT Traditional NON-VIRTUALIZED Private CLOUDOn-premises Cloud Public CLOUDOff-premises Cloud Pooled (Virtualized) Elastic Self-service Usage-based Non-virtualized applications Managed Services Pooled (Virtualized) Elastic Self-service Usage-based Hybrid Application Portions of applications and data on-premises and off-premises
Hybrid it | scenarios and usage Hybrid IT Traditional NON-VIRTUALIZED Private CLOUD Public CLOUD Database Scenarios OLTP (Tier 2, Tier 3) BI Workloads Datamarts OLTP (Tier 2, Tier 3) BI Workloads Big Data Large, Mission-Critical OLTP Data Warehousing Big Data Rationale for Usage Rapid Development Compliance Compliance Economies of Scale Complex, Mission-Critical Applications Economics Scalability
Why MICROSOFT for your hybrid it? Hybrid IT Traditional NON-VIRTUALIZED Public CLOUD Private CLOUD Development Tools Identity Management Tools Common Resources
Why sql server 2012 for your hybrid it? Scale on demand Fast time to market Optimized productivity Extend any data, anywhere Cloud on Your Terms • Pre-Tuned Appliances • Reference Architectures • Fast database provisioning with System Center 2012 • Unstructured, Structured, Complex • Interoperability • Hadoop Connectors • Windows Azure Marketplace • Common Architecture • Support 640 cores • Dynamic Memory • License Mobility • SQL Server Data Tools • Management Studio • Snapshot backups to Azure • Manage Hybrid IT with System Center 2012
Application solutions Traditional NON-VIRTUALIZED Platform SQL Server 2012 • Key Benefits • Required 9’s & data protection • Blazing fast performance • Organizational compliance • Peace of mind Infrastructure “Reduced failover time from 40 seconds to under 3 seconds with SQL Server 2012” Joe Ayres, Senior Manager of Database Administration, Home Shopping Network
Application solutions Private CLOUD Platform SQL Server 2012 Database Consolidation Appliance • Key Benefits • Deep application insight • Single pane of glass to manage • SQL Server 2012 optimizations for Private Cloud • Deploy in days instead of months Infrastructure + No difference in performance with SQL Server running on high-performance physical hardware versus SQL Server running on a Hyper-V host.
Application solutions Public CLOUD Platform as a Service SQL Azure SQL Server 2012 • Key Benefits • Rapid application development • Dynamic scalability • Managed services Infrastructure as a Service “With SQL Azure, we can deploy internationally without having to migrate customer data from one region to another, without having to replicate databases, and without all of the service management we would otherwise have to engage in.” Jim Graham, Technical Manager, 3M • Built-in cloud connection points to SQL Azure
Case study • “With SQL Server 2012 Enterprise, we can sustain 1,500 game rounds per second. That gives our players a much faster, better gaming experience.” The Need Online gaming firm seeks to maintain high availability for its mission-critical gaming applications to achieve business success Traditional NON-VIRTUALIZED Solution: Hybrid Application Mission-critical gaming services with sensitive data kept on-premises for industry compliance Public CLOUD Non-gaming services moved to the public cloud for efficiency
HP and Microsoft Strategic Partnership Igniting the contribution of IT to the business • World-leading software and hardware companies • 3-year, $250M joint investment • Portfolio of solutions delivers rapid time to value • Integrated HP and Microsoft Services • Bridge the path to the cloud
Appliances for Hybrid IT from HP Hybrid IT Traditional NON-VIRTUALIZED Private CLOUD Public CLOUD Parallel Data Warehouse Massive scale and high performance Complete data warehouse solution Half-rack appliances now available Database Consolidation Appliance Deploy in days instead of months Optimized for databases All private cloud benefits • Business Data Warehouse Appliance • Entry level data warehouse • Business Decision Appliance • Complete self-service BI Reference Architecture: Virtual System General purpose private cloud RA Tested by HP & Microsoft All private cloud benefits
Summary Microsoft & HP Offers unique benefits across Hybrid IT environments Hybrid IT Achieves balance between IT efficiency and driving business value for your organization SQL Server 2012 Provides the database platform for Hybrid IT
CLOSING SESSION Luca Venturelli Direttore Server & Cloud Microsoft
A Major Step With SQL Server 2012 MISSION CRITICAL CONFIDENCE BREAKTHROUGH INSIGHT CLOUD ON YOUR TERMS
Offers for you Dedicated workshop tofind out more on EMC valuepropositionforMissionCritical Application in the Cloud, customized on yourspecificneeds. BOOK IT NOW! z Half-day check-up at your office about Tagetik 4 Enabled by Microsoft SharePoint to give your CFO the ability to simplify the analysis of the performance data in a collaborative way.