Tables – Overview
The Tables Overview screen displays aggregate storage metrics, access tier breakdowns, and growth projections across all SQL Server tables in scope, based on the filters applied. The bottom section lists every table in a sortable grid with cost, usage, and growth data.
Navigate to Infrastructure › Tables to open the Overview.
Filter Controls
Use the toolbar at the top of the page to refine what is displayed:
- Views — Apply a saved view configuration
- Tag — Filter by tags assigned to instances and/or databases. Tags are user-defined groupings commonly used to identify business units, applications, environments, or dashboards. Filtering by tag targets all assets that share that tag. Tags are created and managed in the Tags section.
- Filters — Filter by Instance, Database, and/or Last Access tier (Active, Aging, Cold, Frozen, Stale)
- Reset — Clear all active filters and return to the default view
Filters applied on the Overview persist when navigating to the Details screen, but the Details screen requires the selection of a table on the Overview page.
Summary Cards
Five cards at the top of the page display aggregate metrics for all tables currently in scope.
| Card | Description |
|---|---|
| Annual Spend | Estimated annual storage cost across all tables in scope |
| Savings Opportunity | Potential savings identified based on cold and stale data |
| Cold Data Size | Total size of data not accessed in the past 180 days |
| Cold Data Copies | Number of individual table copies classified as cold |
| Annual Growth % | Average annual growth rate across all tables in scope |
What It Tells You:
Savings Opportunity and Cold Data Size together indicate how much of your current storage footprint is occupied by data that is no longer being actively used. A large gap between Annual Spend and Savings Opportunity suggests the majority of data is active; a small gap warrants a closer look at archival and cleanup priorities.
Last Accessed
The Last Accessed card breaks down tables by how recently their data was accessed. Use the toggle buttons at the top right of the card to switch between Size, Count, and Spend views.
Tables are classified into five access tiers:
| Tier | Last Accessed |
|---|---|
| Active | 0–30 days |
| Aging | 30–90 days |
| Stale | 90–180 days |
| Cold | 180–365 days |
| Frozen | 365+ days |
Each tier shows a progress bar sized proportionally to the selected metric, along with the absolute value.
How to Use:
Switch to the Spend view to understand the cost of data in each tier; this is often more actionable than size alone. Toggle to Count to see how many individual tables fall into each tier, which can help prioritize bulk archival efforts.
What It Tells You:
A large proportion of data in the Cold and Frozen tiers indicates significant dormant storage that may be a candidate for archival, compression, or removal. Aging and Stale tiers are worth monitoring. Data that is no longer accessed frequently but has not yet crossed into Cold may be approaching a natural archival threshold.
5-Year Growth Projections
The 5-Year Growth Projections chart forecasts storage size and spend based on observed historical growth rates across all tables in scope. Use the toggle buttons at the top right of the card to switch between Size and Spend projections.
The chart displays:
- Current Growth — the trailing annual growth rate across all tables in scope
- Projection — the estimated size or spend at the 5-year mark based on the current rate
Hover over the chart to see projected values at specific points in time.
What It Tells You:
The projection assumes growth continues at the current rate. Use the Spend projection to build infrastructure and storage budget forecasts. A steep growth curve warrants earlier capacity planning; a flat or declining curve may indicate that archival or cleanup processes are keeping pace with new data.
Tables Grid
The tables grid lists every table in scope. Columns are sortable by clicking the column header. Use the column selector to show or hide columns.
Columns
| Column | Description |
|---|---|
| Table | Table name |
| Platforms | Platform badge(s) indicating which monitored platform(s) the table exists on |
| Count | Number of copies of this table across all monitored instances |
| Row Count | Total row count across all copies |
| Size | Total storage size across all copies |
| Read % | Percentage of I/O operations that are reads |
| Write % | Percentage of I/O operations that are writes |
| Annual Size Growth | Year-over-year storage growth rate |
| Annual Spend | Estimated annual storage cost across all copies |
| Last Accessed | How recently data in the table was last accessed |
Viewing Table Details
To open the Details screen for a specific table, do one of the following:
- Click anywhere on the table's row
- Click the action icon (3 vertical dots at the right end of the row) and select View Details
Both actions navigate to the Details screen scoped to the selected table.
What It Tells You:
Sort by Annual Spend to find the highest-cost tables and cross-reference with Last Accessed to determine whether the spend is justified by active use. Sort by Annual Size Growth to identify tables expanding rapidly that may require capacity planning attention. The Count column surfaces tables with many copies across instances. A high copy count combined with cold Last Accessed data is a strong signal for archival review.