This week Microsoft launched SQL Server 2014, their data management and business intelligence platform. SQL Server at Microsoft has grown tremendously over the years; it is far from its origins as a simple relational database that Microsoft licensed from Sybase years ago. For the 2014 version of SQL Server, Microsoft has focused on continuing their drive to deliver mission critical performance, use that performance to provide for heterogeneous data access and insight, and finally delivering a data platform for customer’s private and hybrid cloud solutions. At Cisco we believe that our Unified Data Center architecture provides an optimum compute, network, and management offering for your Microsoft SQL Server solutions:
Compute – Cisco’s Unified Computing System (UCS)
Our Cisco Unified Computing System (UCS) server family is an intelligent fabric-based computing infrastructure that simplifies operations and speeds application deployment in physical and cloud computing environments. UCS combines industry-standard x86 architecture blade and rack servers, networking, and enterprise-class management into a single cohesive system. UCS’s configuration is entirely programmable using unified, model-based management to simplify and accelerate deployment of Microsoft workloads, bare-metal or virtual, such as SQL Server 2014. Its unified I/O infrastructure uses a high-bandwidth, low-latency unified fabric to support networking, storage I/O, and management traffic. UCS unified fabric increases performance, security, and manageability by extending fabric directly to servers and virtual machines. UCS servers are 100% stateless, delivering a highly flexible server environment that allows for dynamic utilization of server hardware
Business intelligence begets better, more informed decision making—and, ultimately, success. But how do you get effective business intelligence? It starts with your tools and infrastructure…
With the proliferation of database and virtualization sprawl and the growing requirement for business insight that has increased I/O performance demand and complexity in the datacenter, enterprises are asking for a simplified approach. Cisco UCS offers industry-leading performance along with the flexible infrastructure you need to deploy, manage, move to the cloud and scale your bare metal or virtual SQL Server workloads
On March 18, join Industry thought leaders from Cisco, Microsoft, NetApp, EMC, and DesignMind to explore how Microsoft SQL Server and integrated infrastructures such as FlexPod and VSPEX enable you to more effectively turn data into a valuable strategic asset for business decision makers.
Make plans today to join us and learn how these infrastructures can help you:
Make sure optimal access to mission-critical data is available
Enable greater business agility
Increase cost-efficiency and lower TCO for business intelligence initiatives
Yesterday, Nov 6, Cisco unveiled details of the Application Centric Infrastructure with an ecosystem of partners that share our common view -- IT is in need of a transformation to create the Application Economy. Some key technology leaders spoke about the application lifecycle impact of an open and centralized policy model for complete infrastructure automation, including configuration, operation, monitoring, and optimization. I’d like to recap a few of those comments here today.
During the ACI announcement, Brad Anderson, Corporate Vice President in Microsoft’s Windows Server and System Center Group (WSSC), said that
virtualization has unshackled applications from the hardware in the past. But now with ACI we can do much more.So first of all, we can have the applications be able to describe their needs for more rapid provisioning. So with the view we can get across physical and virtual, we can see what is happening with the application, we can optimize the infrastructure for the application, and do more rapid troubleshooting.
…the integration with Microsoft cloud OS and UCS is really remarkable. Literally you have a common way to automate everything from the application, down to the operating system, down to all of the hardware level components. But ACI gives us the ability to do some really remarkable things..
Imagine how Exchange, Sharepoint and Linc -- being able to be shipped with ACI policies that now describe out how exactly the network should be configured, how it should be optimized, and automatically be provisioned across physical and virtual in a holistic way. That’s the kind of value we are going to be able to deliver together.
“…These new solutions are designed to improve business agility and reduce cost by driving infrastructure automation in support of core business processes and applications. This next-generation infrastructure will deliver increased application performance, resource pooling, visibility, automation and mobility through:
· Converged ACI stacks that include fully integrated versions of Windows Server 2012 R2 Hyper-V, System Center 2012 R2, SQL Server, Exchange and SharePoint”
I introduced the IT challenge posed by apps that behave differently in my earlier ACI post so now I want to point out that the new converged ACI stacks will fully integrate the operating system, orchestration, applications, server and network infrastructure to provide an enterprise customer with the application agility to rapidly deploy Exchange, SQL Server, and SharePoint, scale and upgrade them, and also to decommission them.
Many next generation distributed cloud applications are being written on open source platforms. For a view on what ACI means to a leading open source cloud platform, OpenStack, let me quote what Jim Whitehurst, President and CEO of Red Hat, said at the launch:
…there’s a whole set of functionality that is required to run a portfolio of true production applications and be able to run a diverse set of applications and to make sure that you can actually guarantee the performance levels that you need. The great thing about ACI is it provides that really differentiated functionality that enterprises need, even on open platforms, but at the same time, it does it with open standards, open APIs, and an open ecosystem so that customers get the benefit without being locked in and maintain the flexibility they are looking for going forward.
For more on Openstack and ACI, see this video – Application Policy and OpenStack – which explains how the DevOps community can extend agile processes to network infrastructure.
Guest post by Dennis Clark, Senior Solutions Marketing Manager -- Microsoft Applications, NetApp
We are here in Charlotte this week with our Cisco friends, with the opportunity to talk with all sorts of like-minded Microsoft SQL Server individuals at the 2013 SQL PASS Summit. The conversations vary in range from things like database performance, developer issues, to private cloud and data management concerns. We’ve also had some good chats with a few data warehouse folks, which prompted me to share some thoughts on this topic.
We know that the data warehouse (DW) is central to a comprehensive business intelligence (BI) solution. So clearly, if our DW isn’t up to snuff, as they say, then we can forget about delivering critical analytics to a growing number of LOB managers and execs. This, in turn, negatively affects the bottom line of the business, which isn’t good for anyone. And it isn’t getting any easier. Data is growing exponentially and the problem of integrating data from multiple sources isn’t going away any time soon. These issues, along with the complex interaction of the different components of a BI solution, continue to make the design, deployment and management of data warehouses a challenge. Now you can continue to throw money at it by over-provisioning and burning up valuable data center space and power to try to keep up, or you can strive to achieve a higher level of DW nirvana with Cisco and NetApp.
Guest post by Txomin Barturen, Senior Consultant – CTO Office, EMC Corporation
SQL Server provides customers with a vast array of technology options to address a diverse range of data and reporting requirements including extremely high throughput OLTP environments to bandwidth and time-sensitive reporting and DSS systems. With choice comes the inevitable complexity of defining and building solutions. Customer IT teams are invariably dealing with Service Level Agreements (SLAs) from their in internal customers. Time and financial constraints often limit the ability of internal IT teams to spend significant amounts of time in defining, testing and implementing the broad range of environments that they need to deploy.
Jointly, Cisco and EMC have partnered with Microsoft to deliver a set of solutions that are pre-validated to deliver the requirements for customer SQL Server environments. These solutions implement the collective best practices for server, network and storage, ensuring that customers implement a known valid configuration without the guesswork.
Fast Track Data Warehouse
Dealing with data warehouse requirements requires that solutions be designed to meet the ideal balance between performance, DW size, and cost. Design guidance from the SQL Server team dictates that the total data warehouse size be finely balanced by storage system configuration, server system consumption rate (how fast the CPUs are able to process the data) as well as the interconnectivity between server and storage to deliver at the required rate. To match server configuration, the interconnectivity (including HBAs) and the storage infrastructure requires much design, calculation and testing across a number of disciplines.