Transcript DBI301 Broad applicability Common workloads Balanced architecture Integrated management Pre-configured Pre-tuned Surrounded by expert support The Appliance Engineering Approach Workload Architecture Software Hardware Term Definition Database Appliance An appliance with hardware and software in an integrated solution specifically pre-installed.

DBI301
Broad
applicability
Common workloads
Balanced
architecture
Integrated management
Pre-configured
Pre-tuned
Surrounded
by expert
support
The Appliance Engineering Approach
Workload
Architecture
Software
Hardware
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.
General Guidance
HW/SW Guidelines
Reference Workloads
Vendor-Specific Reference Configuration
HW/SW Parts
Buy a new configuration
with potential capabilities
+Validation Test
Appliance Product
HW/SW SKUs
Design a new system
using best practices
+Performance Claims
Deploy a new solution
with proven performance
The appliance experience varies by target workload
Fast Track DW (10+ partners)
HP Enterprise Data Warehouse
HP Business Decision Appliance
Fast Track DW (10+ partners)
HP Enterprise Data Warehouse
Data Warehouse
HP Business Decision Appliance
Database Consolidation
Options for customers, in size, workload, and form factor
Fast Track DW (10+ partners)
HP Enterprise Data Warehouse
Data Warehouse
HP Business Decision Appliance
Database Consolidation
Reference Architecture
Best-of-breed HW/SW with HA/DR
Aggregate 100s to 1000s of Tier 2/3 DBs in scalable virtual infrastructure
Small / Medium
Business or
Departmental Data
Warehouse
Enterprise Data
Warehouse
Hub and Spoke Data-mart
Self Build
Future Appliance
DL370
DL380/5
DL580/5
DL980/5
EDW Appliance
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
Information Workers
IT Professionals
With PowerPivot
Optimized for SQL Server 2008 R2 and SharePoint Server 2010
COMPLETE
OPTIMIZED
AGILE
26
Topic
Resource (Why consolidate)
Topic
Resource (Comparison)
Benefits on
SQL Server
consolidation/vi
rtualization
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
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 Environment
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
Web site:
SQL Server for Private Cloud
Blogs:
Windows Virtualization Team Blog
SQLOS Team Blog
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
Try the new SQL Server Mission Critical BareMetal Hand’s on-Labs
Visit the SQL Server Product Demo Stations in the DBI Track section of the
. Bring your questions, ideas and conversations!
• Microsoft® SQL Server® Security & Management
• Microsoft® SQL Server® Programmability
• Microsoft® SQL Server® Mission Critical
• Microsoft® SQL Server® Optimization and Scalability
• Microsoft® SQL Server® Data Warehousing
• Microsoft® SQL Server® Data Integration
http://northamerica.msteched.com
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
To access
more details
on this session,
capture this TAG