Transcript ipf oracle dell intersection and positoin

Intel® Itanium® Reference Solution
Microsoft SQL*-Windows Database
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
1
The Challenge
 Increase performance & scalability to
accommodate more transactions &
more clients to handle your company’s
growth
 24 x 7 availability & security to ensure
customer satisfaction
 Reduce costs and simplify system
administration
The Solution: Microsoft SQL* Database &
Windows on Intel® Itanium® 2-based Servers
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
2
Microsoft SQL* Achieves Best Results
on Intel® Itanium® 2-Based Systems
tpmC
54%
better
Microsoft SQL Server
is Enterprise Ready
2
 7 of the world's top 10 largest Windows-based
TP databases
 9 of the world's top 10 largest Windows-based
TP databases by row count
 4 of the world's top 10 largest transaction
processing databases by rows, across All
Environments
* Other names and brands may be claimed as the property of others.
$/tpmC
48%
better
16 Processor Systems1
Tpc.org TPC-C $/TPC-C as of 3/28/2004 9:00:48 PM –
Unisys ES7000 Aries 420 ES 16
309036.53 $ 4.49 Itanium2 1.5 1/20/2004
HP rx8620 16
301225.00 $ 4.20 Itanium2 1.5 12/18/2003
IBM eServer xSeries 445 16P c/s
215485.89 $ 8.72 Xeon MP 3.0 3/26/2004
IBM eServer xSeries 445-16P c/s
190510.02 $ 8.39 Xeon 2.8 7/18/2003
Unisys ES7000 Orion 540 ES 16
181280.45 $ 5.85 Xeon MP 2.0 5/2/2003
Unisys ES7000 Orion 540 ES 16
161542.04 $ 6.11 Xeon MP 1.5 5/16/2003
eServer xSeries 440 c/s 16
151744.13 $11.03 Xeon MP 2.0 3/26/2003
2 http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp
1
Enterprise Platforms Group
3
Intel® Itanium® Built from the Ground Up
for the Most Demanding Environments
Next Enterprise
Architecture
Intel®
Itanium®
Processor
EPIC
Age : 5+
Performance
Superscalar
Time
RISC
CISC
Age : 14+
Scalable & Reliable
Age : 13-17+
Age : 24+
* Source: Computer Organization and Architecture, 1999 W. Stallings
Performance Through
Parallelism
 Maximizes instructions executed in
parallel
 World-class floating point
 Speculation & predication to overcome
memory latency & branch misses
(common to databases)
* Other names and brands may be claimed as the property of others.
 Largest, most demanding
workloads requires new
approach
 Benefits from the experience
of past architectures
 Developed by the best CPU
& server architecture minds
in the industry
Massive On-chip
Resources
 Systems scalable to 512
CPUs & beyond
 64-bit for large memory
addressability
 High internal & external bus
& memory bandwidth
 MCA for data detection,
correction & logging
 Large & fast on-die cache
 264 registers (general, FP, branch)
 Efficient management engine
– Register stack engine
– 4 GB page size
Enterprise Platforms Group
Intel® Itanium® 2 Processor
Architecture Capabilities
Intel®
Intel®
Xeon™
AMD
Xeon™
MP
Opteron*
Processor
Processor
Intel®
Itanium® 2
Processor
IBM
Power*
Sun
UltraSparc*
Error recovery on data bus (ECC)



Lockstep support

Bad data containment


2005

Memory SDEC, retry on double-bit





Memory spares





Partitioning
 node
core
node
node
Electrical isolated partitions
 node
node
node
Cache Reliability (Pellston)


Providing leadership in reliability
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
5
Intel® Itanium® 2 Processors Enable the
Power of the Microsoft SQL* Database
Performance & Scalability





Itanium 2-based systems hold the record for TPC-C scale up AND scale out
Scale up solutions from 2 – 64+ processors available
Huge on-die cache – 6MB L3 (moving to 9MB)
256+ registers
Fast & wide bus to enable high speed I/O
Reliability Features
 Enterprise-class integrated RAS features for error-checking, error-correcting logic,
