Tables Details
Tables – Details
Section titled “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. See at a glance where every copy of a table lives and which copies cost you the most.
To open the Details screen, select a table from the Overview by selecting 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 selecting Overview in the tab navigation.
Summary cards
Section titled “Summary cards”The same five summary cards from the Overview appear here, scoped to the selected table.
| Card | Description |
|---|---|
| Annual Spend | Estimated annual storage cost across all copies of this table |
| Savings Opportunity | Potential storage savings from compressing indexes, scoped to this table |
| Cold Data Size | Total size of copies in the Cold tier (last accessed over 180 up to 365 days ago) |
| Cold Data Copies | Number of copies of this table in the Cold tier |
| Annual Growth % | Average annual growth rate across all copies of this table |
Spend depends on host information. WISdom applies cost to a resource using the host it runs on, so a cost can only be calculated when host information has been collected. Without host information, or without cloud cost information where it applies, spend may not display. You may see $0 amounts or charts with no data. See Cost Management for how costs are defined.
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
Section titled “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.
| Tier | Last Accessed |
|---|---|
| Active | 0 to 30 days |
| Aging | Over 30 up to 90 days |
| Stale | Over 90 up to 180 days |
| Cold | Over 180 up to 365 days |
| Frozen | Over 365 days |
Each range includes its upper value and excludes its lower value, so a table last accessed exactly 30 days ago is Active, and one accessed 30.001 days ago is Aging. Only tiers that contain tables are shown.
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
Section titled “5-Year growth projections”The 5-Year Growth Projections chart forecasts storage size and spend over five years for the selected table, based on its annual 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 annual size growth rate for this table across all copies, shown as a percentage change from last year
- 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
Section titled “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 selecting the column header. All columns are displayed by default. To choose which columns are displayed, select the column chooser icon in the upper-right corner of the grid and toggle columns on or off. Your selections are kept in your browser cache and persist until the cache is flushed. To export the grid, use Export from the action icon (three vertical dots) in the table’s header row. Export creates an Excel file with all available columns, regardless of which columns are displayed. It does not ignore filters: only the data that matches the filters currently applied is exported.
Columns
Section titled “Columns”| Column | Default | Description |
|---|---|---|
| Instance | Yes | The SQL Server instance hosting this copy |
| Database | Yes | The database containing this copy |
| Table | Yes | Table name |
| Platform | Yes | Platform badge indicating the monitored platform |
| Row Count | Yes | Number of rows in this copy |
| Size | Yes | Storage size of this copy |
| Read % | Yes | Percentage of I/O operations that are reads |
| Write % | Yes | Percentage of I/O operations that are writes |
| Annual Size Growth | Yes | Annual growth in size of this copy, as a percentage of the size one year ago |
| Annual Spend | Yes | Estimated annual storage cost for this copy |
| Last Accessed | Yes | How recently data in this copy was last accessed |
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
Section titled “Table flyout”To open the flyout panel for a specific copy, do one of the following:
- Select anywhere on the row
- Select 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. The flyout covers the copy of the table in the database you selected. Three tabs provide additional detail for that copy: Properties, FinOps, and Indexes.
Properties
Section titled “Properties”The Properties tab displays physical and access metadata for the selected table copy.
| Field | Description |
|---|---|
| Schema | The schema the table belongs to |
| First Seen | The date WISdom first observed this table copy |
| Last Evaluated | The date WISdom last collected data for this table copy |
| Row Count | Current number of rows in this copy |
| Indexes | Number of indexes defined on this table copy |
| Read % | Percentage of I/O operations that are reads |
| Write % | Percentage of I/O operations that are writes |
| Last Read | Date this copy was last read |
| Last Write | Date this copy was last written to |
| Last Accessed | Access tier classification (Active, Aging, Stale, Cold, or Frozen) based on the most recent read or write |
| 30-Day Growth | Storage growth rate over the past 30 days |
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
Section titled “FinOps”The FinOps tab trends the annual storage spend of the selected table copy. It does not chart size or any other cost.
| Field | Description |
|---|---|
| Annual Storage Spend | Estimated annual storage cost for this copy |
The 5-Year Growth Projections chart plots annual storage spend for this specific copy from Now through Y5, based on its annual growth rate. Below the chart, Current Growth shows the current annual storage spend and 5Y projection shows the projected annual storage spend in five years. 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
Section titled “Indexes”The Indexes tab lists all indexes on the selected table in the selected database. A table with one index shows one row, and a table with several indexes shows all of them.
| Column | Description |
|---|---|
| Name | Index name |
| Type | Index type: Clustered or Nonclustered |
| Columns | Number of columns included in the index. Click the count to expand and view the individual column names. |
| Status | The access tier of the index, shown as a badge: Active, Aging, Stale, Cold, or Frozen |
Use the search icon above the list to find an index. Rows per page is set to 15 by default, and Total rows shows the number of indexes.
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.