Hp Polyserve Database Utility For Sql Server Consolidation

The Database Utility for SQL Server Scott Campbell Manager, Technical Specialist

Agenda – “The Sales Cycle” Identifying the Opportunity High Level Value Proposition Presenting the DB Utility for SQL Server POC to Close Success Example

“ Is There An Opportunity?”

Identifying the Opportunity is Easy Consolidation Plans? Deployed Virtualization? (VMware) 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 Identified High Level Value Proposition

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.

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

Migrate & Consolidate – How to Get There Safely Legacy SQL Server 32Bit Windows SQL Server 2005 64Bit Windows Department B Department A Department C Department D

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 servers 1 Soft costs include labor costs and downtime costs Three Year Total Cost of Ownership Comparison 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,304 6,721,819 12,259,123 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

But don’t trust our numbers…… Jointly build the TCO based on customer numbers.

Presenting the Solution Building Technical Credibility

The Many Costs of SQL Server Sprawl 5% to 20% Server Utilization Rates Expensive and Complex High Availability Ever-Expanding Management Burden

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

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 management Source IDC: 5 Year TCO

HP’s Unique Technology - PolyServe The Power of Shared Data for SQL Server Consolidation

From Sprawl to Consolidation Shared Data is fundamentally different… Better! Eliminate 1:1 mapping of servers to storage & clients SQL 1 SQL 2 SQL 3 SQL 4

From Sprawl to Consolidation Shared Data is fundamentally different… Better! Eliminate 1:1 mapping of servers to storage & clients SQL 1 SHARED DATA VIRTUALIZED CLIENT CONNECTIONS SQL 9 SQL 12 SQL 1 SQL 4 SQL 3 SQL 2 SQL 1

The Road to Consolidation & Utility Computing

The Enterprise Platform for SQL Server Reliable HA Trusted Consolidation 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 Data Center Mission Critical SLA’s

HP Adaptive Windows Infrastructure – SQL Server Utility

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

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

British Energy Business needs Customer benefits HP 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 Scalable and dependable mission-critical energy trading platform

Ordering Information Installation Support Software Type HA114A1 57Q PolyServe Software Installation and Startup HA107A3 7EZ Database Utility Pack- 8 CPU Support SW 24x7 (3 years) T5395ABE PolyServe Database Utility Pack- 8 CPU E-LTU List Price SKU Description

The Database Utility for SQL Server: Contacts And Tools

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.php TCO Spreadsheet

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

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

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?

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?

Server Virtualization: Not for Mission Critical Databases Limited IO Performance Lacks Robust High Availability Forces Isolated Storage Management

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

VMware Distributed Availability Services (HA) Inadequate for mission-critical applications Yes—Dynamic Re-Hosting No coverage Planned Application Upgrade Yes—Dynamic Re-Hosting No coverage Planned OS Upgrade Yes Yes (VMotion) Planned Physical Server Upgrade Yes No coverage Unplanned Failure Due to Application Problem Yes No coverage Unplanned Failure Due to OS Problem Yes—fast failover with no reboot required Yes—total reboot in Virtual Infrastructure 3 Unplanned Failure Due to Physical Server Problem PolyServe VMware Availability Challenge

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 SQL 12 X MATRIX MANAGER SHARED DATA SQL 7 SQL 8 SQL 10 SQL 9 SQL 13 SQL 14 SQL 1 SQL 6 SQL 2 SQL 3 SQL 5 SQL 4 SQL 5 SQL 12 SQL 11

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 Miller Director, Technology & Infrastructure Practice Avanade is the leading global technology integrator on the Microsoft platform. Avanade is a joint venture formed by Accenture and Microsoft.

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.

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 Bodette Systems Administrator Medical Products Division

Hp Polyserve Database Utility For Sql Server Consolidation

More Related Content

What's hot

Viewers also liked

Similar to Hp Polyserve Database Utility For Sql Server Consolidation

Recently uploaded

Hp Polyserve Database Utility For Sql Server Consolidation