pointnext services for database modernization destination ... · pointnext services for database...
TRANSCRIPT
PointnextServices for Database ModernizationDestination: Easy on-ramp to hybrid cloud with SQL
1
Kevin LangeHPE Master Database ArchitectHPES02
September 25. 2018
A new breed of IT needs to power the New Style of Business
2
7.6Billion World population
30Billion Connected devices
1Trillion Applications
5.8Trillion Bytes for each of those 7.6 Billion People
By the year 2020…
Time to value is priority #1
3
Today Tomorrow
Valu
e
Time
Valu
e
Time
Idea
Value
Idea
ValueContinuousvaluecreation
2018 Clients Engaged:
4
Hybrid CloudShared
Lower cost
Dedicated Higher cost
Higher administration Lower administration
PhysicalPhysical Machine (raw iron)
IaaSAzure and AWS Virtualized MachinesAzure Stack
VirtualPrivate CloudVirtualized Machine + Appliance
DBaaSAzure SQL DatabaseGreenLake Subscription Model
HPE Database Modernization Status, Plans, Engagements
Partners Engaged:
HPE Database Modernization - Scoring
5
Assessment Modernization
Some of the factors include:− Total Number of User Databases− Total Number of Servers [P or V]− Average Number of SQL Instances− Total Number of Applications− % of Servers in Multiple Locations− % of Databases replicated in Multiple
Locations− % of Instances Clustered− % of Databases replicated in Local Site− Average Database Size [data, index, log]− Average number of User Database Objects− Average number of Users per Application− % of Applications with Embedded SQL
Mathematically generated WBS:The WBS Structure includes suggested task times [hours] Assessment through Migration and Delivery− Actual hours will vary based upon database size,
complexity and connected applications− Solution/IT – Model IT Collateral Generation
− ROM Costing – based upon local $$− SOW and Proposal − WBS and defacto Project Plan− Solution Decks
# Database + DB Complexity Score
Solution IT / Model IT Modeling- HPE Tooling -
HPE Database Modernization – Source/Target
6
Source Modernization
Assess, Design, Consolidate, Transform & Migrate:− Application [SQL usage - Conversion]− Conduct POC with tests / success criteria− Cap growth calculation and tier selection− Application and SQL transformation− Application Testing− Database Migration Groupings− Database upgrades− Storage Consolidation− Virtualization and Azure/AWS Provisioning− Load Balancing capability− High Availability [RAC - AlwaysOn]− System Management tools− Disaster Recovery− Production Roll-out− Follow-on Knowledge Transfer & Training
Down Level SQL Server
Oracle on Windows /
Linux
DB2 on Linux / Unix
Remediate and Convert expired or expiring SQL Versions− 2000 + 2005
− 2000, 2005, 2008/R2, 2012
− T-SQL compatibility
− Azure readiness
Convert and Transform Oracle Versions− 9i, 10g, 11i, 12
− PL/SQL conversion
− Code refactor / Re-plat
− OS services and Provisions
Convert and Transform [IBM] DB2 Versions− 10, 11.x +
− SQL conversion
− Code refactor / Re-plat
− OS services and Provisions
Target
PhysicalSQL ServerOraclePostgres/EDBPhysical Machine (raw iron)Windows and Linux
IaaSVirtualized MachinesSQL Server on Azure VMSQL Server on Azure StackSQL Server on AWSPostgres/EDB on Azure VMPostgres/EDB on AWS
VirtualSQL ServerOracle Postgres/EDBVirtualized Machine + ApplianceWindows and Linux
DBaaSVirtualized DatabaseAzure SQL DatabasePostgres/EDB on GreenLake
SyBase on Linux / Unix
Convert and Transform [SAP] SyBase Versions− 12, 15, 16
− T-SQL conversion
− Code refactor / Re-plat
− OS services and Provisions
HPE Database Modernization ServicesHPE Pointnext Consulting
7
Advise Consolidate & Migrate
Prepare your organization and environment− HPE Database Migration
Assessment Service − Gathers number of Databases,
Size, Complexity and Attached Applications
− Analyzes data− Categorizes and prioritizes
databases to be migrated − Sizes target platform− Executes Pilot Migration
Smooth migration and speedy consolidation− HPE Database Migration Service− Based upon required Assessment− Estimates driven by number of
Databases, Size, Complexity and Attached Applications
− Specifies Database Migrations− Prepares for Database Migrations− Executes Database Migrations
Operate
Proactive support and organizational readiness− Knowledge Transfer− HPE Proactive Care − Proactive Select Credits
− HPE Education Services− Customized IT Staff training− Technical training
HPE SQL Server Assessment & Modernization Tool Specifics
8
Service Delivery
Capture TOO
LS [AURA]
Project ManagementClient Questionnaire
Assessment Modernization
Microsoft and 3rd Party Tools− Identify Instances and Databases from Assessment data & move groups− Install and configure Double-Take with defined Powershell Automation− Test initial connectivity / trial migration− Execute monitored migration, with real time data synchronization− Verify database migrations, schedule and cut over applications
MAP, SSMA, HPE Discovery− MSFT MAP and SSMA install will be a prerequisite,
initial reports provided by Client− Support will include analysis and detailed reporting,
optionally set-up− HPE Discovery will be for Tier 4+ Engagements− HPE Discovery will require additional setup
Microsoft Migration Tools− Azure tools, SSMA and Upgrade Advisor to Prepare for Upgrades, analyze instances of
SQL Server− Distributed Replay Utility to Prepare for Upgrades, text and tune as necessary− Backup/Restore and Detach/Attach to migration whole databases− PowerShell & WMI Scripting to automate detailed tasks
WBS Baseline and IT Solution M
odel for ROM
− Design target platform and deploy− Define migration waves− Identify constraints and remediation
− Engage tooling and automation
− Schedule migration waves− Execute migration and verify
Transition to Support PlanIntegration &
New
Opportunities
Pursuit
HPE Database Consolidation and Migration – MSFT Bare Metal
9
Source Modernization Target
DW Packaged Custom
Relative Effort = Time + Cost + RiskApplications
MSFT Azure ServicesData FactoryVisual Studio Team ServicesApplication Insights
3rd Party ToolsVision Software Double Take / SQL Move
MSFT Traditional ToolsMSFT Analysis & Planning [MAP]SQL Server Migration Assistant [SSMA]SQL Server Integration Services [SSIS]Performance Monitor and SQL Trace
HPE Traditional ToolsHPE Discovery
MSFT ServicesSQL 2017 Database [traditional]StoreSimpleBackup
Paas & SaaSAzure SQL DatabaseVirtualized Database
MSFT Azure ServicesSQL Database [SQL Elastic database pool]
Down Level SQL
ServerOracle on Windows and Linux
DBMS
DB2 and SyBase
on Linux/Unix
HPE Database Consolidation and Migration – MSFT Private Cloud
10
Source Modernization
Down Level SQL
ServerOracle on Windows and Linux
Target
IaaSSQL Server in Azure Stack VMVirtualized MachinesDBMS
DW Packaged Custom
Relative Effort = Time + Cost + RiskApplications
MSFT Azure ServicesData FactoryVisual Studio Team ServicesApplication Insights
3rd Party ToolsVision Software Double Take / SQL Move
MSFT Traditional ToolsMSFT Analysis & Planning [MAP]SQL Server Migration Assistant [SSMA]SQL Server Integration Services [SSIS]Performance Monitor and SQL Trace
HPE Traditional ToolsHPE Discovery
MSFT Azure ServicesSQL 2017 Database [traditional]StoreSimpleBackup
Paas & SaaSAzure SQL DatabaseVirtualized Database
MSFT Azure ServicesSQL Database [SQL Elastic database pool]
DB2 and SyBase
on Linux/Unix
HPE Database Consolidation and Migration – MSFT Public Cloud
11
Source Modernization Target
IaaSSQL Server in Azure VMVirtualized Machines
Paas & SaaSAzure SQL DatabaseVirtualized Database
DW Packaged Custom
Relative Effort = Time + Cost + RiskApplications
MSFT Azure ServicesData FactoryVisual Studio Team ServicesApplication Insights
3rd Party ToolsVision Software Double Take / SQL Move
MSFT Traditional ToolsMSFT Analysis & Planning [MAP]SQL Server Migration Assistant [SSMA]SQL Server Integration Services [SSIS]Performance Monitor and SQL Trace
HPE Traditional ToolsHPE Discovery
MSFT Azure ServicesSQL DatabaseSQL Data WarehouseStoreSimpleBackup and Site Recovery
MSFT Azure ServicesSQL 2017 Database [traditional]Windows Virtual MachinesWindows Virtual Machine Scale SetsVirtual NetworksStoreSimpleBackupSite Recovery
Down Level SQL
ServerOracle on Windows and Linux
DBMS
DB2 and SyBase
on Linux/Unix
HPE Database SQL Cloud Readiness – MSFT Public Cloud
12
Source Modernization Target
IaaSSQL Server in Azure VMVirtualized Machines
Paas & SaaSAzure SQL DatabaseVirtualized Database
DW Packaged Custom
Relative Effort = Time + Cost + RiskApplications
MSFT Azure ServicesData FactoryVisual Studio Team ServicesApplication Insights
MSFT Traditional ToolsMSFT Analysis & Planning [MAP]SQL Server Migration Assistant [SSMA]SQL Server Integration Services [SSIS]Performance Monitor and SQL Trace
MSFT Azure ServicesSQL Database
MSFT Azure ServicesSQL 2017 Database [traditional]
3rd Party ToolsVision Software Double Take / SQL Move
Down Level SQL
ServerOracle on Windows and Linux
DBMS
DB2 and SyBase
on Linux/Unix
HPE Database SQL Cloud Performance – MSFT Public Cloud
13
Environments Performance Tuning Target
IaaSSQL Server in Azure VMVirtualized Machines
Paas & SaaSAzure SQL DatabaseVirtualized Database
DW Packaged Custom
Relative Effort = Time + Cost + RiskApplications
MSFT Azure ServicesApplication InsightsLog AnalyticsAzure MonitorAzure Resource Manager
MSFT Traditional ToolsMSFT Analysis & Planning [MAP]SQL Server Migration Assistant [SSMA]
MSFT Azure ServicesSQL DatabaseSQL Data WarehouseStoreSimpleBackup and Site Recovery
MSFT Azure ServicesSQL 2017 Database [traditional]Windows Virtual MachinesWindows Virtual Machine Scale SetsVirtual NetworksStoreSimpleBackup and Site Recovery
Down Level SQL
ServerOracle on Windows and Linux
DBMS
DB2 and SyBase
on Linux/Unix