SQL Server 2005 end of support is on April 12, 2016. Many of our customers agree that it’s time to think about migrating/upgrading to something better and faster soon. If you are still using SQL Server 2005, here are some points to consider.
SQL Server 2014 New Features This is a major upgrade packed with new features of SQL Server 2014 include In-Memory online transaction processing (OLTP), updateable Columnstore indexes, and AlwaysOn availability groups.
Cisco Unified Computing System (UCS) So why should you consider Cisco UCS to take advantage of these SQL Server 2014 features? Let’s start with performance.
Cisco UCS C460 M4 running Microsoft SQL Server 2014 outperformed:
- Fujitsu SPARC M10-4S by 80 percent
- Dell PowerEdge R820 by 31 percent
- IBM x3859 by 13 percent
Why are we so good?
- Optimize OLTP workloads
The new OLTP engine helps facilitate high performance, low latency data access. Cisco UCS has high memory capacities that support you to take advantage of the SQL Servers’ In-Memory OLTP engine. Progress Insurance used Cisco UCS and In-Memory OLTP and saw a 4x performance gain. They saw a 320% increase in processing rate, from 5,000 transactions/second to 21,000 transactions.
- Optimize BI and Data Warehousing workloads
Columnstore index provides significant performance improvement for Data Warehouse queries. You no longer need to drop and recreate the index when making changes. We have seen 10x better performance results. Such workloads are increasing tenfold every 5 years. With high memory support, Cisco UCS Blade Servers provide up to 3TB of RAM and the Cisco UCS Rack Servers up to 6TB of RAM. You can trust us to give you the best experience.
- Maximizing Availability
Cisco UCS’s service profiles and the stateless architecture allow SQL Server workloads to be introduced back into production in 5-7 minutes regardless if it’s virtualized or bare metal. Children’s Hospital in Colorado leveraged the service profiles and provisioned 15 servers in 1 day. Without them, it usually takes up to weeks to configure the new servers.
SQL Server’s AlwaysOn AGs provide protection against unplanned downtime. During a failure, Cisco Unified Fabric ensures the connection between the primary and the secondary replicas has the best performance of bandwidth.
Read More »
Tags: #SQLServer, Cisco, CiscoUCS, Microsoft, SQL
The New Year has arrived, and with it, SAP has added new solutions to their portfolio. The latest announcement is SAP’s Business Suite on HANA (S4HANA).
Over the past several years, SAP’s overall movement to create an in-memory platform has been strengthened by industry-leading and mission-critical solutions such as Tailored Datacenter Integration (TDI), integrated infrastructure, big data, and Internet of Things. How much do you know about these solutions? Would you like to learn more?
Cisco has developed a series of educational webinars to provide a deep dive into each of these solution areas.
These webinars have been created to educate and provide you the opportunity to ask the hard questions about how these SAP and SAP HANA solutions will fit into your organization.
Register for the individual webinars to learn how you can maximize your company’s competitive edge.
We look forward to seeing you there!
Tags: CiscoUCS, SAP, SAP. HANA
The Internet of Everything (IoE) is disrupting innovation models and causing market shifts. One of the most powerful IoE-driven opportunities will be the value created from big data and analytics. As IoE gains momentum and creates billions of new connections, each of those connections will be capable of producing data. The enterprises that can unlock the intelligence within that data — quickly and effectively — will hold the key to a powerful and sustainable competitive edge. Read More »
Tags: #IoE, Big Data, big data analytics, CiscoUCS, Enterprise, InternetofEverything, UnlockBigData
After the SQL Saturday event this week I will be staying in Barcelona for a few more days to attend the Microsoft TechEd Europe from Tuesday Oct 28th to Friday Oct 31st! As Gary Serda laid out in his blog, Cisco has a lot of great demos to share with you. See details: http://blogs.cisco.com/datacenter/cisco-at-microsoft-teched-europe-2014/
- Cisco UCS and Integrated Infrastructures for Microsoft Private Cloud
- Windows Server 2003 Migration to Windows Server 2012 R2 and Cisco UCS
- UCS Management with Microsoft System Center
- UCS for Microsoft SQL Server
- Nexus 1000V Network Virtualization with Microsoft Hyper-V
As I mentioned in an earlier blog, “Cisco is Here to Help!—Microsoft Windows Server 2003 End-of-Life Support,” Windows Server 2003 (WS2003) Migration to Windows Server 2012 R2 on Cisco UCS is, as we like to say the social media world, trending. I am really excited about the demo covering this topic because it brings together all the value props of Microsoft and Cisco working together to help customers solve one of their most important data center challenges.
In that blog, I touched on what Cisco and Microsoft are saying, but what are our customers saying?
Head of ICT management and maintenance, Elektroprivreda, Haris Brkanic mentioned in the case study that moving to Windows Server 2012, they were able to migrate from 42 physical servers and 90 virtual servers on seven hosts to just 12 Cisco UCS servers. They are realized significant cost saving and performance gains in this upgrade. They also love that they can manage everything from a single pane of glass. Our customer definitely experienced the simplified IT, better virtualization, and licensing and support benefits they were hoping to get.
Read More »
Tags: #TEE14, Cisco, CiscoUCS, HyperV, Microsoft, Microsoft TechEd, Microsoft Windows Server 2012, TechEd, ucs integrated infrastructure
Of the more than 300 SQLSaturdays around the world, I am lucky enough to represent Cisco at the one in Barcelona on October 25th. If you’re attending TechEd Europe we encourage you to also join us at this one-day free event for IT professionals to learn more about SQL Server and the Cisco Unified Computing System (UCS).
If my experience at a recent SQL event in San Diego is any indication, it is going to be a great event. I was amazed that even after UCS being recognized as the #1 x86 blade server in Americas, many database administrators still came to our table and asked, “What is Cisco doing here at a SQL Saturday event?” The good news is that these same people left with an understanding of how UCS is different from our competitors and can help simplify, standardize and optimize SQL Server deployments.
In San Diego, 80 people showed up to Cisco consulting systems engineer, Aaron Rigney’s presentation, “Optimize Your SQL Server 2014 Workloads with Cisco UCS” which covered the following key benefits.
- Quickly and easily deploy new SQL Servers in minutes
- Proactively manage and automate your SQL Server workloads with Microsoft System Center 2012 R2 and PowerShell integrations with UCS Manager
- Achieve the highest levels of consolidation and performance for both virtual and bare metal implementations.
Read More »
Tags: @ciscoDC, Cisco, CiscoUCS, Integrated infrastructure, Microsoft SQL Server, Microsoft SQL Server2014, SQL, SQL Server, ucs integrated infrastructure