Enable a seamless correlation experience between SQL activity and jobs

It's difficult to correlate between metrics, SQL activity, and jobs which is critical for several troubleshooting user flows where a cluster could be overloaded or jobs and SQL activity could impact one another. For instance, we ran into an issue where a long running transaction cause an abnormal intent buildup failing a backup.

This issue tracks enabling users to easily correlate metrics (e.g., intent buildup) with SQL activity (e.g., problematic transactions), and jobs (e.g., failed or long-running).

Related issue: https://github.com/cockroachdb/cockroach/issues/82372

Jira issue: CRDB-30724