Hp COMPAQ PROLIANT 8500 Scaling Out for Performance with Compaq ProLiant Servers and Microsoft SQL Server 2000
February 2001
Compaq Computer
Corporation
ISSG Technology
Communications
ONTENTS
C
Introduction........................3
The Compaq and Microsoft
Partnership......................... 3
Scaling Out Versus
Scaling Up ..........................3
Benchmarking Scale-Out
Architecture........................4
The DISA Architecture......... 5
Components of Scale-Out
Architecture........................6
Compaq ProLiant 8500
Servers................................6
Microsoft SQL Server 2000....7
ServerNet II.......................... 7
Scale-Out Database Design . 8
The Partition Column ............8
Data Locality........................9
Data Dependent Routing ....... 9
Control Over Query Text .....10
Further Design Constraints .. 10
Conclusion........................ 10
TC010201TB
T
ECHNOLOGY
.
.
.
.
.
Scaling Out for Performance
.
.
.
.
.
.
.
with Compaq ProLiant Servers
.
.
.
.
.
.
.
and Microsoft SQL Server 2000
.
.
.
.
.
.
.
.
.
.
Reliable and fast database access is the cornerstone for modern business applications that
.
.
.
.
manage information in e-commerce systems. As the use of the Internet and e-commerce
.
.
.
increases, organizations must implement systems that can be cost-effectively expanded to
.
.
.
meet rapid growth. Increasingly, traditional database solutions cannot meet the demand
.
.
.
for enormous increases in performance and the availability requirements of 24-hour e-
.
.
.
.
commerce environments.
.
.
.
.
Recent performance benchmarking results attained by Compaq using a multinode
.
.
.
.
configuration of Compaq ProLiant 8500 servers running Microsoft SQL Server 2000
.
.
.
confirm Compaq as a leading provider of cost-effective scale-out solutions for high-
.
.
.
performance database systems operating on industry-standard servers.
.
.
.
.
.
This technology brief describes high-performance database systems Compaq developed
.
.
.
to meet the scalability and availability requirements of today’s demanding environments.
.
.
.
.
It provides both technical and benchmarking data illustrating the technologies and
.
.
.
performance gains for high performance scale-out database servers. It also discusses the
.
.
.
applicability of scale-out database solutions to particular computing environments.
.
.
.
.
.
This brief is written with the assumption that the reader understands the basics of
.
.
.
database design.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Please direct comments regarding this communication to the ISSG Technology Communications Group
1
at TechCom@compaq.com
.
B
RIEF
TC010201TB
Scaling Out for Performance with Compaq
ECHNOLOGY BRIEF
T
.
.
.
OTICE
N
.
.
.
.
.
The information in this publication is subject to change without notice and is provided “AS IS”
.
.
.
WITHOUT WARRANTY OF ANY KIND. THE ENTIRE RISK ARISING OUT OF T HE USE
.
.
.
OF THIS INFORMATION REMAINS WITH RECIPIENT. IN NO EVENT SHALL COMPAQ
.
.
.
BE LIABLE FOR ANY DIRECT, CONSEQUENTIAL, INCIDENTAL, SPECIAL, PUNITIVE
.
.
.
OR OTHER DAMAGES WHATSOEVER (INCLUDING WITHOUT LIMITATION,
.
.
.
DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION OR LOSS OF
.
.
.
BUSINESS INFORMATION), EVEN IF COMPAQ HAS BEEN ADVISED OF THE
.
.
.
POSSIBILITY OF SUCH DAMAGES.
.
.
.
.
The limited warranties for Compaq products are exclusively set forth in the documentation
.
.
.
accompanying such products. Nothing herein should be construed as constituting a further or
.
.
.
additional warranty.
.
.
.
.
.
This publication does not constitute an endorsement of the product or products that were tested.
.
.
.
The configuration or configurations tested or described may or may not be the only available
.
.
.
solution. This test is not a determination of product quality or correctness, nor does it ensure
.
.
.
compliance with any federal state or local requirements.
.
.
.
.
Compaq, Compaq Insight Manager, LTE, ProLiant, and ROMPaq are registered with the United
.
.
.
States Patent and Trademark Office.
.
.
.
.
.
Microsoft, Windows, Windows NT, Windows NT Advanced Server, SQL Server for Windows NT
.
.
.
are trademarks and/or registered trademarks of Microsoft Corporation.
.
.
.
.
NetWare and Novell are registered trademarks and IntranetWare, NDS, and Novell Directory
.
.
.
Services are trademarks of Novell, Inc.
.
.
.
.
.
Pentium is a registered trademark of Intel Corporation.
.
.
.
.
Other product names mentioned herein may be trademarks and/or registered trademarks of their
.
.
.
respective companies.
.
.
.
.
.
.
.
.
.
©2001 Compaq Computer Corporation. All rights reserved. Printed in the U.S.A.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Scaling Out for Performance with Compaq ProLiant Servers
.
.
.
.
.
and Microsoft SQL Server 2000
.
.
.
First Edition (February 2001)
.
.
.
TC010201TB
.
.
.
.
.
.
.
.
.
2
ProLiant Servers and Microsoft SQL Server 2000
TC010201TB
Scaling Out for Performance with Compaq
ECHNOLOGY BRIEF
T
.
.
NTRODUCTION
I
.
.
.
.
.
The Internet and e-commerce have driven demands on database system performance and availability
.
.
.
beyond levels that could have been reasonably predicted ten or even five years ago. By removing
.
.
.
many of the traditional physical constraints on business commerce transactions, the Internet has
.
.
.
pushed the limits of peak performance for enterprise servers trying to meet intense e-commerce and
.
.
.
data processing needs. As a result, organizations must design thei r data processing systems to easily
.
.
.
accommodate exponential growth.
.
.
.
.
Cost-effective scalability is a critical component in planning and deploying database systems.
.
.
.
Previously, customers chose between scaling up for increased database performance and scaling out
.
.
.
for increased availability. Now, Compaq and Microsoft have developed a scale-out database
.
.
.
.
solution to increase both performance and availability.
.
.
.
.
This technology brief de fines scalability, distinguishes between scaling out and scaling up, and sets
.
.
.
some customer expectations for deploying superior and cost-effective scale-out database systems
.
.
.
designed in accordance with the Compaq Distributed Internet Server Array (DISA) architecture.
.
.
.
.
.
.
.
.
HE COMPAQ AND MICROSOFT PARTNERSHIP
T
.
.
.
.
Compaq’s business strategy includes partnering with other hardware and software vendo rs to meet
.
.
.
each customer’s specific needs with the best possible solutions. Compaq and Microsoft share a
.
.
.
strategic partnership that brings to market one of the most cost-effective scale-out database
.
.
.
solutions. This solution benefits directly from the unique relationship between Compaq technologies
.
.
.
and Microsoft database management products.
.
.
.
.
.
Results of multiple database benchmarking tests have demonstrated unprecedented performance of
.
.
.
this solution, which coordinates the management of large amounts of data partitioned across a group
.
.
.
of otherwise autonomous servers. Tests of multinode clusters of Compaq ProLiant 8500 servers and
.
.
.
Microsoft SQL Server 2000 confirm the advantages and applicability of this scale-out database
.
.
.
solution to real-world e-commerce businesses. The results confirm Compaq’s leadership in
.
.
.
delivering maximum performance with industry-standard server, storage, and interconnect
.
.
.
technologies.
.
.
.
.
.
.
.
CALING OUT VERSUS SCALING UP
S
.
.
.
.
.
Scalability is a system’s ability to maintain desired performance levels as the system grows, for
.
.
.
example, when a database system expands to accommodate increased traffic on an e-commerce
.
.
.
website. A database system can be scaled either up or out (Figure 1.) Servers are scaled up by the
.
.
.
addition of hardware such as processors, memory, or disk arrays to increase the maximum sustained
.
.
.
performance, while scaling out refers to adding servers to a cluster.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
3
ProLiant Servers and Microsoft SQL Server 2000
Loading...