1 / 35

Workload Optimization Software

Partner Briefing. Workload Optimization Software. Leverage the Full Parallel Power of Multi-core Machines. 40% of businesses will not exist in a meaningful way in 10 years…. - John Chambers Outgoing CEO, Cisco. Automating while delivering services. Digital world of today.

clark
Download Presentation

Workload Optimization Software

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. Partner Briefing Workload Optimization Software Leverage the Full Parallel Power of Multi-core Machines

  2. 40% of businesses will not exist in a meaningful way in10 years… - John Chambers Outgoing CEO, Cisco

  3. Automatingwhiledeliveringservices

  4. Digital world of today

  5. SANSymphony/HVSAN are designed to Maximize Storage I/O Performance & Minimize Latency MaxParrallel // is designed to Maximize Application Performance & Workload Productivity

  6. Parallel Server Architecture DesignedtoMaximizeApplication Performance & Workload Optimisation Application Layer OS Layer I/O Request I/O Submit Storage Layer I Can answer immediate / I knowwhereto find By-passing the OS Improves scheduling efficency by avoiding uneccessaryContextSwitching!

  7. Shorten time to process transactions, generate reports and analyze trends • Simple plug-and-play software add-on • No programming or hardware changes • Experience benefits overnight • Flexible licensing on-premises & on Azure Marketplace

  8. Problem | Choke point causes major slow-downs • Only one task can read and write data at a time • Other tasks must wait their turn • Little work gets done • CPUs wasted • Adding more load on idle cores exacerbates delays 4 concurrent tasks on 8-core server A B D C

  9. Workaround | Spread load over many servers H-M T-Z A-G N-S Server1 Server2 Server3 Server4 Server5 compounds cost & complexity

  10. Materially faster data access & full use of cores Delays & waste causedby serial scheduling “It’s Quicker in Parallel” with DataCore Concurrenttasks

  11. Caution | Don’t expect much improvement if … Parallelism doesn’t help linear / sequential workloads or test environments characterized by: • One user at a time • One process at a time (e.g., serial batch jobs) • Resource-starved configurations • Computationally-intensive activities with very little I/O

  12. Best fit Sluggish behavior at peak times • Many simultaneous users • Many concurrent processes (analysis / reporting i.e. OLTP) • SQL optimizations yield only marginal +++ • Hardware changes are unacceptable • Unwilling or unable to modify code • Painful & expensive to distribute workloads across multiple SQL instances

  13. DataCore™ Workload Optimization • Improve responsiveness of workloads bogged down by I/O bottlenecks in O.S. • Reduce infrastructure cost through more productive use of server cores & memory • No changes to: • Apps • Hardware • Data

  14. Strategic Expansion • From narrow SQL Server database optimization • To broader Windows and Linux workload optimization • Amplifies Total Addressable Market (TAM) Better leverages DataCore’s parallel I/O DNA from our legacy product set

  15. Workloads benefitting the most include … • Hyper-V VMs • Kubernetes containers (DevOps) • Azure VMs • VDI • File servers • Mail • Analytics

  16. Product Enhancements • New Dashboard • Telemetry (to Azure IoT Hub) • Analytics engine (detect best fit) • Licensing for general O.S.

  17. Video • https://www.youtube.com/watch?v=18q2nlXFbw0

  18. Customers report Quicker Response HigherEfficiency More Throughput * Varies with workload concurrency and data access patterns

  19. Success Cases

  20. MS SQL 2012 MS SQL 2016 After MaxParallel Before

  21. Range of results % Improvement <10% 20% 50% >80%

  22. Testing Criteria • HammerDB • Timed Test • 2 Minutes Ramp Up Time • 5 Minutes Test Duration • 10 Minutes per test in User Sequence • User Sequence: 1, 2, 4, 8, 12, 16, 20, 24 users • Target TPM per user: 1,000,000 • VMWare vSphere Virtual Machine • SQL Server 2008 R2 Standard Edition • Windows Server 2016 Standard Edition • CPU: Intel Xeon E5-2680 v2 (2.80GHz) • RAM: 16 GB

  23. Real-world results: UK Solution Provider “We saw a VM with 8 cores, with MaxParallel installed, perform on average 127% more transactions per minute than the same VM with 20 cores.” • SQL Server 2008 R2 • Can achieve more transactions per minute on VMs with 12 fewer cores • Cost savings on CPU cores & SQL Server licensing

  24. Real World Results – Pivotal CRM • Disk Latency averaging between 1000ms and 1500ms • Pivotal CRM Application was slow (searches could take up to 3 minutes) • Pivotal CRM Application kept crashing • Month End processing took over 5 hours Before enabling MaxParallel:

  25. Real World Results – Pivotal CRM • Disk Latency averaging between 10ms and 15ms • Pivotal CRM Application was faster (searches now taking less than a minute) • Pivotal CRM Application no longer crashing as often • Month End overnight processing now takes less than 2 hours

  26. Rapidly quantify value • Choose an especially challenging scenario • Run a baseline test (before) • Repeat after installing DataCore software (after) • Quantify the differences based on metrics meaningful to you • Improved application response time • Number of users with reasonable response • Time to complete analysis / report • Amount of data / sensors processed in a given time window • Translate to business value • More clients, greater insights, pre-empt problems, faster development & time to market, … DOWNLOAD TRIAL

  27. DataCore™ Workload Optimization • Improve responsiveness of workloads bogged down by I/O bottlenecks in O.S. • Reduce infrastructure cost through more productive use of server cores & memory • No changes to: • Apps • Hardware • Data

  28. Questions? www.datacore.com

  29. Just like Jimi Hendrix …  We love to get feedback Please complete the session feedback forms

  30. SQLBits - It's all about the community... Please visit Community Corner, we are trying this year to get more people to learn about the SQL Community, equally if you would be happy to visit the community corner we’d really appreciate it.

More Related