Get In The Express Lane!
Download
Report
Transcript Get In The Express Lane!
Arquitectura Intel® y Microsoft SQL Server* 2005
Una Combinación Ganadora
M. Gabriela Gallardo
Especialista en Soluciones para Latinoamérica
Noviembre 21, 2005
Copyright © 2005 Intel Corporation
1
Intel y Microsoft
Crecimiento del Negocio
• Flexibilidad
• Interoperabilidad
• Escalable
COSTOS:
• Protección de la Inversión
• Control de Costos – TCO
Reducción Riesgos
• Implementación
• Misión Critica
2
Intel® visión de la teconlogía:
Entregando características y valor para los negocios de hoy y del
futuro
Virtualización
RAS
Cores y Threads
System Management
Administración de la energía
I/O y Memoria
3
Dos arquitecturas de 64-bits complementarias
brindando excelentes plataformas para los usuarios de
Microsoft SQL Server* 2005
Premier performance,
reliability, and scalability for
most demanding applications;
cost effective vs. RISC
Outstanding price/
performance and broadest
range of 32-bit apps and
headroom for 64-bit apps
4
Two Complimentary Enterprise 64-bit Architectures
Previous
Architecture/Solutions
RISC
architecture
IA-32
architecture
Transition Benefits
Exceptional
performance with
choice of operating
system, software and
hardware vendors
64-bit support via
Intel® EM64T,
great performance
for 32-bit apps
Architecture of
Choice
Premier performance,
reliability and scalability for
most demanding applications;
cost effective vs. RISC
Outstanding price/performance
and broadest range of 32 bit apps
and headroom for 64-bit apps
5
Intel® Itanium® 2-based platforms and SQL Server 64-bit: Enterprise-Class database platform
Benefit
Feature
Manage Huge
Volumes of Data
Higher performance – larger buffer
No AWE required
More simultaneous connections
Improved parallel
processing
Parallel & predictive query exec
More queries
More complex transactions
Real time analysis
Scale up & Multi
SQL Instances
Great availability/
Easy management
Database consolidation
Lower TCO
Increased headroom & scalability
High reliability
Natural and easy upgrade path
Leverage existing skill sets
Large Memory
Support
EPIC
Large SMP
Support
Enhanced MCA &
ECC
6
Why Microsoft SQL Server* 2005
on Intel® architecture?
Higher productivity
• Compatibility of Intel technologies
Better business decisions
• Proven Intel®-based platforms
Mission-critical abilities
• Intel tools & features enhance
SQL Server 2005 performance
7
Why Microsoft Visual Studio* on Intel® architecture?
Intel® Vtune™ Analyzer works within
Visual Studio to help identify &
remove performance bottlenecks
Intel VTune is the only 64-bit
performance tool available to help
developers take full advantage of
Intel® 64-bit processors
Intel® Thread Checker and Profiler
helps developers take advantage of
today’s dual-core technology
8
Microsoft SQL Server* 2005 compared to SQL Server* 2000
on Intel® Itanium® 2 processor
Server transactions 35% faster
with newer platform
Transaction processing (TPC-C) performance
on 64-bit processors
1082K
Database transactions at ~20%
lower cost
First result >1M tpmC on
Windows*
$5.38/tpmC
787K
$6.49/tpmC
Placed 4th on TPC-C sorted by
performance — No higher
Microsoft entry
Itanium 2 processor-based
systems with SQL 2005 deliver
improved performance and at a
lower cost
Itanium 2
Processor 1.50GHz
Itanium 2
Processor 1.60GHz
SQL 2000
SQL 2005
Results as of 7/8/05
See Backup for disclaimer details
Source: www.tpc.org
9
TPC-C top 4 results on Microsoft / Intel solution
$18.00
$16.00
$14.00
$12.00
$10.00
$8.00
$6.00
$4.00
$2.00
System Price
($M)
IBM
(pSeries)
DB2*
IBM
(pSeries)
Oracle*
HP-
HP-
Itanium®
processor family
- Oracle*
Itanium®
processor family
- SQL2005*
Intel / Microsoft
$0.00
Source: Transaction Processing Performance Council, www.tpc.org, sorted by TPC-C performance, 10/15/05.
Microsoft/Intel solutions delivers leading price/performance value
See Backup for disclaimer details
10
First platform to break the $1/tpmC mark
in TPC-C history
Compares TPC-C price-performance
result of dual-core platform to prior
generation single-core platform
• Dual-core processor: Dual-core Intel®
Xeon® Processor 2.80GHz, Microsoft
SQL Server* 2005 database
• Single-core processor: 64-bit Intel®
Xeon® Processor 3.60GHz, Microsoft
SQL Server* 2000 database
Workload Description
• Online transaction processing
No. 1 rank in price-performance at
www.tpc.org as of 10/10/2005
TPC-C Price-Performance
1.5
$1.40/tpmC
1.0
$0.99/ tpmC
0.5
29% better
Price-Performance
0.0
64-bit Intel Xeon
Processor 3.60GHz/
SQL2000
Dual-Core Intel Xeon
Processor 2.80GHz/
SQL2005
Source: www.tpc.org as of 10/10/ 2005
See Backup for disclaimer
details
11
The Intel® ecosystem supporting
Microsoft SQL Server* 2005 deployments
Broadly available platform solutions
Corporate developer support tools
• IT support that includes
Intel® Solution Services
• Deployment assistance for custom
app development onto SQL Server
2005, application migration
12
Customers running Microsoft SQL Server* 2005
on Intel® Architecture
“The launch of Microsoft SQL Server 2005, combined with platforms based on Intel Itanium 2
processors, validates Raymond James Financial’s long-term Windows platform strategy. As our
business continues to grow in size and complexity, Microsoft SQL Server 2005 and Intel Itanium 2
processor based technology provide a clear path to easily scale-up our existing SQL Server database
infrastructure, while adding more reliability and capabilities.”
Bruce Philipoom, VP Information Technology, Raymond James Financial
“Driving information delivery across the company is critical to our business success. The new
capabilities of SQL Server 2005 and high-performance Intel Itanium 2 processors, as well as ProClarity
6.1, will help us perform more sophisticated analysis. As a result, we expect to be able to reduce our
operating expenses, manage our service program more efficiently and enhance our push to increase
sales to small and mid-sized businesses.”
Dennis Naherny, Director of Enterprise Reporting, CompUSA
13
Intel® Architecture and Microsoft SQL Server* 2005
A Winning Combination
SQL 2005 on Intel®-based
Platforms offers major
improvements over SQL
2000* in:
• Scalability
• Development environment
• Feature parity, RAS (DB
mirroring), and security
14
Slide 1:
The Intel logo, Intel Inside, Intel Xeon, and Itanium are trademarks or registered trademarks of Intel Corporation
or its subsidiaries in the United States and other countries.
Slides 6-8:
Description: Online transaction processing e.g., order entry
Source: www.tpc.org. Itanium 2 processor 1.5 GHz result of 786,646 tpmC and $6.49/tpmC on HP Integrity
Superdome Server* using 64-bit Itanium 2 processors 1.5GHz with 6 MB L3 cache, Microsoft Windows Server
2003* Datacenter Edition 64-bit and Microsoft SQL Server 2000 Enterprise Edition 64-bit, availability date
10/23/03. Itanium 2 processor 1.6GHz result of 1,082,203 tpmC and $5.38/tpmC on HP Integrity Superdome
using 64-bit Itanium 2 processors 1.6GHz with 9MB L3 cache, Microsoft Windows Server 2003 Datacenter
Edition 64-bit and Microsoft SQL Server 2005 Enterprise Edition 64-bit, availability date 12/07/05.
Performance tests and ratings are measured using specific computer systems and/or components and reflect
the approximate performance of Intel® products as measured by those tests. Any difference in system hardware
or software design or configuration may affect actual performance. Buyers should consult other sources of
information to evaluate the performance of systems or components they are considering purchasing. For more
information on performance tests and on the performance of Intel products, reference
www.intel.com/performance or call (U.S.) 1-800-628-8686 or 1-916-356-3104.
Prices subject to change
Slide 7:
Source: Transaction Processing Performance Council, www.tpc.org, sorted by TPC-C performance, 8/1/05.
Prices subject to change without notice.
Slide 8:
Prices subject to change
Slide 11:
Information on the SQL Server product and program are provided by Microsoft. Intel does not make any
representations or warranties whatsoever regarding quality, reliability, functionality, or compatibility of the SQL
Server or the terms of the program.
Copyright © 2005, Intel Corporation. All rights reserved.
*Other names and brands may be claimed as the property of others.
15