topic System tables performance optimization in Administration & Architecture

System tables performance optimization

antonionuzzo — Fri, 04 Jul 2025 12:58:46 GMT

Hi All

Are there any Databricks lab projects or GitHub repositories that leverage system tables to provide dashboards or code for monitoring, and more importantly, for optimizing workflows and clusters based on usage?

Re: System tables performance optimization

szymon_dybczak — Fri, 04 Jul 2025 13:06:06 GMT

Hi @antonionuzzo ,

Here's a list of cool examples of dashboards and queries that you can use:

- SQL Query Toolkit - Sync

- We built a free System Tables Queries and Dashboard to help users manage and optimize Databricks costs - feedback welcome! : r/databricks

- Analyzing Workflows in DBSQL with the Workflows Advisor Dashboard | by Databricks SQL SME | DBSQL SME Engineering | Medium

Re: System tables performance optimization

Sharanya13 — Sun, 06 Jul 2025 00:58:28 GMT

+1 to @szymon_dybczak. I would also add the dashboards for DB SQL Warehouse monitoring.