Discover how to centrally monitor, diagnose, and report on open source databases alongside SQL Server, Oracle, and DB2 deployments in this 56-minute conference talk from the PASS Data Community Summit. Learn about the challenges of managing diverse database environments, explore the responsibilities of a modern DBA, and see a comprehensive demo showcasing tools for unified database management. Gain insights into query performance analysis, dimensional analysis, comparison techniques, core monitoring capabilities, baselining, and consistent diagnostics across different database platforms. Explore platform-specific views and network flow analysis to enhance your database management skills.
Overview
Syllabus
Introduction
Daves Story
Sequel Server Sprawl
Open Source Technologies
What is a DBA responsible for
Should monitoring help
How does Dave do it
What if you arent using opensource
Demo Overview
Demo Walkthrough
Query Performance
Dimensional Analysis
Comparison
Core Capabilities
Baselining
Consistent Diagnostics
Postgres Diagnostics
Network Flow
Platform Specific Views
More Information
Questions
Taught by
PASS Data Community Summit
