Britt Johnston Principal Group Manager Microsoft DBI301 What Ill Talk About Why use Appliances Updated Microsoft Appliance Roadmap Future Appliances Business Decision Appliance Why Appliances ID: 165832
Download Presentation The PPT/PDF document "Appliances" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Appliances
Britt JohnstonPrincipal Group ManagerMicrosoft
DBI301Slide2
What I’ll Talk About
Why use Appliances?Updated Microsoft Appliance RoadmapFuture Appliances
Business Decision ApplianceSlide3
Why Appliances?Slide4
New Way: Fast, Easy, and High-value Solutions
Broad
applicability
Common workloads
Pre-configured
Pre-tuned
Integrated management
Surrounded by expert support
Balanced architectureSlide5
Value of Appliances
OPTIMIZED
For each workload
Energy efficiency
Performance
COMPLETE
HW + SW + Services
Single support contact
AGILE
Up and running in 1/10th of the time
Compatible
Use existing knowledge, tools
Pre-tuned, preinstalled: less riskSlide6
The Appliance Engineering Approach
Each solution matching and balancing four main elements
Driven by a fundamental understanding of the workload
Architecture followed by and supported by componentsSlide7
Terminology
Term
Definition
Database Appliance
An appliance
with hardware and
software in an
integrated solution
specifically pre-installed and pre-optimized for database workloads
Tier-1 Appliance
Large Enterprise
Mission Critical Workloads
Outages have direct revenue impact, application
or
server cannot be down OR needs to recover rapidly, unlikely to allow for even scheduled downtime
Tier-2
Appliance
Small
to Medium Enterprise Workloads
All
the non-Tier-1 applications or application components that you care about. Planned downtime is acceptable, recovery needs to be timely not instant.Slide8
Reference Architecture Maturity Levels
Design
a
new system
using
best
practices
Buy
a
new configuration
with potential capabilities
Deploy
a
new solution with proven
performance
The appliance experience varies by target workloadSlide9
Roadmap
Update…Slide10
Roadmap
Data
Warehouse
Business Intelligence
Private Cloud
OLTP
Available NOW
HP Enterprise Data Warehouse
Reference Architecture
Appliance
Fast Track DW (10+ partners)
HP Business Decision ApplianceSlide11
Roadmap
Data
Warehouse
Business Intelligence
Private Cloud
OLTP
Available in next 3 months
HP Enterprise Data Warehouse
Data Warehouse
Fast Track DW (10+ partners)
HP Business Decision Appliance
Database Consolidation
Reference Architecture
ApplianceSlide12
Roadmap
Data
Warehouse
Business Intelligence
Private Cloud
OLTP
Available in 2012
HP Enterprise Data Warehouse
Data Warehouse
Fast Track DW (10+ partners)
HP Business Decision Appliance
Database Consolidation
Database Consolidation
Enterprise Transaction Processing
Reference Architecture
ApplianceSlide13
Roadmap:
Options for customers, in size, workload, and form factor
Data
Warehouse
Business Intelligence
Private Cloud
OLTP
HP Enterprise Data Warehouse
Data Warehouse
Fast Track DW (10+ partners)
HP Business Decision Appliance
Database Consolidation
Database Consolidation
Enterprise Transaction ProcessingSlide14
Fast Track Data Warehouse
Reference Architecture
Scales from SMB to Enterprise
Prescriptive guidance and optimized methodology for deploying DW
Balanced hardware approach ideal for small to mid-sized DW or
data-marts with scan-centric workloads
Supports 8 to 48TB Data Warehouses at leading price/performance
Partners provide configurations, validate performanceSlide15
Scale-Up OLTP Premium Appliance
Extreme scalability:
Processors, memory and storage for demanding workloads
Maximum uptime:
Pre-built HA with DR option for mission critical systems
Responsive support:
Tier 1 mission-critical support with one number to call
Best-of-breed HW/SW with HA/DR
Example Architecture Options
Clustered Servers
Shared Storage
Multiple Secondary
HADRON Based FailoverSlide16
Database Consolidation Appliance
Reduced TCO:
Virtual infrastructure reduces deployment and management cost
Modular:
Scale-out architecture allows starting configuration that can grow
Simplified:
Integrated management to ease migration & ongoing operation
Aggregate 100s
to
1000s of Tier 2/3 DBs in
scalable virtual infrastructure
Resource Pooling
Self - Service
Control & Customize
ElasticitySlide17Slide18
Data Warehouse AppliancesSlide19
Range of Needs
Small / Medium Business or Departmental Data
Warehouse
Hub
and
Spoke Data-mart
Enterprise Data
WarehouseSlide20
Data Warehouse Solutions
A range of options to suit your business requirementsBusiness Data Warehouse Appliance significantly reduces barrier to entry
Self Build
Future
Appliance
DL370
DL380/5
DL580/5
DL980/5
Effort to Build
Very High
Very Low
Moderate
Moderate
Moderate
Moderate
Very Low
Capacity
Variable
5 TB
14 TB
20 TB
40 TB
40 TB
500 TB
Concurrency
Variable
Light
Light
Medium
Medium
High
Very High
Query Complexity
Variable
Medium
Medium
Medium
Medium
High
Very High
EDW ApplianceSlide21
HP Business Decision ApplianceSlide22
Balancing IT and End User Needs
IT
Professionals
Data Consistency & Quality
Scale & Oversight
Security &
Compliance
Access to existing data sources
Familiar & Agile Authoring Experience
Sharing & Collaboration
Information Workers
Insight
OversightSlide23
Managed Self-Service BI
With
PowerPivot
PowerPivot for Excel
PowerPivot for SharePointSlide24
HP Business Decision Appliance
Optimized for SQL Server 2008 R2 and SharePoint Server 2010
AGILE
Deploy in less than an hour
Business insight
in less than a week
Developed for Mid-market, enterprise department and
remote
offices
Complete
HW, SW and Support included
,
installed, tuned, tested
Windows Server + SQL Server + SharePoint Server +
PowerPivot
for
SharePoint
OPTIMIZED
Share and refresh PowerPivot workbooks (often containing millions of rows and multiple data sources) with ease
Handles 80-100 concurrent users
Appliance style support included
Hardware:
2
Westmere
CPUs
12 cores
total
96 GB
Memory
Storage for workbooks and backupSlide25
65
PowerPivot
User Complex Workbook Workload
5 to 30 sec think
time
2.289s
avg
per slicer
click
CPU stays less than 14%Slide26
Machine Name and Domain Join
26Slide27
SharePoint Starting Page – For End UserSlide28
Appliance Management ConsoleSlide29
Microsoft BI Appliance MPDiagram ViewSlide30
BDA Characteristics
Provides integrated IT dashboard with usage visualizationReduces implementation risk and cost, saving 1-6 monthsSimple to set up and configure
Easily installed by channel partner
Backed by software technical support
One machine SharePoint farm with all needed software
The only external software requirement - domain controller
PowerPivot
with SharePoint is primary workload
Sharing business reporting and analytics insights
Excel Services, Analysis Services capabilities enabled (Reporting Services installed
but not configured)
Appliance Home Page to help customers create and share workbooks quickly.Slide31
Resources
Topic
Resource (Why consolidate)
Benefits on SQL Server consolidation/virtualization
SQL Server 2008 R2 Consolidation Datasheet
SQL Server 2008 Consolidation Whitepaper
SQL Server 2008 R2 Virtualization Datasheet
SQL Server 2008 R2 Licensing
and
web site
Support policy for SQL Server virtualization
SQL Server Consolidation Guidance
Topic
Resource (Comparison)
Compare
Cost Comparison Calculator
Hyper-V Calculator
Why Hyper-V for existing VMware customers?
Hyper-V vs. VMware operational cost comparison
Hyper-V vs. VMware cost comparison white paper
Hyper-V vs. VMware cost comparison video
Hyper-V vs. VMware ongoing cost comparison
Debunk VMware cost calculator from
Taneja
Group
Hyper-V is the best virtualization for SQL Server
Topic
Resource (How to Plan & Deploy)
Windows / Hyper-V
Windows Server Virtualization Guide
Hyper-V VM Processor Compatibility
Partner resources
SQL Server Consolidation on IBM x3850 servers
NetApp SQL Server Consolidation/Virtualization
Tools
Consolidation Planning Tool for SQL
Server
MAP Toolkit
Offline Virtual Machine Servicing Tool 2.1
Plan
& Deploy
Consolidation using SQL Server 2008
SQL Server Virtualization with Hyper-V
Managing SQL Server Virtual Appliances
Analysis Services Consolidation Guidance
Onboarding SQL Server Private Cloud EnvironmentSlide32
Resources
Topic
Resource (What to consider)
Security
Hyper-V Security Guide
HA
Hyper-V Live Migration Architecture
Resource
Management
Server Memory Options
Affinity mask Option
Resource Governor Whitepaper
Managing SQL Server with Resource Governor
Support Statement for Dynamic Memory in SQL Server Virtualization
Manageability
System Center VMM Self-Service Portal 2.0
P2V
in System Center VMM
Virtualization with Hyper-V
How to: Extract a DAC
Storage Requirements
Data Compression Strategy
for SQL Server 2008
SQL Server Compression Datasheet
SQL Server Compression Whitepaper
Unicode compression in SQL Server 2008 R2
Pre-deployment I/O Best Practices
Disk Alignment Best Practices for SQL Server
Performance & Scalability
SQL Server in Hyper-V Best Practice
High Performance SQL Server on Hyper-V
Virtual Hard Disk Performance White Paper
Hyper-V R2 Performance By ESG
Hyper-V R2 SP1 Workload Performance By
ESG
Blogs:
Windows
Virtualization Team
Blog
SQLOS Team Blog
Web site:
SQL Server for Private CloudSlide33
Database Platform (DAT) Resources
Required Slide
Track PMs
will supply the content for this slide, which will be inserted during the final scrub.
Try the new SQL Server Mission Critical
BareMetal
Hand’s on-Labs
Visit the updated website for SQL Server
®
Code Name “Denali” on
www.microsoft.com/sqlserver
and sign to be notified when the next CTP is available
Follow
the @SQLServer Twitter account to watch for
updates
Visit the
SQL
Server Product Demo Stations in the DBI Track section of the
Expo/TLC
Hall
. Bring
your questions, ideas and
conversations!
Microsoft® SQL Server® Security & Management
Microsoft® SQL Server® Optimization and Scalability
Microsoft® SQL Server® Programmability
Microsoft® SQL Server® Data Warehousing
Microsoft® SQL Server® Mission Critical
Microsoft® SQL Server® Data IntegrationSlide34
Resources
www.microsoft.com/teched
Sessions On-Demand & Community
Microsoft Certification & Training Resources
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
Learning
http://northamerica.msteched.com
Connect. Share. Discuss.Slide35
Complete an evaluation on
CommNet
and
enter to win!Slide36Slide37
©
2011 Microsoft
Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment
on
the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation
. MICROSOFT
MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.Slide38