Analytics — Unified Database Health
Consolidated metrics across MSSQL, Oracle and Postgres. Select a data center to drill into engine-specific signals.
Total servers
44
across all DCs
Databases online
66
online / offline: 66 / 1
Backups (24h)
18
6 failed
Open alerts
5
SLA breaches: 1
Unified Metrics by Category
Aggregated across engines
Availability & Topology
Servers online/offline, instances up, replicas/standby synchronization, LDAP/AD auth health.
Backups & Recovery
Backup success/failure counts, average duration, last successful backup timestamp, restore readiness.
Replication & Shipping
WAL / archive log shipping lag, replica apply lag, transaction log transfer metrics.
Performance Signals
Query latency percentiles, slow query counts, top N offending queries, buffer/cache hit ratios.
Resource Pressure
CPU, memory pressure, temp tablespace/tempdb usage, file system utilization and IO queue depth.
Locking & Waits
Deadlocks count, blocking chains, engine-specific wait categories (CXPACKET, latch, buffer busy, etc.).
Configuration & Integrity
Schema drift detection, index fragmentation/bloat, statistics freshness, autovacuum/maintenance status.
Security & Authentication
Failed auth attempts, LDAP/AD reachability, certificate expiry warnings, privileged changes.
Engine Snapshot (selected DC)
MSSQL
metrics: 15
- Total servers8
- Databases online12
- Databases offline0
- Backups succeeded6
- Backups failed0
- SLA breach count0
- Open transactions > 5m0
- Slow queries (p95 > 1s)2
- Replication lag (s)14
- Avg query latency ms (p50)20
- Active connections80
- Buffer/Cache hit ratio %90
- Temp space used %10
- Failed auth attempts (24h)4
- Disk used %55
Oracle
metrics: 15
- Total servers9
- Databases online14
- Databases offline0
- Backups succeeded7
- Backups failed0
- SLA breach count0
- Open transactions > 5m5
- Slow queries (p95 > 1s)0
- Replication lag (s)16
- Avg query latency ms (p50)25
- Active connections90
- Buffer/Cache hit ratio %90
- Temp space used %10
- Failed auth attempts (24h)3
- Disk used %58
Postgres
metrics: 15
- Total servers10
- Databases online16
- Databases offline0
- Backups succeeded8
- Backups failed0
- SLA breach count0
- Open transactions > 5m0
- Slow queries (p95 > 1s)10
- Replication lag (s)15
- Avg query latency ms (p50)30
- Active connections100
- Buffer/Cache hit ratio %90
- Temp space used %10
- Failed auth attempts (24h)3
- Disk used %61
Detailed Metrics — by Data Center & Engine
Snapshot time: 2026-10-14T03:55:16.838Z
| DC | Engine | Metric | Value | Status | Hint |
|---|---|---|---|---|---|
| Global | MSSQL | Total servers | 8 | ok | physical & virtual |
| Global | MSSQL | Databases online | 12 | ok | - |
| Global | MSSQL | Databases offline | 0 | ok | - |
| Global | MSSQL | Backups succeeded | 6 | ok | - |
| Global | MSSQL | Backups failed | 0 | ok | - |
| Global | MSSQL | SLA breach count | 0 | ok | - |
| Global | MSSQL | Open transactions > 5m | 0 | warn | - |
| Global | MSSQL | Slow queries (p95 > 1s) | 2 | warn | - |
| Global | MSSQL | Replication lag (s) | 14 | ok | - |
| Global | MSSQL | Avg query latency ms (p50) | 20 | ok | - |
| Global | MSSQL | Active connections | 80 | ok | - |
| Global | MSSQL | Buffer/Cache hit ratio % | 90 | ok | - |
| Global | MSSQL | Temp space used % | 10 | ok | - |
| Global | MSSQL | Failed auth attempts (24h) | 4 | ok | - |
| Global | MSSQL | Disk used % | 55 | ok | - |
| Global | Oracle | Total servers | 9 | ok | physical & virtual |
| Global | Oracle | Databases online | 14 | ok | - |
| Global | Oracle | Databases offline | 0 | ok | - |
| Global | Oracle | Backups succeeded | 7 | ok | - |
| Global | Oracle | Backups failed | 0 | ok | - |
| Global | Oracle | SLA breach count | 0 | ok | - |
| Global | Oracle | Open transactions > 5m | 5 | warn | - |
| Global | Oracle | Slow queries (p95 > 1s) | 0 | warn | - |
| Global | Oracle | Replication lag (s) | 16 | ok | - |
| Global | Oracle | Avg query latency ms (p50) | 25 | ok | - |
| Global | Oracle | Active connections | 90 | ok | - |
| Global | Oracle | Buffer/Cache hit ratio % | 90 | ok | - |
| Global | Oracle | Temp space used % | 10 | ok | - |
| Global | Oracle | Failed auth attempts (24h) | 3 | ok | - |
| Global | Oracle | Disk used % | 58 | ok | - |
| Global | Postgres | Total servers | 10 | ok | physical & virtual |
| Global | Postgres | Databases online | 16 | ok | - |
| Global | Postgres | Databases offline | 0 | ok | - |
| Global | Postgres | Backups succeeded | 8 | ok | - |
| Global | Postgres | Backups failed | 0 | ok | - |
| Global | Postgres | SLA breach count | 0 | ok | - |
| Global | Postgres | Open transactions > 5m | 0 | warn | - |
| Global | Postgres | Slow queries (p95 > 1s) | 10 | warn | - |
| Global | Postgres | Replication lag (s) | 15 | ok | - |
| Global | Postgres | Avg query latency ms (p50) | 30 | ok | - |
| Global | Postgres | Active connections | 100 | ok | - |
| Global | Postgres | Buffer/Cache hit ratio % | 90 | ok | - |
| Global | Postgres | Temp space used % | 10 | ok | - |
| Global | Postgres | Failed auth attempts (24h) | 3 | ok | - |
| Global | Postgres | Disk used % | 61 | ok | - |
| Houston (DC‑1) | MSSQL | Total servers | 10 | ok | physical & virtual |
| Houston (DC‑1) | MSSQL | Databases online | 15 | ok | - |
| Houston (DC‑1) | MSSQL | Databases offline | 0 | ok | - |
| Houston (DC‑1) | MSSQL | Backups succeeded | 5 | warn | - |
| Houston (DC‑1) | MSSQL | Backups failed | 1 | warn | - |
| Houston (DC‑1) | MSSQL | SLA breach count | 1 | critical | - |
| Houston (DC‑1) | MSSQL | Open transactions > 5m | 2 | warn | - |
| Houston (DC‑1) | MSSQL | Slow queries (p95 > 1s) | 5 | warn | - |
| Houston (DC‑1) | MSSQL | Replication lag (s) | 14 | ok | - |
| Houston (DC‑1) | MSSQL | Avg query latency ms (p50) | 30 | ok | - |
| Houston (DC‑1) | MSSQL | Active connections | 120 | ok | - |
| Houston (DC‑1) | MSSQL | Buffer/Cache hit ratio % | 87 | ok | - |
| Houston (DC‑1) | MSSQL | Temp space used % | 25 | ok | - |
| Houston (DC‑1) | MSSQL | Failed auth attempts (24h) | 1 | ok | - |
| Houston (DC‑1) | MSSQL | Disk used % | 63 | ok | - |
| Houston (DC‑1) | Oracle | Total servers | 11 | ok | physical & virtual |
| Houston (DC‑1) | Oracle | Databases online | 17 | ok | - |
| Houston (DC‑1) | Oracle | Databases offline | 1 | ok | - |
| Houston (DC‑1) | Oracle | Backups succeeded | 6 | ok | - |
| Houston (DC‑1) | Oracle | Backups failed | 0 | ok | - |
| Houston (DC‑1) | Oracle | SLA breach count | 0 | ok | - |
| Houston (DC‑1) | Oracle | Open transactions > 5m | 3 | warn | - |
| Houston (DC‑1) | Oracle | Slow queries (p95 > 1s) | 6 | warn | - |
| Houston (DC‑1) | Oracle | Replication lag (s) | 2 | ok | - |
| Houston (DC‑1) | Oracle | Avg query latency ms (p50) | 35 | ok | - |
| Houston (DC‑1) | Oracle | Active connections | 130 | ok | - |
| Houston (DC‑1) | Oracle | Buffer/Cache hit ratio % | 87 | ok | - |
| Houston (DC‑1) | Oracle | Temp space used % | 25 | ok | - |
| Houston (DC‑1) | Oracle | Failed auth attempts (24h) | 3 | ok | - |
| Houston (DC‑1) | Oracle | Disk used % | 66 | ok | - |
| Houston (DC‑1) | Postgres | Total servers | 12 | ok | physical & virtual |
| Houston (DC‑1) | Postgres | Databases online | 19 | ok | - |
| Houston (DC‑1) | Postgres | Databases offline | 0 | ok | - |
| Houston (DC‑1) | Postgres | Backups succeeded | 7 | ok | - |
| Houston (DC‑1) | Postgres | Backups failed | 0 | ok | - |
| Houston (DC‑1) | Postgres | SLA breach count | 0 | ok | - |
| Houston (DC‑1) | Postgres | Open transactions > 5m | 3 | warn | - |
| Houston (DC‑1) | Postgres | Slow queries (p95 > 1s) | 1 | warn | - |
| Houston (DC‑1) | Postgres | Replication lag (s) | 15 | ok | - |
| Houston (DC‑1) | Postgres | Avg query latency ms (p50) | 40 | ok | - |
| Houston (DC‑1) | Postgres | Active connections | 140 | ok | - |
| Houston (DC‑1) | Postgres | Buffer/Cache hit ratio % | 87 | ok | - |
| Houston (DC‑1) | Postgres | Temp space used % | 25 | ok | - |
| Houston (DC‑1) | Postgres | Failed auth attempts (24h) | 2 | ok | - |
| Houston (DC‑1) | Postgres | Disk used % | 69 | ok | - |
| Virginia (DC‑2) | MSSQL | Total servers | 12 | ok | physical & virtual |
| Virginia (DC‑2) | MSSQL | Databases online | 18 | ok | - |
| Virginia (DC‑2) | MSSQL | Databases offline | 0 | ok | - |
| Virginia (DC‑2) | MSSQL | Backups succeeded | 4 | warn | - |
| Virginia (DC‑2) | MSSQL | Backups failed | 2 | warn | - |
| Virginia (DC‑2) | MSSQL | SLA breach count | 0 | ok | - |
| Virginia (DC‑2) | MSSQL | Open transactions > 5m | 3 | warn | - |
| Virginia (DC‑2) | MSSQL | Slow queries (p95 > 1s) | 1 | warn | - |
| Virginia (DC‑2) | MSSQL | Replication lag (s) | 22 | critical | - |
| Virginia (DC‑2) | MSSQL | Avg query latency ms (p50) | 40 | ok | - |
| Virginia (DC‑2) | MSSQL | Active connections | 160 | ok | - |
| Virginia (DC‑2) | MSSQL | Buffer/Cache hit ratio % | 84 | ok | - |
| Virginia (DC‑2) | MSSQL | Temp space used % | 40 | warn | - |
| Virginia (DC‑2) | MSSQL | Failed auth attempts (24h) | 2 | ok | - |
| Virginia (DC‑2) | MSSQL | Disk used % | 71 | ok | - |
| Virginia (DC‑2) | Oracle | Total servers | 13 | ok | physical & virtual |
| Virginia (DC‑2) | Oracle | Databases online | 20 | ok | - |
| Virginia (DC‑2) | Oracle | Databases offline | 0 | ok | - |
| Virginia (DC‑2) | Oracle | Backups succeeded | 5 | warn | - |
| Virginia (DC‑2) | Oracle | Backups failed | 1 | warn | - |
| Virginia (DC‑2) | Oracle | SLA breach count | 0 | ok | - |
| Virginia (DC‑2) | Oracle | Open transactions > 5m | 4 | warn | - |
| Virginia (DC‑2) | Oracle | Slow queries (p95 > 1s) | 7 | warn | - |
| Virginia (DC‑2) | Oracle | Replication lag (s) | 99 | critical | - |
| Virginia (DC‑2) | Oracle | Avg query latency ms (p50) | 45 | ok | - |
| Virginia (DC‑2) | Oracle | Active connections | 170 | ok | - |
| Virginia (DC‑2) | Oracle | Buffer/Cache hit ratio % | 84 | ok | - |
| Virginia (DC‑2) | Oracle | Temp space used % | 40 | warn | - |
| Virginia (DC‑2) | Oracle | Failed auth attempts (24h) | 0 | ok | - |
| Virginia (DC‑2) | Oracle | Disk used % | 74 | ok | - |
| Virginia (DC‑2) | Postgres | Total servers | 14 | ok | physical & virtual |
| Virginia (DC‑2) | Postgres | Databases online | 22 | ok | - |
| Virginia (DC‑2) | Postgres | Databases offline | 0 | ok | - |
| Virginia (DC‑2) | Postgres | Backups succeeded | 6 | ok | - |
| Virginia (DC‑2) | Postgres | Backups failed | 0 | ok | - |
| Virginia (DC‑2) | Postgres | SLA breach count | 0 | ok | - |
| Virginia (DC‑2) | Postgres | Open transactions > 5m | 5 | warn | - |
| Virginia (DC‑2) | Postgres | Slow queries (p95 > 1s) | 6 | warn | - |
| Virginia (DC‑2) | Postgres | Replication lag (s) | 40 | critical | - |
| Virginia (DC‑2) | Postgres | Avg query latency ms (p50) | 50 | ok | - |
| Virginia (DC‑2) | Postgres | Active connections | 180 | ok | - |
| Virginia (DC‑2) | Postgres | Buffer/Cache hit ratio % | 84 | ok | - |
| Virginia (DC‑2) | Postgres | Temp space used % | 40 | warn | - |
| Virginia (DC‑2) | Postgres | Failed auth attempts (24h) | 1 | ok | - |
| Virginia (DC‑2) | Postgres | Disk used % | 77 | ok | - |
| Ireland (DC‑3) | MSSQL | Total servers | 14 | ok | physical & virtual |
| Ireland (DC‑3) | MSSQL | Databases online | 21 | ok | - |
| Ireland (DC‑3) | MSSQL | Databases offline | 1 | ok | - |
| Ireland (DC‑3) | MSSQL | Backups succeeded | 3 | warn | - |
| Ireland (DC‑3) | MSSQL | Backups failed | 3 | warn | - |
| Ireland (DC‑3) | MSSQL | SLA breach count | 0 | ok | - |
| Ireland (DC‑3) | MSSQL | Open transactions > 5m | 4 | warn | - |
| Ireland (DC‑3) | MSSQL | Slow queries (p95 > 1s) | 6 | warn | - |
| Ireland (DC‑3) | MSSQL | Replication lag (s) | 11 | ok | - |
| Ireland (DC‑3) | MSSQL | Avg query latency ms (p50) | 50 | ok | - |
| Ireland (DC‑3) | MSSQL | Active connections | 200 | ok | - |
| Ireland (DC‑3) | MSSQL | Buffer/Cache hit ratio % | 81 | ok | - |
| Ireland (DC‑3) | MSSQL | Temp space used % | 55 | warn | - |
| Ireland (DC‑3) | MSSQL | Failed auth attempts (24h) | 2 | ok | - |
| Ireland (DC‑3) | MSSQL | Disk used % | 79 | ok | - |
| Ireland (DC‑3) | Oracle | Total servers | 15 | ok | physical & virtual |
| Ireland (DC‑3) | Oracle | Databases online | 23 | ok | - |
| Ireland (DC‑3) | Oracle | Databases offline | 0 | ok | - |
| Ireland (DC‑3) | Oracle | Backups succeeded | 4 | warn | - |
| Ireland (DC‑3) | Oracle | Backups failed | 2 | warn | - |
| Ireland (DC‑3) | Oracle | SLA breach count | 0 | ok | - |
| Ireland (DC‑3) | Oracle | Open transactions > 5m | 3 | warn | - |
| Ireland (DC‑3) | Oracle | Slow queries (p95 > 1s) | 2 | warn | - |
| Ireland (DC‑3) | Oracle | Replication lag (s) | 18 | ok | - |
| Ireland (DC‑3) | Oracle | Avg query latency ms (p50) | 55 | ok | - |
| Ireland (DC‑3) | Oracle | Active connections | 210 | ok | - |
| Ireland (DC‑3) | Oracle | Buffer/Cache hit ratio % | 81 | ok | - |
| Ireland (DC‑3) | Oracle | Temp space used % | 55 | warn | - |
| Ireland (DC‑3) | Oracle | Failed auth attempts (24h) | 0 | ok | - |
| Ireland (DC‑3) | Oracle | Disk used % | 82 | ok | - |
| Ireland (DC‑3) | Postgres | Total servers | 16 | ok | physical & virtual |
| Ireland (DC‑3) | Postgres | Databases online | 25 | ok | - |
| Ireland (DC‑3) | Postgres | Databases offline | 1 | ok | - |
| Ireland (DC‑3) | Postgres | Backups succeeded | 5 | warn | - |
| Ireland (DC‑3) | Postgres | Backups failed | 1 | warn | - |
| Ireland (DC‑3) | Postgres | SLA breach count | 0 | ok | - |
| Ireland (DC‑3) | Postgres | Open transactions > 5m | 5 | warn | - |
| Ireland (DC‑3) | Postgres | Slow queries (p95 > 1s) | 4 | warn | - |
| Ireland (DC‑3) | Postgres | Replication lag (s) | 12 | ok | - |
| Ireland (DC‑3) | Postgres | Avg query latency ms (p50) | 60 | ok | - |
| Ireland (DC‑3) | Postgres | Active connections | 220 | ok | - |
| Ireland (DC‑3) | Postgres | Buffer/Cache hit ratio % | 81 | ok | - |
| Ireland (DC‑3) | Postgres | Temp space used % | 55 | warn | - |
| Ireland (DC‑3) | Postgres | Failed auth attempts (24h) | 0 | ok | - |
| Ireland (DC‑3) | Postgres | Disk used % | 85 | ok | - |