Introducing Postgres Enterprise Manager 5.0

Introducing Postgres Enterprise Manager 5.0

• 1.
  © 2015 EnterpriseDBCorporation. All rights reserved. 1 Introducing Postgres Enterprise Manager 5.0 To view the recording of this presentation visit EnterpriseDB > Resources > Webcasts > On Demand Webcasts
• 2.
  © 2015 EnterpriseDBCorporation. All rights reserved. 2 •  EnterpriseDB Overview •  Postgres Enterprise Manager Overview •  Highlights of What’s New in PEM 5.0 −  Enhanced Alerting −  Log Analysis Expert −  Custom Probes −  Auto-Discovery of Managed Servers −  Remote Monitoring Agenda
• 3.
  © 2015 EnterpriseDBCorporation. All rights reserved. 3 POSTGRES innovation ENTERPRISE reliability 24/7 support Services & training Enterprise-class features, tools & compatibility Indemnification Product road-map Control Thousands of developers Fast development cycles Low cost No vendor lock-in Advanced features Enabling commercial adoption of Postgres
• 4.
  © 2015 EnterpriseDBCorporation. All rights reserved. 4 The Database PostgreSQL / Postgres Plus Advanced Server Tools xDB Replication Server Failover Manager Management and Monitoring Back and Recovery Tool Postgres Enterprise Management (PEM) Stack Builder & Update Monitor Cloud Enablement Cloud Database for Amazon Web Services Open Stack Support* Core OR PostgreSQL Postgres Plus Advanced Server Extension Components (PostGIS, pgPool, pgBouncer, SQL/Protect, PL/Perl Python TCL, FDW) Connectors (.Net, JDBC, ODBC,OCL) Utilities (EDBLoader, EDBPlus, ECPGPlus) Migration Tool Kit * Roadmap EnterpriseDB Product Overview APIs to enable the Platform as a Service*
• 5.
  © 2015 EnterpriseDBCorporation. All rights reserved. 5 EDB is a Gartner Magic Quadrant Leader
• 6.
  © 2015 EnterpriseDBCorporation. All rights reserved. 6 •  Single management console allows easy visual control •  Works with both PostgreSQL and Postgres Plus •  Start/stop, configure, define and manage storage, security and database objects via single graphical console MONITOR MANAGE TUNE Only solution available that combines all three tasks into one tool EDB Postgres Enterprise Manager (PEM)
• 7.
  © 2015 EnterpriseDBCorporation. All rights reserved. 7 Unmanaged Hosts An efficient distributed architecture perfectly suited for managing, monitoring and tuning large numbers of Postgres servers in multiple locations Monitoring Data Enterprise Management Connections PEM Clients or Web Clients Managed Hosts with PEM Agents Enterprise Manager Agent Installed on each managed machine; collects data on OS and database health and operations PEM Server Enterprise Manager Server Centralized storage for agent- collected data and client dashboards Host Database Management Connection Enterprise Manager Clients User GUI console with global at-a- glance monitoring dashboards; used to carry out centralized database administration and tuning Platform-specific and web clients POSTGRES ENTERPRISE MANAGER (PEM) EDB
• 8.
  © 2015 EnterpriseDBCorporation. All rights reserved. 8 Monitor All Your Postgres Databases From One Screen •  Customized global dashboard •  View up/down status of all agents •  Monitor alerts from many servers in one place •  Navigate to Dashboards for further analysis
• 9.
  © 2015 EnterpriseDBCorporation. All rights reserved. 9 Predefined (225+) and custom alerts via SMTP or SNMP Predefined & customized at-a-glance dashboards OS and database statistics collection Replication monitoring MONITOR TUNEMANAGE CRUD operations on all database objects Bulk operations across multiple servers Capacity Manager to plan & forecast Customizable GUI charts, tables & graphs Log Manager and Audit Manager to configure database metric collection SQL/Profiler to speed up large workloads Index Advisor to suggest and create indexes Postgres Expert for best practice enforcement Tuning Wizard for machine utilization and load profiles No Other Tool Provides Much Visibility Into your Postgres Databases
• 10.
  © 2015 EnterpriseDBCorporation. All rights reserved. 10 Highlights of PEM 5.0 •  Alert Level Specific Notifications •  Log Analysis Expert •  Custom Probes •  Auto-Discovery of Managed Servers •  Remote Monitoring •  Download Tuning Recommendations •  Log OS Metrics for Backend Server Processes •  Better Zooming and Granularity Control •  Cross Server Charts •  Monitor Streaming Replication Ease Of Use Richer Dashboards
