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
In the Internet of Everything Era (IoE), analytics will occur throughout the network—from the edge, to the core, in the cloud, and everywhere in between. Cisco is uniquely positioned to deliver intelligent networking infrastructure that acts as a flexible data plumbing footprint and control plane, giving our customers the flexibility to send analytics to the data source for IoT use cases that require real-time insights—as well as data to the analytics for use cases that require historical data.
The most powerful analytics solutions apply the combined power of an innovative infrastructure and analytics software solutions that are uniquely designed to optimize one another. Cisco’s analytics-ready infrastructure has been proven to provide a high-performance, flexible, and efficient foundation for leading data management, data integration, and analytics software.
- Cisco UCS Integrated Infrastructure for Big Data is an industry-leading platform widely adopted in the industry that helps organizations deploy and scale Big Data applications faster to drive the revenue side of the business while significantly reducing risk and TCO.
- Cisco UCS Integrated Infrastructure for Big Data is the first and only platform to post certified results for the new TPC Express Benchmark HS (TPCx-HS), which was developed to provide enterprises with a vendor-neutral way to evaluate the performance and price-to-performance of big data implementations. Cisco UCS Integrated Infrastructure for Big Data demonstrated outstanding performance and scalability at 1TB, 3TB, and 10TB scale factors.
- Cisco UCS Mini, ideal for processing analytics at the edge and branch offices, has earned industry recognition for innovation in furthering the development of the data center industry with the InfoTECH Spotlight Data Center Excellence Award for 2014.
- And, Cisco Application Centric Infrastructure (ACI) and the Nexus 9000 also took home an InfoTECH excellence award adding additional proof of the strength of Cisco’s analytics-ready infrastructure. As analytics workloads increase in number, the network plays a critical role in ensuring that workloads are completed and insights are delivered on time, securely, and cost-effectively. Cisco ACI lets customers dynamically optimize cluster performance in the network, redeploy resources automatically for new workloads to improve utilization and lower TCO, and ensure isolation of users and data as resource deployments change.
Read More »
Tags: ACI, analytics, Big Data, UCS
Many years ago I found myself talking to a venture capitalist about the differences between SaaS, outsourcing, ASPs, MSPs, online applications; etc. Also I noticed that my Stanford students had little understanding of the economics of software, so I developed the idea of seven business models to cover everything in the software business, remove the buzzwords and replace them with economic models.
In my previous post, I talked about the Seven Ways to Move to the Cloud. In the second issue (there’s a lot here), I’ll break this into two separate posts, discussing models one through four here, and models five through seven in the next issue publishing on Monday, March 2.
Note the dollar numbers used throughout are intended to be relatively representative.
Read More »
Tags: business models, CIO, Cloud Computing, on-premise, open source, outsourcing, SaaS
Solving Congestion Problems in Storage Area Networks
This phenomenal growth puts tremendous pressure on Storage Area Networks (SANs), which must be able to handle the burgeoning traffic loads between the compute and storage layers. To maintain peak efficiency, storage administrators need to be able to quickly detect and resolve slow drain and other common SAN congestion problems. If not addressed in a timely fashion, these can have a cascading effect, even degrading the performance of totally unrelated applications.
Learn how to build your own self-healing fabric. >> REGISTER NOW : Webinar on Feb 25th 8:00 PST.
This live 60-minute webcast reveals the common causes of slow drain and other typical SAN congestion issues in Fibre Channel (FC) and Fibre Channel over Ethernet (FCoE) deployments. You will learn how to efficiently detect, stop, and even prevent them from happening.
WATCH VIDEO: Slow Drain is the highest point of concern for storage administrators. Still, it is one of the least understood problems. Watch the videos to understand the basic concept and features provided by Cisco MDS switches for detection, troubleshooting and automatic recovery. Deploy these features today to have your own self-healing fabric
Subscribe to youtube channel for more videos: https://www.youtube.com/user/ciscomds9000
Read More »
Tags: congestion control, MDS 9000 Congestion recovery
Cisco has developed a plug-in to integrate the ASR 1000 Series Router
(ASR1K) into OpenStack to offload L3 capabilities on to dedicated routing hardware. The plug-in was demonstrated at Cisco Live in a Proof-of-Concept environment. We are planning demos of a Cloud solution based on the ASR1k plug-in at the OpenStack Summit in Vancouver. The plug-in is considered open source and will be submitted upstreamed into OpenStack. It will also be available from Cisco’s Neutron Tech-Preview repository
OpenStack offers a reference software implementation for Layer 3 functionality. Routing, static NAT (Floating IPs) and dynamic NAT/SNAT (VM “Internet” access) are handled by the l3agent that runs part of the neutron component. The L3 agent relies on Linux IP Tables to define forwarding rules. With that comes a critical scalability issue as Linux IPTables has inherent scaling shortcomings. For highly-scalable clouds with many route and NAT operations, this becomes a serious bottleneck.
Cisco offers the ASR1K routing platform to be used in Data Centers typically for WAN edge operations. It performs NAT and L3 forwarding in hardware and provides L3 high-availability (HSRP). The ASR Config Agent builds upon the same technology utilized for the integration of the Cisco Cloud Services Router (CSR1000v
) into OpenStack.
Read More »
Tags: ASR1K, OpenStack