Tables Details

Tables – Details

The Tables Details screen displays every monitored copy of a selected table, broken down by instance and database. Use this screen to compare storage size, access patterns, growth rates, and costs across all copies of the same table in your environment and to identify which specific instances hold cold, stale, or high-cost copies.

To open the Details screen, select a table from the Overview by clicking its row or using the action icon (3 vertical dots at the right end of the row) and selecting View Details. The selected table name is displayed at the top of the page. Navigate back to the full table inventory at any time by clicking Overview in the tab navigation.

Summary Cards

The same five summary cards from the Overview appear here, scoped to the selected table.

What It Tells You:

When Cold Data Copies is high relative to the total copy count visible in the grid, the majority of this table's instances hold data that is no longer being accessed. That pattern often indicates the table exists across environments; production copies may be active while development, QA, or DR copies have gone cold.

Last Accessed

The Last Accessed card shows the access tier breakdown scoped to the selected table. Use the toggle buttons at the top right of the card to switch between Size, Count, and Spend views.

How to Use:

Switch to Count to see how many copies of this table fall into each tier. Switch to Spend to understand which tiers are carrying the most cost. Combined with the grid below, this helps you quickly identify which specific instances hold the cold or frozen copies.

5-Year Growth Projections

The 5-Year Growth Projections chart forecasts storage size and spend for the selected table based on its observed historical growth rate. 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 for this table across all copies
• Projection — the estimated size or spend at the 5-year mark

Hover over the chart to see projected values at specific points in time.

What It Tells You:

The projection reflects the aggregate growth rate across all copies of this table. If growth appears unexpectedly high, use the grid below to identify which specific instance or database is driving it. A single rapidly expanding copy can skew the overall projection significantly.

Tables Grid

The tables grid lists each individual copy of the selected table. Each row represents one copy as it exists on a specific instance and database. Columns are sortable by clicking the column header. Use the column selector to show or hide columns.

Columns

What It Tells You:

Sort by Annual Spend to identify the most expensive copies and compare against Last Accessed to determine whether the cost is backed by active use. Sort by Annual Size Growth to find copies that are expanding faster than others; unexpected growth on a non-production instance is worth investigating. Read % and Write % help distinguish read-heavy copies (typically reporting or DR) from write-heavy copies (typically production or ETL targets).

Table Flyout

To open the flyout panel for a specific copy, do one of the following:

• Click anywhere on the row
• Click the action icon (3 vertical dots at the right end of the row) and select View Details

The flyout header displays the instance name, with the database and table name shown as a breadcrumb path below it. Three tabs provide additional detail for that specific copy.

Properties

The Properties tab displays physical and access metadata for the selected table copy.

What It Tells You:

First Seen and Last Evaluated together indicate how long WISdom has been monitoring this copy and how current the data is. Last Read and Last Write provide more precise access detail than the Last Accessed tier alone. A table classified as Active may still have a Last Read date significantly older than its Last Write, which can indicate a write-only workload. A high 30-Day Growth rate relative to the annual growth rate shown in the grid may signal a recent workload change worth investigating.

FinOps

The FinOps tab displays storage cost and growth projections for the selected table copy.

The 5-Year Growth Projections chart forecasts spend for this specific copy based on its observed historical growth rate. The chart displays the current annual spend and a 5-year projected value. Hover over the chart to see projected spend at specific points in time.

What It Tells You:

Use the 5-year projection to understand the long-term cost trajectory of this copy in isolation. A copy with a low current Annual Storage Spend but a steep growth curve may become a significant cost driver within a few years. Compare this projection against the Properties tab's 30-Day Growth rate; a recent acceleration in growth will produce a steeper curve than the longer-term historical average.

Indexes

The Indexes tab lists all indexes defined on the selected table copy.

What It Tells You:

Use this tab to understand the indexing structure of a specific copy without leaving the Tables page. A high index count relative to the table's Write % may indicate over-indexing, where maintenance overhead on writes outweighs read performance gains. The column list for each index is useful for a quick view of whether an index covers expected access patterns. For a deeper analysis of index usage, efficiency, and recommendations, see Index Analysis in the Performance module. Copies with high Annual Spend and a Cold or Frozen Last Accessed classification are strong candidates for archival review. Sort by Annual Size Growth to find copies that are expanding faster than others; unexpected growth on a non-production instance is worth investigating. Read % and Write % help distinguish read-heavy copies (typically reporting or DR) from write-heavy copies (typically production or ETL targets).

Related Topics

• Tables
• Tables – Overview
• Performance - Index Analysis
• Infrastructure – Databases
• Infrastructure – Instances