1.2. Database related features
Feature | Db2 | PostgreSQL | SQL Server | Azure SQL Database | Oracle |
---|---|---|---|---|---|
Database core metrics |
y |
y |
y |
y |
y |
Machine CPU, Load, Memory Consumption |
y |
n |
y |
y |
y |
Lock / Lockwait |
y |
y |
y |
y |
y |
Connections / Applications |
y |
y |
y |
y |
y |
TRx and SQL per sec |
y |
y |
y |
y |
y |
SQL Statement Detail |
y |
y |
y |
y |
y |
Tablespace / Bufferpool / File Groups |
y |
y |
y |
basic |
y |
Table and Index Details |
y |
not yet |
index only |
index only |
not yet |
Routine Details |
y |
not yet |
not yet |
not yet |
not yet |
Memory Details |
y |
not yet |
y |
y |
not yet |
HA and DR |
y |
not yet |
not yet |
no |
not yet |
Internal Locking / Latches |
y |
not yet |
basic |
basic |
not yet |
SQL Workload Analysis |
y |
y |
y |
y |
y |
Explain / Analyze |
y |
not yet |
basic |
basic |
not yet |
Index Tuning |
y |
not yet |
y |
y |
not yet |
Comparisons of Workloads |
y |
y |
y |
y |
y |