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.
Progress MDBA Database Administration With Peace of Mind Comprehensive database expertise at your service from the people who helped build it. 2 © 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 3 © 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 4 © 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 5 © 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 FUD 6 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution 7 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
Operation Evolution 8 © 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 9 © 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 10 © 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 • Monthly Reports – Provide 6 month trend – Capacity planning forecast for next 6 month period – Identifies upcoming maintenance items Not Included • • • Planned Maintenance Non-production Issues Project work Database Health Checks Disaster Recovery QAD Specific – Browses – Process Improvements – Customizations – NETUI Configurations – Upgrades and Migrations – CIM Loaads • Technical Advice • QAD Specific – Printer Management – User Management – Generalized Codes 11 © 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 12 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
The Managed Database Services Team § 14 DBAs worldwide, each with 20+ years of experience § Follow the Sun support • US Support – 7 DBAs, a mix of developers of the Open. Edge technology and support staff. • Australia Support 95% of surveyed businesses using Progress Managed DBA describe – 3 former PSC Tech. Support reps • EMEA Support the knowledge and experience of their Progress consultants as really great or – 4 former PSC Tech. Support reps “off the charts amazing!” 13 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.
QAD Services § 40 QAD Consultants Worldwide • Hand Picked Team • 18 years QAD experience on average § § § First Accredited Consulting Partner § QAD Consultanting Partner of the Year Implementations Conversions EDI QAD Addon Modules § QAD Certified Professionals § APICS Certified Professionals § Global Alliance Partner 14 © 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 120+ 1, 900+ 100+Terabytes 165, 000+ Metrics as of September 20, 2017 15 © 2016 Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved. 2014 2015 2016 2017
Progress MDBA Customers MANUFACTURING Direct Customers and End-users of Application Partners WAREHOUSING & DISTRIBUTION HEALTHCARE 16 FINANCIAL SERVICES © 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 Version Upgrades 17 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 • etc © 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