Managing Sql Sprawl With Hp Poly Serve

67 %
33 %
Information about Managing Sql Sprawl With Hp Poly Serve

Published on June 26, 2008

Author: OwenC

Source: slideshare.net

Managing SQL Sprawl with HP PolyServe Breakfast Briefing Thursday 26 th June 2008 For the benefit of all attendees, please ensure mobile phones are switched off Welcome

Agenda 09:00 Introduction Ian Jauncey - Chairman, Itex 09:05 PolyServe Solutions Nick Coombs, PolyServe Product Specialist, Hewlett Packard 09:25 PolyServe Demonstration Phil Newman, PolyServe Product Specialist, Hewlett Packard 09:45 Q&A 09:55 Summary and Close Ian Jauncey

Evolution Business needs growing Server costs reducing Virtualisation creating sprawl

Business needs growing

Server costs reducing

Virtualisation creating sprawl

Itex and Hewlett Packard Itex worked with HP for over 30 years Itex focused on HP servers and storage for over 10 years Itex is an HP preferred partner

Itex worked with HP for over 30 years

Itex focused on HP servers and storage for over 10 years

Itex is an HP preferred partner

PolyServe SQL Consolidation Nick Coombs

Who’s PolyServe – A Hewlett-Packard Company Innovative Systems Software Company Founded in 1999 Background: NUMA-Q OS Team from Sequent Computer Strong Customers Over 500 customers Thousands of nodes in production Mostly mission-critical data center deployments Delivery real utility computing today Strong Partnerships HP: Worldwide NAS OEM deal Novell: Core Data Center Linux partner Microsoft: Endorsed as preferred NAS cluster partner Microsoft and Novell are also end user customers Oracle: OSCP and 10g Certifications HP Confidential

Innovative Systems Software Company

Founded in 1999

Background: NUMA-Q OS Team from Sequent Computer

Strong Customers

Over 500 customers

Thousands of nodes in production

Mostly mission-critical data center deployments

Delivery real utility computing today

Strong Partnerships

HP: Worldwide NAS OEM deal

Novell: Core Data Center Linux partner

Microsoft: Endorsed as preferred NAS cluster partner

Microsoft and Novell are also end user customers

Oracle: OSCP and 10g Certifications

HP Confidential SQL - Customer Challenge

Server Sprawl HP Confidential Uneven Server Utilization Over-provision for peaks & future Dedicated servers to simplify planning Dedicated servers to limit failure impact Many Management Points Increases Maintenance Windows High-cost High Availability Waste passive servers Configure identical servers Intervene on failed failovers

Uneven Server Utilization

Over-provision for peaks & future

Dedicated servers to simplify planning

Dedicated servers to limit failure impact

Many Management Points

Increases Maintenance Windows

High-cost High Availability

Waste passive servers

Configure identical servers

Intervene on failed failovers

HP Confidential The PolyServe Solution

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 HP Confidential 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

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

PolyServe Matrix Server Cluster File System All nodes can read and write all data concurrently Up to 16 nodes per cluster Any mix of node sizes and speeds Full support for Linux and Windows Certified by Oracle and Microsoft Mix OS levels in one cluster Mix PolyServe levels in one cluster High-Availability Services Fault tolerance using standard servers Full classic clusterware features Full n:1, n-m monitoring and failover Cluster Volume Manager Virtualize storage across multiple LUNs or arrays Striping, concatenation, online file system growth HP Confidential

Cluster File System

All nodes can read and write all data concurrently

Up to 16 nodes per cluster

Any mix of node sizes and speeds

Full support for Linux and Windows

Certified by Oracle and Microsoft

Mix OS levels in one cluster

Mix PolyServe levels in one cluster

High-Availability Services

Fault tolerance using standard servers

Full classic clusterware features

Full n:1, n-m monitoring and failover

Cluster Volume Manager

Virtualize storage across multiple LUNs or arrays

Striping, concatenation, online file system growth

HP Confidential

Total Cost of Ownership HP Confidential Source: IDC Server Environment Average Five-Year Total Cost of Ownership (non-virtualized)

Microsoft Recognition HP Confidential

Benefits HP Confidential Reduction in Physical Servers Rack Space – 2A per server Power - £2,207 per server over three years (7pence per kWh, PUE=2.5) C02 Emissions – 13.56 Tonnes per server over three years Software Licenses – SQL, Backup, … Software Maintenance – SQL, Backup, … Management Costs Agility – Decrease New Application deployment times Availability – HA for all servers at no extra cost Disk Space – Typical 33% reduction of Shared Storage

Reduction in Physical Servers

Rack Space – 2A per server

