Белая книга для Cisco Cisco UCS B260 M4 Blade Server
© 2011 Cisco and/or its affiliates. All rights reserved. This document is Cisco Public Information.
Page 3 of 36
Executive Summary
The purpose of this document is to provide a study of Microsoft SQL Server consolidation on Cisco Unified
Compute System (UCS). The primary objective of the study is to articulate the total cost of ownership (TCO) and
return on investment (ROI) that can be achieved by companies wishing to consolidate SQL Server on Cisco UCS.
Additionally, the study will also prove that consolidated SQL Server implementations on Cisco UCS can meet the
scalability, availability and performance requirements mandated by today’s high-volume database implementations.
scalability, availability and performance requirements mandated by today’s high-volume database implementations.
This white paper also provides a framework for choosing among virtualization, multi-database, and multi-instance
consolidation strategies for SQL Server Database Engine supporting OLTP applications by highlighting some of the
key decision points based on technical analysis.
This white paper shows the reference Architecture for considering consolidation and virtualization strategy for
deploying Microsoft® SQL Server® software on the Cisco Unified Computing System (UCS).
This experiment will prove that Cisco UCS can help companies realize a reduction in total cost of ownership (TCO)
and achieve the level of infrastructure agility
required to meet the challenges of today’s fast paced and ever
changing business requirements.
Introduction
In today’s economic climate, enterprises are taking a closer look within their IT organizations to identify potential
areas in which cost-saving strategies can be implemented to help reduce operating expenses. One of the
challenges that IT organizations face today is how to develop an infrastructure that allows flexibility, redundancy,
high-availability, ease of management, security, and access control while at the same time reducing costs,
hardware footprints and complexity.
The growth in IT industry has realized tremendous growth in hardware computing capacity, database applications
and physical server sprawl has resulted in costly and complex computing environments containing many over-
provisioned and under-utilized database servers. Many of these servers implement a single instance of SQL
Server realizing ten to fifteen percent CPU utilization on average which is not an optimal use of server resources.
Additionally, due to the complexities introduced by all of this growth, many database administrators today are
overburdened with redundant management and administrative tasks that must be implemented on each of the
many servers they are responsible for. Also, during a catastrophic, physical database server failure, there is a
significant impact on the sever administrator as they typically are the resources that are required to provision
another physical server into the environment and prepare it for the application.
Database server consolidation is an area where companies can realize considerable cost savings with regards to
total cost of ownership (TCO). Database server consolidation can also help companies to achieve the
infrastructure agility they are seeking to stay competitive and provide the fastest time to market for their solutions.
Consolidation, in general terms, is the combining of various units into more efficient and stable larger units. When
applied to an IT department, consolidation specifically translates into improved cost efficiency from higher
utilization of resources, standardization and improved manageability of the IT environment, and recent focus on a
―green‖ IT environment through reduced energy consumption. One of the important components in the IT
―green‖ IT environment through reduced energy consumption. One of the important components in the IT
environment is the database. Databases managements systems form the foundation of many business systems.
Often each group or application create their own database to solve a specific problem, thus IT departments lose
control of the number of databases and servers that need to be maintained. This leads to a proliferation of
databases and machines running database instances also known as database sprawl. This makes the databases
the prime candidates for consolidation.