The Tables page in the Infrastructure module provides a cross-environment inventory of every SQL Server table WISdom monitors. Use it to assess data access patterns, identify cold or stale data, quantify storage costs, and project future growth across your entire monitored estate.
What You'll Find Here
The Tables page gives you two complementary views of your SQL Server tables:
Overview — A full-environment view that displays aggregate storage metrics, access tier breakdowns, and a 5-year growth projection across all tables in scope. The bottom section lists every table in a sortable, filterable grid. Use this view to find high-cost tables, identify data that has gone cold or stale, and understand growth trends across your environment.
Details — A single-table deep dive that displays every monitored copy of a selected table, broken down by instance and database, with the same access tier and growth projection analysis scoped to that table. Use this view when assessing the spread of a specific table across your environment, comparing copy sizes and costs, or identifying which instances hold cold or stale copies.
Key Capabilities
Quantify Storage Costs
Annual Spend and Savings Opportunity metrics give every table a dollar value. Use these figures to prioritize cleanup, archival, and optimization work based on financial impact rather than size alone.
Identify Cold and Stale Data
The Last Accessed breakdown classifies every table into five access tiers: Active (accessed within 30 days) through Frozen (not accessed in over a year). Use this to find data that is consuming storage and cost without delivering value.
Project Future Growth
The 5-Year Growth Projections chart forecasts storage size and spend based on observed historical growth rates. Use it to anticipate capacity needs and budget for future infrastructure costs before they become urgent.
Analyze Table Copies
The Details screen shows every copy of a specific table across all monitored instances and databases. Use it to identify redundant copies, compare access patterns across environments, and find cold copies that are candidates for archival or removal.
Navigating the Page
Filter Controls
Both screens share a common toolbar for refining 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
- 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.
Choosing Your View
Start with Overview when you want to:
- See aggregate storage costs and savings opportunities across your environment
- Find tables that have gone cold, stale, or frozen
- Identify the highest-cost or fastest-growing tables in your estate
- Understand the overall data access distribution across access tiers
- Project future storage growth or spend at the environment level
Switch to Details when you want to: - See every copy of a specific table by instance and database
- Compare storage size, access patterns, and cost across copies
- Identify which specific instances hold cold or stale copies of a table
- Project growth for a single table rather than the full estate
What's Next?
- Tables – Overview — Complete guide to the Overview screen
- Tables – Details — Complete guide to the Details screen