Progress Open Edge MDBA Services 1 2016 Progress
Progress Open. Edge MDBA Services 1 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution – On Premise Benefits • • • You have control of the application and data Tried and True Infrastructure exists already Drawbacks • • Need to maintain Infrastructure • May be difficult to find talent Need to have resources to maintain the application and data 2 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution - Cloud Benefits • • Lower cost than on-premise No longer need to worry about Infrastructure No longer need to find talent A growing trend Drawbacks • • • Data Security WAN Infrastructure Fear Uncertainty and Doubt (FUD) 3 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Fear Uncertainty and Doubt 4 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution 5 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution Benefits • • • You have control of the application and data Tried and True Infrastructure exists already No need to find talent Lower cost than traditional on-premise Drawbacks • Need to maintain Infrastructure 6 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Managed Database Administration § Software based solution § On-boarding Service • Sampling and monitoring software installed • Install the management software • Sends email alerts to on-call DBA • Document the environment • Each database has it’s own thresholds • Make stability and tuning recommendations § Each customer has a Primary DBA • A Mini DB Health Check • Clear documentation for on-call rotation § Web based monitoring dashboard § On-call § Monthly Reports • No level 1 support – DBA Team is on-call All for a value-based monthly Subscription 7 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
What the service includes § § Included • Any Reactive Service for business critical issues – Normal billing rates start after the 1 st hour • Web Based Dashboard • Proactive Analysis • Monthly Reports Not Included • • • Planned Maintenance Non-production Issues Project work Database Health Checks Disaster Recovery – Provide 6 month trend – Capacity planning forecast for next 6 month period – Identifies upcoming maintenance items • Technical Advice 8 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
The Heartbeat Process mfgprod admprod Heartbeat process runs every minute Thresholds are tested and alerts are sent out to the team by email Appserver Monitoring cusprod Daily upload of metrics to PSC for Dashboards and Reporting Webspeed hipprod Periodic Sampling Every 15 minutes Monitoring 9 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
The Managed Database Services Team § 17 DBAs worldwide, each with 25+ years of experience § Follow the Sun support • US Support – 9 DBAs, a mix of developers of the Open. Edge technology and support staff. • Australia Support 95% of surveyed businesses using Progress Managed DBA describe the knowledge and experience of their – 3 former PSC Tech. Support reps Progress consultants as really great or • EMEA Support “off the charts amazing!” – 5 former PSC Tech. Support reps 10 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Customers Managed Database Metrics 140 120 100 80 60 40 20 Started in 2006 0 2009 Customers Number of Databases Total Database Size Total Connected Users 2010 2011 2012 2013 2014 140+ 2000+ 114+Terabytes 175, 000+ Metrics as of September 1, 2018 11 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 2015 2016 2017 2018
Managed Database Dashboard § Provides database performance metrics • Holds 2 years of data § Helps pinpoint Application Issue § Helps for Proactive Maintenance § Self Service Portal 12 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
13 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Progress MDBA Customers MANUFACTURING Direct Customers and End-users of Application Partners WAREHOUSING & DISTRIBUTION HEALTHCARE 14 FINANCIAL SERVICES © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Database Health Checks § Comprehensive look at the application environment • Collect performance metrics for 24 hours or more • Machine configuration and speed of various components • Database configuration • App. Server and Web. Speed configuration • Client configuration § DB Health Check Report • Comprehensive – 30+ page reports • Shows key metrics and graphs • Value based recommendations 15 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Disaster Recovery Planning § Create a DR strategy for your Open. Edge database § Built on the knowledge from the MDBA Service § Database experts provide the know-how to ensure continuous service and availability with zero latency § Uses Open. Edge Replication and Replication Plus § Flexible, affordable and specifically designed to support your Progress-based systems § Fail-over and Fail-back, then document step-by-step How-To! 16 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Database Consulting § § DBA team is available for database projects § Platform Migration • We do this once a month for a customer § Dump and Loads • We do this every weekend Open. Edge Feature Implementation • Open. Edge Management • Open. Edge Auditing • Transparent Data Encryption • Table Partitioning • Open. Edge Replication • Open. Edge Multi-tenancy • Open. Edge SSL § Open. Edge Version Upgrades 17 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
MDBA Services § Comprehensive Database Management • Extension of the existing team • Alerting, Trending, Planning § Database Health Checks • Complete Analysis • Educational § Largest and Strongest team in the industry • Includes follow the sun support www. progress. com/mdba 18 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
19 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
- Slides: 19