Database Health Check Script

Create a health check script for this database:

**Database System:** {{DATABASE_SYSTEM}}
**Key Metrics to Monitor:**
{{METRICS}}

**Alert Thresholds:** {{THRESHOLDS}}
**Monitoring Frequency:** {{FREQUENCY}}
**Integration Requirements:** {{INTEGRATIONS}}

Please provide:
1. Health check queries for:
   - Connection status
   - Disk space usage
   - Long-running queries
   - Lock contention
   - Replication lag
   - Index health
   - Buffer/cache hit ratios
2. Complete monitoring script
3. Alert condition definitions
4. Dashboard metrics recommendations
5. Historical data collection
6. Automated remediation scripts
7. Notification setup
8. Baseline establishment
9. Capacity planning queries