I have mostly used:

1. DBU per Pipeline / Job Run – Identifies the most expensive processes.
2. Cluster Utilization (CPU / Memory) – Helps detect over-sized or underutilized clusters.

Additionally, for SQL workloads, you can monitor Data Scanned and apply Z-Ordering or OPTIMIZE to reduce scan volume and address small-file issues.