enhanced thermal management capability, MCA and Error Correction Code
Platforms and Operating Systems




Broad spectrum of support with 60+ OEM solutions
Available Operating Systems including Linux, Windows & HP-UX
Over 1200 applications compiled for Intel Itanium 2 processors
Broad support for 32-bit supporting applications through the IA-32 Execution Layer
(EL)
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
6
Scale-Up Solutions with Microsoft
SQL* Database
Challenge
SQL-64 Provides
Large Working Set Size (>3GB+)
 Lots of Buffer Pool thrashing (critical sections)
Large cache reduces
I/O
Complex Queries
 Sorts, joins, workspace that can spill to disk
 Supply chain management applications
Large cache & higher
parallelism
Large Virtual Memory / Large # Connections
 Many open cursors
Large cache & larger
virtual memory
Multiple Instances of SQL Server
 Total memory required is >3GB
Higher parallelism &
large memory
Availability & Scalability
 Higher requirements
* Other names and brands may be claimed as the property of others.
Large SMP support &
built-in reliability
Enterprise Platforms Group
7
Microsoft SQL* Provides Three
Database Consolidation Options
Client
Client
Database
Mid-tier
Apps
Database
Mid-tier
Apps
Database
Traditional Environment
Client
Client
Client
Mid-tier
Apps
Mid-tier
Apps
Mid-tier
Apps
Client
Mid-tier
Apps
Client
Mid-tier
Apps
Client
Mid-tier
Apps
Database
Client
Mid-tier
Apps
OS
Single SQL Instance/Multiple DB
Database
Database
Client
Client
Mid-tier
Apps
Client
Mid-tier
Apps
Database
OS
Multiple SQL Instance
* Other names and brands may be claimed as the property of others.
Mid-tier
Apps
Database
OS
Database
OS
Database
OS
HW Partitions
Enterprise Platforms Group
8
Microsoft SQL* Database Pricing &
Licensing
 Same price & license terms as SQL Server
2000 Enterprise Edition (32-bit)
 SQL Server 64-Bit Products:
–Microsoft SQL Server 2000 Enterprise Edition (64bit)
–Microsoft SQL Server 2000 Developer Edition (64bit)
 SQL Server 2000 Enterprise Edition (32-bit)
