Transcript http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA4-2741ENW.pdf Organizations are struggling to break free Silos and sprawl create complexity Solutions are costly and time-consuming to deploy Can’t access actionable insight quickly Systems are complex,

http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA4-2741ENW.pdf
Organizations are struggling to break free
Silos and sprawl create
complexity
Solutions are costly and
time-consuming to deploy
Can’t access actionable insight
quickly
Systems are complex, inefficient to
operate
No single view of the
business
Information is hard
to access and use
Volume, variety and
velocity of data is growing
Too much time spent wrangling all the
pieces
Microsoft Private Cloud Capabilities
Resource Pooling
Elasticity
Consolidate Databases
Scale Resource Efficiently
Challenge
Solution
Challenge
Solution
• Database sprawl discovery
• Microsoft Assessment and Planning Toolkit
(MAP)
• Minimize planned downtime
• Windows Server 2008 R2 Hyper-V Live
Migration
• Capacity planning
• Microsoft Consolidation Planning Toolkit for
SQL Server
• Manage unplanned downtime
• Migration planning
• Microsoft SQL Server 2008 R2 Upgrade
Advisor
• SQL Server Migration Assistant
• Guest Failover Clustering with
• Windows Server 2008 R2
• SQL Server 2008 R2
• Maximize virtual machine density
• Windows Server 2008 R2 SP1
• Hyper-V with Dynamic memory
• Virtual machine load balancing
• System Center Virtual Machine Manager
2008 R2
• Physical to virtual migration
• System Center Virtual Machine Manager
2008 R2
• Virtualize and manage instances
• Windows Server 2008 R2 Hyper-V
• System Center Virtual Machine Manager
2008 R2
Self-Service
Control & Customize
Deploy Resources On-Demand
Challenge
Drive Standardization and Compliance
Solution
Challenge
• Standardize server builds
• System Center Virtual Machine Manager
2008 R2 VM Templates
• Automate server provisioning
• System Center Virtual Machine Manager 2008
R2 Self-Service Portal 2.0
Source: NIST definition of Cloud Computing
(www.nist.gov )
Solution
• Measure usage
• Assign cost per VM template
• Usage reporting
• Charge back reporting
• System Center Virtual Machine Manager
2008 R2 Self-Service Portal 2.0
• Manage private cloud
• System Center Virtual Machine Manager 2008
R2
• System Center Operations Manager 2007 R2
• Management Packs
MS/HP DBC Reference Architecture
Complete
•
Optimize
Factory built and • Central console to
pretested
simplify management
Agile
• Provision SQL on
demand
• Meter and
Virtualization to • Tuned for SQL
chargeback usage
pool and improve
Server I/O
• Modular, scale
resource
• Migrate databases
as your business
utilization
and update
grows
• Consulting and
infrastructure with
support services
near zero downtime
•
Insight Control
Vision
Box Product
What we know today, Custom solutions.
Appliances / Reference Architectures
Either buy premade, or build your own
The Cloud
Azure
PDW
Fast Track RA
DBC RA
DBC RA and HP Virtual Systems
DBC RA
VS1
VS2… VS3
DBC Reference Architecture
Consolidate and provision SQL server in a private cloud
Base
Full
configuration configuration
•
Implement in weeks vs months
•
Provision databases in minutes vs weeks
•
75% operational expense savings
•
Consolidate 1000’s of databases
•
60,000 IOPS sustained / rack
HP ProLiant BL465
with P2000 storage
(… 10)
Faster time to value
Fast implementation means fast benefits
Factory built and tuned for performance
Deploy with Confidence
Workload requirements
– Proven infrastructure built on best
practices of leading experts
– Secure, compliant infrastructure for
fewer vulnerabilities
Reference architecture
– Single, trusted source of support for
simpler resolution
– Built in SCOM for managing the Infra.
Server, storage,
networking
Application software
Integrated and optimized by
HP and MS experts
Tested
Tuned
– DPM for doing backups
– HA built into the DBC RA
Pre-configured and ready to run
Single source for support
Validated
Reduce TCO and scale to 1000’s of databases
Unprecedented ROI to customers
…
Reduce cost
Drive Green IT:
35%
Energy
Cooling
Floor space
Administration
90%
95%
89%
75%
in the
first year
DBC Reference Architecture
Product architecture
DBC RA Hardware Design
Base Configuration
2 x ProCurve E6600 10Gbps switches
2x ProCurve E2910 1Gpbs switches
4 servers
8 cpu
1 TB RAM
28TB raw capacity
198 spindles
30,000 IOPs
HP C3000 Enclosure with Flex-10
4x BL 465c G7 Blades (2P)
• 256GB RAM
• 2x300GB HDD
2x
Storage
Blocks
Storage Block:
1 x P2000 Disk Array
3 x D2700 Disk Racks
(99 spindles in block)
Full Configuration
8 servers
16 cpu
192 cores
2 TB RAM
57 TB raw capacity
396 spindles
60,000 IOPs
4x
Storage Blocks
8x BL 465c G7 Blades (2P)
• 256GB RAM
• 2x300GB HDD
DBC reference architecture scales to 10 racks
Add half rack or full rack modules
Base configuration
+
Add half rack
Or add full rack
Half up to 10 racks
HP E6600 10Gbps switches
HP E2910 1Gbps switches
=
C3000 enclosure
(4-80) blade servers
(2-40)storage blocks–each w/:
27TB – 570TB raw capacity
up to 600K IOPS
DBC RA Management Software Stack
Applications monitoring
Applications deployment and patch
management
OS Monitoring of guests – hosts
Patch management of guests - hosts
Management of Hyper-V VMs
Migration of workloads
Monitoring HW alerts
Insight Control
DBC Software Stack – MS Products In Detail
– Management Server (Multiple VMs on blades)
• Windows Server 2008 R2 Data Center Edition
– Active Directory, DNS, HDCP, Hyper-V Roles
• Microsoft Assessment Planning (MAP) toolkit
• SQL Server 2008 R2 Data Center Edition
• System Center Configuration Manager R2
• System Center Operations Manager
• System Center Virtual Machine Manager 2008 R2
• Virtual Machine Manager Self-Service Portal v2.0 SP1
• System Center Service Manager
• Orchestrator Previously known as Opalis (for MAP workflow)
– Blades
• Windows Server 2008 R2 Data Center Edition
– Hyper-V Role
• Guest Virtual Machines
• Small, Medium & Large VM Templates
• SQL Server instances that are virtualized from existing customer installation
• SQL Server 2008 R2 Data Center Edition
DBC Storage Connectivity Hardware Architecture
Blade Enclosure
KEY:
Blade
Blade
Base RA
Blade
Blade
Add’l for Full Rack
Blade
Blade
Blade
Blade
2
VC Ports
2
2
2
10GbE Switch
10GbE Switch
P2000
MSA
3
P2000
MSA
D2700
JBOD
3
P2000
MSA
3
D2700
JBOD
P2000
MSA
D2700
JBOD
3
D2700
JBOD
User Workloads
VC Ports
Existing Servers
Windows Server, Hyper-V, System Center VMM
VM
P2V Migration
Server #1
VM
Server #2
VM
SQL Server EE 2005
SQL Server Std 2008
VM
Server #3
VM
SQL Server 2008 Std
R2
VM
Newly created VMs.
Use existing ‘IT template’ VMs.
Room to grow
Bank of VMs
VM1
VM2
VM3
Front
Back
P2000
D2700
D2700
D2700
General network traffic - Management
•
•
•
2 × HP ProCurve E2910 1G
Used for Network Traffic inside the Rack
Blades plug into customer network directly
Connection to customer network through the switch
is for management traffic only
iSCSI Storage traffic
2 × HP ProCurve E6600 10G
•
•
Used for iSCSI (storage) traffic
All storage components and blades
connected to this switch
Redundant 10 Gb Connectivity
to Network Core Switches
HP Virtual Connect Flex-10
10 Gb Ethernet Module
•
•
•
Connected to E2910 (internet)
Connected to E6600 (storage)
Connected to customer network
Baseline for Sizing the Hardware and Solution
Bundled SQL server database virtual machine templates
Small – 55%
•
•
•
•
1 virtual processor
2 GB RAM
100 GB formatted disk space
50 IOPS / VM
Medium – 35%
•
•
•
•
2 virtual processors
4 GB RAM
200 GB formatted disk space
400 IOPS / VM
Large – 10%
•
•
•
•
4 virtual processors
16 GB RAM
400 GB formatted disk space
1600 IOPS / VM
A single rack configuration is optimized for a balanced mix of
about 200 database instances
• Based on a mix of 128 small workloads, 48 medium workloads, and 16 large workloads – based on
Microsoft and HP best practices
• Customers with more small workloads can support more instances
VM Layout on Blades (1 & 2)
VM Layout on Blades (3 & 4)
Engineered with HA and DR ready
Protect business-critical SQL server workloads
High availability
Disaster recovery
•
•
Redundant network and storage infrastructure
Host cluster for server level failover
•
Host backup / restore
•
Base level of VM HA leveraging failover clustering at
the host level
Live migrate all VMs to another node in the cluster
while performing updates/patches on that host without
impacting the running workloads
•
Guest backup / restore
•
SQL Server technologies, including:
• Database mirroring
• Log shipping
• Replication
• Backup / restore
3rd-Party host-based clustering
Blades
•
Guest
•
•
Database
Cluster SQL within the VMs for an additional level of
granularity where necessary by leveraging VM guest
clustering*
Failover the SQL instance to another VM, and
patch/update the guest OS in the first VM with no SQL
downtime
•
*The DBC RA design is intended to support about 10-15% of the VMs using guest clustering.
Networking – Connecting to customer Network
Network redundancy using Link Aggregation Control Protocol (LACP)
Virtual Machines
Hyper-V Virtual NICs
Hyper-V Virtual Switches
Production
Backup
HP NIC Teaming Instances
Team
Production
Team
Backup