Power - £2,207 per server over three years (7pence per kWh, PUE=2.5)

C02 Emissions – 13.56 Tonnes per server over three years

Software Licenses – SQL, Backup, …

Software Maintenance – SQL, Backup, …

Management Costs

Agility – Decrease New Application deployment times

Availability – HA for all servers at no extra cost

Disk Space – Typical 33% reduction of Shared Storage

Thank You Nick Coombs 07703 022278 [email_address]

Managing SQL Sprawl with HP PolyServe Q&A Summary What next? Close Please remember to fill in our feedback form Copies of this presentation are available on USB memory stick

Q&A

Summary

What next?

Close

Please remember to fill in our feedback form

Copies of this presentation are available on USB memory stick

HP Confidential Tools (Appendix)

Easy Path From Sprawl to the SQL Server Utility HP Confidential Graphical Tool That Automates Process Auto-discovers databases Moves databases selectively Auto-creates new databases Migrate SQL Server 2000 or Upgrade to SQL Server 2005 From standalone or clustered From DAS or SAN Safe, Proven and Repeatable Process Manages source back up Stages steps with validation Documents steps in reports

Graphical Tool That Automates Process

Auto-discovers databases

Moves databases selectively

Auto-creates new databases

Migrate SQL Server 2000 or Upgrade to SQL Server 2005

From standalone or clustered

From DAS or SAN

Safe, Proven and Repeatable Process

Manages source back up

Stages steps with validation

Documents steps in reports

Migration Tool Capabilities Supported migration scenarios: SQL 2000 to SQL 2000 SQL 2000 to SQL 2005 SQL 2005 to SQL 2005 What the tool does: Migrate user databases Migrate SQL logins Migrate Linked/remote servers Migrate SQL jobs this

Supported migration scenarios:

SQL 2000 to SQL 2000

SQL 2000 to SQL 2005

SQL 2005 to SQL 2005

What the tool does:

Migrate user databases

Migrate SQL logins

Migrate Linked/remote servers

Migrate SQL jobs

Connection String Management – Instance Alias Tool HP Confidential Connection 201.25.2.100 SQL Data serv1 SQL Server (Default) (1433) Client1 Application serv1 201.25.2.100:1433 serv1 1433  40001 1433 201.25.2.100:1433 40001 Client Connection Strings Don’t Change 201.25.2.100 (VSQL1) Multiple Virtual IPs each with a Default named instance (port 1433) are hosted per physical cluster node SQL Data 201.25.2.1 poly1 SQL Server (NInst1) (40001) 201.25.2.2 poly2 SQL Server (NInst2) (40002) 201.25.2.102 (VSQL3) 201.25.2.101 (VSQL2) 201.25.2.103 (VSQL4) 201.25.2.104 (VSQL5) Migrate instance Migrate IP (optional) Alias

Thank You Nick Coombs 07703 022278 [email_address]

Add a comment

Related presentations

Related pages

Controlling Microsoft SQL Server sprawl - IT Channel ...

Consolidating Microsoft SQL Server will ... What benefits will consolidation have for the customer and VAR managing the service? SQL Server sprawl occurs ...
Read more

Special Report: Perspectives on SQL Server Sprawl ...

Home > Resources > PolyServe > Special Report: Perspectives on SQL Server Sprawl. Special Report: Perspectives on SQL Server Sprawl.
Read more

Nick Coombs | PolyServe , Inc. | ZoomInfo.com

Find out from Nick Coombs of Hewlett Packard how HP's Polyserve software can reduce server sprawl and ... 0925-0950 Managing SQL Sprawl - Nick Coombs, ...
Read more

HP Converged Systems for Microsoft SQL: Data Management | HP®

HP Converged Infrastructure portfolio plus Microsoft ... combats database sprawl while ... HP RA for Microsoft SQL Server 2014 on HP 3PAR StoreServ ...
Read more

HP App Map for Database Consolidation for Microsoft SQL ...

In order to address the growing need of IT organizations reducing costs and server sprawl ... SQL consolidation on the HP ... SQL Server consolidation.
Read more

PolyServe | Windows IT Pro

... SQL Server sprawl affects various key people in every organization and provides best practices for preventing server sprawl ... Managing, and ...
Read more

SERVER AUTOMATION - HP® Official Site | Laptop Computers ...

Learn how HP Server Automation software tools help automate ... managing server ... Control VM sprawl and compliance drift using a well ...
Read more

SQL Server Consolidation Strategies on the HP ProLiant DL980

“SQL Server sprawl” proved ... •Best Practices for Virtualizing and Managing SQL Server ... SQL Server Consolidation Strategies on the HP ...
Read more