licenses can be used to run SQL Server 2000
Enterprise Edition (64-bit)
–Customers who have bought a SQL 32-bit
enterprise agreement can move to SQL 64-bit
without buying another license
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
9
Intel® Itanium® Reference Solution
Microsoft SQL*-Windows at Raymond James
The Challenge: Implement a data warehouse solution to enhance productivity and
improve the quality of its financial advisors’ recommendations.
“When we were looking at hardware to support the warehouse, we wanted a system that
would be absolutely reliable, and we wanted a system that would scream. The HP Integrity
Superdome* server with Intel Itanium 2 processors is perfect for us.”
Tim Eitel
Chief Information Officer
Raymond James Financial
Solution Benefits
HP Integrity
Superdome*
server with 16
Intel Itanium 2
processors
3-5X performance increase
over 32-bit solution;
overnight updates now take
1 hour
Better use of information to
increase profitability, reduce
costs, increase production,
improve quality of financial
advice
Enhanced ability to recruit
new advisors
1Results
as reported by Raymond James Financial. Intel has not verified these results. Results may not be
representative and may vary. Buyers should consult other sources of information to evaluate the performance of
systems or components they are considering purchasing.
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
10
Intel® Itanium® Reference Solution
Sample Microsoft SQL*-Windows Database Stack
Interface &
Presentation
Microsoft* Visual Studio* .NET/XML Web
Services/ASP.NET/Java* Server Pages
mySAP ERP/Microsoft* Internet Information
Services (IIS)
Applications
Management
AntiVirus/
Monitoring
Microsoft Active
Security
Microsoft MMC
Directory/WMI
NAI McAfee
Backup/Restore
High
DBA Tools
Volume Copy
Avail/Clusters
SQL Enterprise
Shadow Service Microsoft MSCS
Manager
Microsoft* SQL Server* 2000,
Enterprise Edition (64-bit)
Database
Microsoft Windows Server* 2003,
Datacenter Edition
Operating System
Server
HP Integrity Superdome* w/16 Intel Itanium 2
Processors (each supported by 4 GB RAM & 6 MB
L3 Cache)
Storage
* Other names and brands may be claimed as the property of others.
1.6 TB EMC* Storage Area Network
Enterprise Platforms Group
11
Backup
12
Intel® Itanium® Processor Family
Innovations
Future
Enhancements
2004 & Prior
Enhancements
•
•
•
•
•
•
EPIC architecture
Enhanced Machine Check
Architecture
FMAC for floating-point
leadership
Largest on-die resources for
demanding workloads
•
•
•
•
Multi-core
Virtualization
I/O & memory
Enhanced RAS
Cost parity with Xeon™
processor based platforms (via
common platform
infrastructure)
Up to 2X higher performance
than Xeon™ based platforms
2005 Planned Enhancements
•
•
•
•
Dual-core
Multi-threading
Power management technology
• Demand Based Switching (DBS)
• Automatic Control Power Consumption (ACPC)
Enhanced system bus bandwidth
•
•
•
•
•
New performance feature (Foxton)
New reliability feature (Pellston)
Virtualization feature (Silvervale)
PCI Express*
Fully-buffered DIMMS (FBD) , DDR2
Platform innovations deliver performance,
reliability & manageability
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
13
Analysts on Intel® Itanium® Processor
Leadership
“...floating point is significantly faster on Itanium
processors…and transaction and enterprise
application performance is also faster than on
Xeon processors …differences mean that Itanium
processors are better suited for database and
high-end enterprise applications and for many
scientific and analytic applications. While the
processors both support a 64-bit address space,
they differ in other areas and will be used to
support different workloads
IDC, Vernon Turner, February 17, 2004
To be sure, 64-bit extensions from either AMD or
Intel don't magically transform x86 into the
answer to all computing problems. High-end
performance and reliability features in Itanium
and its RISC competitors still make them the
better solution for high-scale, highestperformance, or truly mission-critical operations.
Illuminata, Gordon Haff, March 16, 2004
* Other names and brands may be claimed as the property of others.
Gartner First Take
Feb 20, 2004
“…extensions will bring value to a limited set of
memory-intensive server and workstation
applications. …Intel's Itanium line is not affected
by this announcement. Server processors of this
class — including Itanium, SPARC, POWER and
PA-RISC — have system implementation
requirements that extend well beyond 64-bit
addressing. “
“Continue to buy Itanium servers as indicated Itanium is still a viable high-performance platform,
and where the economics and software support
align, Itanium-based systems should remain a
mainstream option.”
Forrester Research, Richard Fichera, March 12,
2004
Enterprise Platforms Group
14
Analysts on Intel® Leadership
“Intel's Itanium is well positioned because it can
run Windows .NET and Unix/Linux J2EE
environments -- and it has solid parallelization
and multi-core plans … *Sun has an aggressive
roadmap to bring multi-threading and multi-core
capabilities to market (but UltraSPARC sales
volumes are declining and Sun may face a
volume manufacturing disadvantage in the 64-bit
market as that market moves toward
commoditization). *AMD's microprocessor is not
really positioned to go head-to-head with IBM's
POWER, Sun's UltraSPARC, or Intel's Itanium
architectures (instead, IA-32 is Opteron's target).
“X86 hybrids will fill a market need. But they’re
not a long-term replacement for the Itanium or
other 64-bit chips”
Gartner, John Enck, February 26, 2004
“There’s much more of an opportunity at the high
end, and Itanium looks ready to hit its stride”
Insights 64, Nathan Brookwood, February 23,
2004
Joe Clabby, Clabby Analytics, March 9, 2004
“Our analysis shows that Itanium 2 has
now gained an important foothold in the 64bit marketplace; that Intel’s roadmap
positions the Itanium 2 to become a
power/price/performance leader in the 64bit marketplace.”
Clabby Analytics, Jan 2004
* Other names and brands may be claimed as the property of others.
Enterprise Platforms Group
15