HP Virtual Connect
Flex-NICs (4 Channels)
Physical HP Flex-10 NIC with 2
Ports
Note: Not all networks are represented
30,000 Random IOPS per Half Rack
60,000 Random IOPS per Full Rack
Virtual Connect Network Design
1 Gb
8 Gb
1 Gb
8 Gb
2 Gb
1 Gb
8 Gb
1 Gb
8 Gb
2 Gb
Storage Block Disk Architecture
Can loose multiple disks with no data loss
DBC CSVs
http://www.microsoft.com/en-us/server-cloud/windows-server/server-virtualization-features.aspx
MAP tool for Sizing and Planning
• MAP tool discovers and profiles your SQL Server databases
• MAP categorizes SQL instances by size (small, medium, large)
• Intelligent framework for consolidation strategy
Provision SQL servers on demand
Self service portal workflow engine manages and controls requests
Usage metering and chargeback
Self service portal reports usage enables charge back by business units
HP DBC RA support
Choose the service level from Microsoft and from HP to meet your business needs
HP
Microsoft
Support Plus 24**
Premier Support*
− 24x7 reactive support with on-site
response
− Proactive services
− Technical account management
Premier mission critical
All features of underlying premier plan above plus
− Faster reactive support response time with on-site
solution engineering support
− Personalized coverage through designated support
engineer
− Solution supportability review and health checks for
maximum performance
− Reactive 24x7 hardware and software support for HP
components with a 4 hr onsite hw response
Proactive 24 Service
or
− The coverage of Support Plus 24, enhanced with account
support manager delivered proactive services to improve IT
stability
or
Critical service
− Minimizes the business risk of downtime by enhancing
proactive 24 services with support through the Global
Mission Critical Solution Center (GMCSC)
Critical Advantage
or
− Proactive mission critical support with access to the
GMCSC and tailored to x86 virtualized environments