Database Management Guide
Learn how to monitor and manage the availability of various database instances registered on the GIIP platform.
📋 Overview
The Database Management menu integrates and manages the status of DB instances that hold your core service data. It supports various engines like Azure SQL, on-premise MSSQL, and MySQL, allowing you to proactively detect performance degradation or failures.
🔍 Key Features
1. Instance Monitoring
- Real-time Status: Visualizes DB activity, CPU usage, memory utilization, and disk space.
- Connection Count: Monitor the number of sessions currently connected to the DB to prevent connection pool exhaustion.
2. Performance Analysis & Query Optimization
- Slow Query Detection: Automatically extracts long-running queries and sends notifications to developers.
- Execution Plan Checks: Analyzes execution plans for specific SQL statements and provides index optimization suggestions.
3. Backup & Availability Verification
- Last Backup Time: Verifies if regular backups were performed successfully.
- HA Status: Checks replication or mirroring status to evaluate the risk of data loss.
🛠️ Management Steps
- Navigate to the GIIP [Infrastructure Management] > [Database Management] menu.
- Click the DB instance you want to manage from the list.
- Check performance metrics in the [Metrics] tab and analyze currently running queries in the [Queries] tab.
💡 Tips
- Threshold Alerts: Set Slack alerts for when DB CPU exceeds 80% to respond proactively.
- Rightsizing: Refer to AI-driven cost optimization reports to reduce costs by downsizing over-configured DB specs relative to actual usage.
API Reference
For detailed API specifications of this feature, refer to the separate guide.
Version: 1.0 Last Updated: 2026-03-19 Source:
giipv3/public/help/database-management.en.md