hp polyserve database utility for sql server consolidation
DESCRIPTION
TRANSCRIPT
© 2006 Hewlett-Packard Development Company, L.P.The information contained herein is subject to change without notice
The Database Utilityfor SQL Server
Scott Campbell
Manager, Technical Specialist
2 April 10, 2023
Agenda – “The Sales Cycle”1. Identifying the Opportunity
2. High Level Value Proposition
3. Presenting the DB Utility for SQL Server
4. POC to Close
5. Success Example
“Is There An Opportunity?”
4 April 10, 2023
Identifying the Opportunity is Easy
1. Consolidation Plans?
2. Deployed Virtualization? (VMware)
3. 20 Servers or More Running SQL Server?
• If number 3 is “YES”, you have an opportunity.• If numbers 1 and/or 2 are “YES”, funding is likely
available.
Engage your PolyServe Sales or Technical Specialist
Opportunity IdentifiedHigh Level Value Proposition
6 April 10, 2023
Database Utility Value
• Run the same number of instances on fewer servers.
• Eliminate risk associated with stacking instances.
• Manage to higher levels of availability.• Manage to higher levels of storage utilization.• Drive management & operational efficiencies.
Drive significant cost out of the SQL Server infrastructure.
7 April 10, 2023
Compelling Events Driving Change• Mission Critical SQL Server Instances• SQL Server 2005 Migrations• Shared Services Models• Hardware Consolidation• Data Center Consolidations• Extended 64 Bit Computing - Intel/AMD
Change
8 April 10, 2023
Migrate & Consolidate – How to Get There Safely
Department B
Department A Department C
Department D
Lega
cy S
QL Se
rver
32Bit
Win
dows
SQL Serv
er 2005
64Bit W
indows
9 April 10, 2023
0
2,000,000
4,000,000
6,000,000
8,000,000
10,000,000
12,000,000
14,000,000
Soft Costs* Hard Costs Total Costs
5,537,3046,721,819
12,259,123
1 Soft costs include labor costs and downtime costs
Maximize Savings with the Database Utility
Starting Point: 30 Servers, average utilization rate of 20%
Post Consolidation: 16 Servers, average utilization rate of 50%
Hardware Re-Use Assumption: Replace 6 servers, re-deploy 20 serversThree Year Total Cost of Ownership Comparison
1,221,325
4,662,566
4,315,979
7,596,557
3,441,240
3,280,579
SQL Server Sprawl SQL Server Utility Cost Savings
10 April 10, 2023
But don’t trust our numbers……• Jointly build the TCO based on customer
numbers.
Presenting the SolutionBuilding Technical Credibility
12 April 10, 2023
The Many Costs of SQL Server Sprawl
5% to 20% Server Utilization Rates
Expensive and Complex High Availability
Ever-Expanding Management Burden
13 April 10, 2023
Managing Large Database Deployments
Number of Systems
Cost
10 20 30 40 60 80 100+
Standalone SQL Server
Managed under HP’s Database Utility
IT Budget for SQL Server
14 April 10, 2023
SQL Server Consolidation Opportunity
• Reduce Cost through Consolidation
−Servers
−Storage
−Software
• Easy and Comprehensive, High Availability
−Eliminate unplanned downtime
−Dramatically reduce planned downtime
• Increase Management Efficiency
−Streamline installs and patches
−Reduce server maintenance
−Simplify capacity managementSource IDC: 5 Year TCO
HP’s Unique Technology - PolyServe
The Power of Shared Data for SQL Server Consolidation
16 April 10, 2023
From Sprawl to Consolidation
SQL 1 SQL 2 SQL 3 SQL 4
• Shared Data is fundamentally different… Better!
−Eliminate 1:1 mapping of servers to storage & clients
17 April 10, 2023
SQL 1
From Sprawl to Consolidation
SHARED DATA
VIRTUALIZED CLIENT CONNECTIONS
SQL 9SQL 12SQL 1 SQL 4SQL 3SQL 2SQL 1
• Shared Data is fundamentally different… Better!
−Eliminate 1:1 mapping of servers to storage & clients
18 April 10, 2023
The Road to Consolidation & Utility Computing
19 April 10, 2023
The Enterprise Platform for SQL Server
ReliableHA
TrustedConsolidation
Stand Alone Performance & Management
“OR”“AND”
Opposing Forces
HP PolyServe Database Utility for SQL Server
SQL Server Sprawl is Very Expensive
Hardware Virtualization
SQL Server 2005
Enterprise DataCenter
Mission Critical
SLA’s
20 April 10, 2023
HP Adaptive Windows Infrastructure – SQL Server Utility
POC Process
22 April 10, 2023
Proof of Concept Options• Live Demonstration
−Virtual Room - often completed during presentation−Interactive Q&A Session
• “Show and Tell” POC−2 day effort at an HP facility−Highly structured & highly effective
• Evaluation POC−Customer Site Implementation−Test Plan−Timeline−Success Criteria−Typically 30 Days
• License Agreement Runs in Parallel
23 April 10, 2023
Closure• Opportunity is Qualified• TCO Compelling• Demonstrated Technical Credibility• POC Completion• Credible References• Solution Sold – Software/Hardware/Consulting-----------------------------------------------------------------
----------------------------------------• Post Sales SmartStart & Migration Services
−Implementation, Migration, and Knowledge Transfer
24 April 10, 2023
Business needs Customer benefitsHP solution
• Place and optimize sales of 1.5 TWhrs each week
• Ensure that output and sales are balanced every half-hour (48x per day)
• Scalable, 24x7 SQL Server 2005 & BizTalk 2006 trading platform
• Avg. unplanned outage costs BE £4M in lost profits
• HP PolyServe Database Utility software for SQL Server
• HP DL 585 servers
• Windows Server 2003 64 bit
• HP EVA 4000
British Energy Group plc is the UK’s largest generator of electricity (20% of UK’s electricity, 70 TWhrs) with 6,000+ employees and 9 power plants. They supply commercial customers and the energy trading market.
• Service Oriented Architecture for energy trading that virtualized all hardware layers
• Simplified operational environment and procurement complexity
• Ultra-reliable availability and scalability for mission critical SQL Server
British Energy
Scalable and dependable mission-critical energy trading platformScalable and dependable mission-critical energy trading platform
30 April 10, 2023
Database Utility Tools and Info Sources
• www.polyserve.com• www.hp.com• Live Demos
• http://www.polyserve.com/products_demo.php
• Content & Collateral• http://www.polyserve.com/sql_server_consolidation.ph
p
• TCO Spreadsheet
© 2006 Hewlett-Packard Development Company, L.P.The information contained herein is subject to change without notice
Thank You
32 April 10, 2023
Lose the Urge to Merge Stack Instances; Don’t Merge Instances.
• Merging Instances– Consolidating Databases– is Hard and Risky−Security & name collisions must be resolved
−Application vendors want their databases to be in separate instances
−Client connection strings must change
• This Method is Complex, Costly, Time Consuming, Risky, and NOT • what HP does.
Server 1
Instance 1
Database 1
Database 2
Database 3
Server 2
Instance 2
Database 1
Database 2
Database 3
Server 1
Instance 1
Database 1
Database 2
Database 3
Database 1
Database 2
Database 3
33 April 10, 2023
Stack Instances Instead• Stacking Maintains Instance Isolation
−Non-Disruptive to Applications
−Isolated Security Maintained
−Database Naming Not Impacted
−Client Connection Strings Maintained
Server 1
Instance 1
Database 1
Database 2
Database 3
Server 2
Instance 2
Database 1
Database 2
Database 3
Server 1
Instance 2
Database 1
Database 2
Database 3
Instance 1
Database 1
Database 2
Database 3
34 April 10, 2023
Big Iron. Big Expense. Big Risk.• Expensive:
− Most expensive way to buy compute capacity
− Administrators still working off hours
• Risky− Capacity Risk: Instances are still server locked
− Availability Risk: Downtime effects more instances
Why sacrifice on price/performance and increase risk?
35 April 10, 2023
Traditional High Availability Software is Not for Consolidation Don’t get tangled in the SCSI Web
• Traditional HA solutions use SCSI reservation− Controls server-to-storage relationships
− Introduces brittleness
• Change Is Disruptive− Each change requires downtime on related
servers
• Overwhelming Storage Configuration Complexity− Must pre-define all server to storage
relationships
− Every relationship is a source for potential failure
− Forces isolated storage management
Why take on the complexity of HA solutions not designed for consolidation?
36 April 10, 2023
Server Virtualization: Not for Mission Critical Databases
> Limited IO Performance> Lacks Robust High Availability> Forces Isolated Storage Management
37 April 10, 2023
VMware Isn’t The Right Tool for SQL Server
• Doesn’t Perform for SQL Server− High input-output overhead tax
− CPU limitations
• Doesn’t Meet Availability Requirements− Unplanned
• Distributed Availability Services is inadequate
− Planned• Vmotion works only if servers are up
• Doesn’t Decrease Biggest Cost Elements− Does not consolidate software images
− Does not consolidate storage
• Ironically, IT organizations are increasingly concerned about Virtual Machine sprawl
38 April 10, 2023
VMware Distributed Availability Services (HA)
Inadequate for mission-critical applicationsAvailability Challenge VMware PolyServe
Unplanned Failure Due to Physical Server Problem
Yes—total reboot in Virtual Infrastructure 3
Yes—fast failover with no reboot required
Unplanned Failure Due to OS Problem
No coverage Yes
Unplanned Failure Due to Application Problem
No coverage Yes
Planned Physical Server Upgrade
Yes (VMotion) Yes
Planned OS Upgrade No coverage Yes—Dynamic Re-Hosting
Planned Application Upgrade
No coverage Yes—Dynamic Re-Hosting
39 April 10, 2023
HP Database Utility for SQL Server
• Dynamic Re-Hosting™ for Optimization
−Stack multiple instances
−Buy only what you need
−React in 30 seconds
• Guaranteed High Availability for All
−All servers are active
−Guaranteed, mixed failovers – Fan out
• One-Click Maintenance−Dynamic Re-Hosting™ for offload and upgrades
−Hot insertion of mixed servers and storage
−One Windows install per server
−Push installs and hot fixes
MATRIX MANAGER
SHARED DATA
SQL 7 SQL 8 SQL 10SQL 9
SQL 12 SQL 13 SQL 14
SQL 1
SQL 6
SQL 2 SQL 3
SQL 5
SQL 4 SQL 5
SQL 12SQL 11 X
40 April 10, 2023
41 April 10, 2023
Customer Case Study
• Goals−Reduce number of servers required to provide high availability services for a major government entity
• Solution−PolyServe Database Utility for SQL Server, which eliminates need for passive fail-over servers
• Results−Reduction in server count of up to 85%; the environment currently consists of some 500 SQL servers, but will grow through 2013
• “Since consolidating our SQL Server databases with PolyServe, manual build time has been automated from days to hours and failover time has shrunk from five minutes to one; system management is more efficient and we expect to substantially cut overall cost-of-ownership for our SQL deployments.”
• David MillerDirector, Technology & Infrastructure Practice
Avanade is the leading global technology integrator on the Microsoft platform. Avanade is a joint venture formed by Accenture and Microsoft.
42 April 10, 2023
Customer Case Study
• Goals−Consolidate and centralize ERP running on SQL Server
−High availability without the cost of “wasted hardware”
• Solution−PolyServe Database Utility for SQL Server cluster on two-processor IBM BladeCenter servers + 130GB IBM TotalStorage
• Results−Estimated one month of downtime avoided
−Consolidation of 18 servers to one, driving down costs and maintenance burden
−Scalability to add new SQL instances and required redundancy quickly and inexpensively
• “The PolyServe Database Utility for SQL Server has already helped us immensely.
• Our focus at Greif is efficiency and consolidation. PolyServe went above and beyond in terms of both support and product. It is a fantastic product.”
• Jason Reese
Network Administrator
Greif is a world leader in industrial packaging products and services, recording $2.4 billion in sales for 2005.
43 April 10, 2023
Customer Case Study
• Goals−Roll out prescriptions processing application for nationwide network of outpatient pharmacies.
−Ensure high availability with minimal impact to server performance.
• Solution−PolyServe Database Utility on 4-way servers + 4TB SAN
−12 instances of SQL Server with 18 databases
• Results−Greatly reduced risk to database interruption SLAs. Failovers take 10 to 15 seconds vs. five minutes to two hours
−Maximized server utilization with built-in high availability
• “Initially, we brought PolyServe on board to support our prescription processing databases. We ended up expanding our use of the PolyServe SQL Server Utility and it has proven to be reliable and robust enough for much of our database work. We are looking to leverage PolyServe as much as possible for our current and future projects.”
• Michael BodetteSystems Administrator
Medical Products Division
44 April 10, 2023
Business needs Customer benefitsHP solution
• Place and optimize sales of 1.5 TWhrs each week
• Ensure that output and sales are balanced every half-hour (48x per day)
• Scalable, 24x7 SQL Server 2005 & BizTalk 2006 trading platform
• Avg. unplanned outage costs BE £4M in lost profits
• HP PolyServe Database Utility software for SQL Server
• HP DL 585 servers
• Windows Server 2003 64 bit
• HP EVA 4000
British Energy Group plc is the UK’s largest generator of electricity (20% of UK’s electricity, 70 TWhrs) with 6,000+ employees and 9 power plants. They supply commercial customers and the energy trading market.
• Service Oriented Architecture for energy trading that virtualized all hardware layers
• Simplified operational environment and procurement complexity
• Ultra-reliable availability and scalability for mission critical SQL Server
British Energy
Scalable and dependable mission-critical energy trading platformScalable and dependable mission-critical energy trading platform