Query Checkup
Managing development SQL quality is the first step in preventing DB performance failures.
A developer's focus on SQL quality improves App performance, satisfies users, and strengthens corporate competitiveness.
Integrated SQL Quality & Performance Inspection | Optimization & Control Solution
"Preemptive DB Performance Failure Prevention via Automated SQL Quality/Performance Management"
Gain a single-pane view of the quality status across all SQL under development or running in operational DBs
Quality
Blocking non-compliant SQL version registration (Commit)
Performance
Controlling production deployment of underperforming SQL
Real-Time Self-Inspection
Instant real-time quality/performance checks via IDE Plug-ins like Eclipse
Quality Index Quantification
Quantifying SQL compliance by rule, project, and developer for sustainable governance
40+ Quality Rules
Inspecting 40+ rules covering performance degradation, errors, and maintainability
Source-Level Non-Compliant SQL Control
Blocking sub-standard SQL Commits via IDE Plug-in and controlling deployment-time non-compliant SQL
“Query Checkup”, you can start building high-quality SQL and high-performance DBs.
SQL Quality & Performance Inspection Concept
SQL
Quality
Quality Inspection Items (40+)
Performance degradation factors / Error-prone factors / Maintainability degradation factors
Quality Inspection Method 1
Eclipse-based
SQL quality
Self-inspection
Quality Inspection Method 2
Batch quality inspection for execution & configuration SQL
Quality Inspection Method 3
Automated quality inspection upon development SQL Commit
SQL
Performance
Performance Inspection Metrics
SQL execution time, Block count / Memory usage, processed rows / Full Partition Access / Large Table Full Scan
Development Stage Inspection
Eclipse-based SQL performance Self-inspection
Deployment Stage Verification
Performance verification for completed & deployment-requested SQL
Operation Stage Inspection
Automated extraction of potential failure SQL & Tuning target SQL
SQL Quality & Performance Control Governance
Eclipse (Commit)
Developer
Production DB
Phase 1 Control
SQL Quality
Configuration Management (SM/SI)
SQL Quality
Block Non-Compliant SQL Registration
Phase 2 Control
SQL Performance
SQL Performance
Restrict Deployment of Underperforming SQL
SQL Performance Optimization Support
Performance Analysis
Module Analysis / PL/SQL Analysis
AWR-Based Analysis / Identifier-Based Analysis
New SQL / Key SQL / TOP SQL
Object Change / Related SQL / Performance Analysis
SQL Performance Degradation / Prediction & Analysis
Performance Improvement
Developer Tuning Request
Auto-Selection of Target SQL
SQL Tuning
Progress Management
Tuning SQL
History Tracking
SQL Tuning
Performance Tracking
Plan Management
Plan-Changed SQLReal-Time Alert
Underperforming SQL
Real-time Alert
One Click
Plan Optimization
SQL Profile &
Plan Baseline Management