1 / 7

Why EMC for SQL

Why EMC for SQL . Performance Optimization. Realities in the Life of a SQL Server DBA. It’s a balancing act of expertise, cost and limited resources. INCREASING USER & BUSINESS REQUIREMENTS. Scalability, Availability, Performance Protection and Recovery.

tab
Download Presentation

Why EMC for SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Why EMC for SQL Performance Optimization

  2. Realities in the Life of a SQL Server DBA It’s a balancing act of expertise, cost and limited resources INCREASING USER & BUSINESS REQUIREMENTS • Scalability, Availability, Performance • Protection and Recovery • Escalating Data Growth And Costs (Workload/Users/Landscape) • Replication and Data Repurposing • Ever-Shrinking Backup Windows • Limited Resources, Expertise, Time MANAGEMENT COMPLEXITY • Business Intelligence and Analytics • Faster Time to Value INNOVATION

  3. Why EMC for SQL Server 2012Mission Critical and Cloud Infrastructure Leader MISSION CRITICAL CONFIDENCE BREAKTHROUGH INSIGHT CLOUD ON YOUR TERMS 19+ Gold and Silver Microsoft Consulting Competencies Virtualization Readiness SQL Server Migrations VMware or Hyper-V Support Optimized SQL Server Data Warehouses with EMC From Insight-To-Action With Microsoft BI Tools and EMC Platforms and Consulting 3-4X More Performance > 5 9’s Reliability & Availability 80% Faster Provisioning Up to 10x Faster Backups 10-30x Less Backup Storage Replicate/Recover In Minutes

  4. EMC Ensuring Mission Critical Confidence Keeping Your Users Happy And Your Business Competitive Challenge • Performance tuning is complex and manually intensive • Infrastructure investment v. scalability/growth requirements EMC Benefit • Auto-tiering eliminates manual tuning and prioritizes Microsoft workloads to right storage tiers at the right time • 80% faster SQL Server 2012 infrastructure deployments with EMC VNX Unified Storage • Seamless scalability of SQL Server 2012 with EMC Symmetrix VMAX & VMAXe • 3-4X more performance and 80% faster provisioning of SQL Server 2012 storage at less cost with FAST VP, FAST Cache and vFCache MISSION CRITICAL CONFIDENCE SCALABLEPERFORMANCE

  5. The FAST Suite FAST Cache continuously ensures that the hottest data is served from high performance Flash SSDs FAST VP (Virtual Pools)* optimizes storage pools automatically, ensuring that active data is being served from SSDs, while cold data is moved to lower cost disk tiers Together they deliver a fully automated FLASH 1st storage strategy for optimal performance at the lowest cost attainable Unispheremonitors and tunes the FAST policies from a single interface A FLASH 1st strategy enabler Real-time caching with FAST Cache 15KHDD FlashSSD Flash Scheduled optimization with FAST VP * Not available for VNX5100. High-capacity HDD

  6. FAST VP for Symmetrix VMAXe Virtual Server Virtual Server Virtual Server Increasing Microsoft SQL Server Performance And Efficiency • FAST VP and Microsoft SQL Server • Up To 40% Higher Performance • 40% Lower Cost Of Storage • Present More Capacity In Less Time While SQL Server Applications Remain Online • Less Tuning And Management Required By SQL Server DBAs SQL Server SQL Server SharePoint FC

  7. EMC XtremSW Cache Improves Server Performance • Server Flash caching solution that uses intelligent caching software and hardware technology to reduce latency and increase throughput • “Hottest” data accessedthrough XtremSW Cache in the server providing increased performance • XtremSW Cache benefits SQL Server 2012: • Lower database I/O latency by 60% • 50% more I/O serviced within 1 ms • 4X more transactions per SQL Server database • Perfect fit for OLTP workloads Read Latency (Sec) Transactions Per Minute (TPM)

More Related