Database Analyzer

Analyzer: Database

The Database Analyzer provides a comprehensive overview of database environments, including RDS, DynamoDB, Aurora, and Redshift. It empowers IT Operations (IT Ops) and Security Operations (Sec Ops) engineers with critical insights for optimizing database performance, ensuring security, and maintaining compliance.

• Security Perspective: Identifies potential risks such as excessive permissions, misconfigurations, or vulnerabilities in database structures.

• Compliance Perspective: Ensures database configurations adhere to regulatory requirements and internal governance standards.

• Operational Observability: Delivers actionable insights into usage trends, performance metrics, and data growth patterns, enabling efficient resource allocation and proactive troubleshooting.

This Analyzer improves workflow efficiency by offering a clear view of database health, helping engineers make informed decisions with minimal manual effort.

Sightline: Databases

The Databases sightline provides a high-level overview of all databases, offering insights into usage, capacity, and structural trends. It helps IT Ops and Sec Ops engineers monitor growth, optimize storage, and detect anomalies across the database ecosystem.

Widgets:

• Database Count Stat Card

• Database Size Stat Card

• Database Schemas Count Stat Card

• Database Tables Trend Chart

• Database Records Trend Chart

Sightline: Tables

The Tables sightline focuses on table-level metrics, enabling engineers to assess table usage, identify underutilized resources, and track trends. This sightline is particularly valuable for optimizing database design and ensuring efficient data organization.

Widgets:

• Database Tables Stat Card

• Empty Database Tables Stat Card

• Total Records Stat Card

• Tables Size Trend Chart

• Tables Record Trend Chart

• Table Index Size Trend Chart

Sightline: Views

The Views sightline focuses on view-level metrics, allowing engineers to analyze view performance, monitor dependencies, and optimize query efficiency. This sightline is especially useful for identifying redundant or costly views and ensuring streamlined data retrieval.

Widgets:

• All Views

• Materialized Views

• Non Materialized Views

• Nested Views

• Pie Chart for Different views

Sightline: Users

The Users sightline highlights database user activity and permissions. It helps Sec Ops monitor access control and IT Ops manage database ownership and schema access.

Widgets:

• Admin Users Stat Card

• Database Owners Stat Card

• Table Owners Stat Card

• Users With Schema Access Stat Card

• All Database Users Count Bar Chart

Alerts

Count of Nested Views

The Count of Nested Views alert identifies databases with excessive nested views, which can degrade query performance and increase maintenance complexity. For IT Ops, this helps optimize query execution, while Sec Ops can use it to investigate potential misuse or unintended dependencies.

---

Count of Empty Tables

The Count of Empty Tables alert highlights databases containing empty tables, indicating possible design inefficiencies or unused resources. IT Ops can address these to improve resource allocation, while Sec Ops can assess whether such tables pose any security risks or compliance gaps.