• 11.
  © 2015 EnterpriseDBCorporation. All rights reserved. 11 Model your Support Staff Rotation in PEM for Email Alerting •  Decide who is externally notified of alerts by creating the email groups. •  Define different email envelope information, depending on time of day.
• 12.
  © 2015 EnterpriseDBCorporation. All rights reserved. 12 Automate Notification or Actions on over 225 Predefined or Customizable Alerts (1 of 2) •  Create and manage alerts •  Examples – running low on disk space, server down, last vacuum, total table bloat, etc. •  Set the low, medium and high threshold
• 13.
  © 2015 EnterpriseDBCorporation. All rights reserved. 13 Automate Notification or Actions on over 225 Predefined or Customizable Alerts (2 of 2) •  Choose when and who to send email notifications to. •  Decide when to send SNMP traps •  Further execute any external script.
• 14.
  © 2015 EnterpriseDBCorporation. All rights reserved. 14 •  Generate reports on stats like locks and queries that are collected by the Log Manager •  Collects information based on historical csv data, not dependent on live logs. •  First configure Log Manager to enable collection of log files. •  Once you have logs collected, use the Log Analysis Expert to select which reports to generate •  More details in the ‘Log Analysis Expert’ section of the Online Help Better Understand Database Activities with Log Analysis Expert
• 15.
  © 2015 EnterpriseDBCorporation. All rights reserved. 15 Gather Any Custom Information You Want With Custom Probes (1 of 3) •  Probes are used to gather metrics for alerts and dashboard charts. •  View all System Probes. •  Add New or Modify existing probes to suit your needs.
• 16.
  © 2015 EnterpriseDBCorporation. All rights reserved. 16 Gather Any Custom Information You Want With Custom Probes (2 of 3) •  Define the columns that will be used to store the data collected. •  If ‘Graphable’, the column will be available on Charts and Capacity Manager. •  Control if the metric is Point In Time or Cumulative
• 17.
  © 2015 EnterpriseDBCorporation. All rights reserved. 17 Gather Any Custom Information You Want With Custom Probes (3 of 3) •  If this is a SQL Probe, enter the SQL SELECT statement to be executed by the probe in the Code tab. •  If this is a Batch probe, enter the shell or .bat script to be invoked by the probe.
• 18.
  © 2015 EnterpriseDBCorporation. All rights reserved. 18 •  Locate databases that reside on servers with Agents installed on them. •  After you install agents −  Select them in the tree and choose Management -> Auto Discovery to open the dialog shown. −  Then select the database server to have the server property fields filled in •  More details in the ‘Automatic Discovery of Server’ section of the Online Help Auto Discovery of Managed Servers For Easier Deployment
• 19.
  © 2015 EnterpriseDBCorporation. All rights reserved. 19 •  Allow remote monitoring of servers (without installing agents using direct JDBC connections), from the agent running on the PEM server −  Ignores OS level stats, disables features like Server Startup, Audit/Log/Capacity Manager, Tuning/ Deployment Wizard •  Create Server and select Remote monitoring in PEM Agent Tab. Remote Monitoring
• 20.
  © 2015 EnterpriseDBCorporation. All rights reserved. 20 Feature Benefit Audience Motivation Alert Controls Control who gets which alerts depending on severity and time of day / day of week. DBAs Ease of Use Log Analysis Expert Better understanding the operations that occur in your database. DBAs Ease of Use Custom Probes Get whatever custom information you want from your databases or servers; pull in BART or EFM status information DBAs Compatibility Auto-discovery of Managed Servers Given an IP address, will find all managed database servers on that machine. DBAs Ease of Use Remote Monitoring Monitor servers without installing agents using direct connections. DBAs Ease of Use Log OS Metrics for Backend Server Processes New probe that capture memory and CPU alongside process information DBAs Compatibility Improved Dashboards (Better zooming / granularity control, cross server charts) Compare metrics, More accurate and relevant information when zooming in and out of charts DBAs Ease of Use Recap: Main Feature/Benefits for this Release
• 21.
  © 2015 EnterpriseDBCorporation. All rights reserved. 21 How can I learn more? •  Download Postgres Enterprise Manager: •  http://www.enterprisedb.com/download-postgres-enterprise- manager •  General Information: •  http://www.enterprisedb.com/postgres-enterprise-manager •  Contact Us: •  sales@enterprisedb.com