Analyze data usage on your instance

Monitor data usage over time and determine which tables are consuming the most amount of storage on your instance.

Before you begin

Role required: admin

Procedure

1. Navigate to All > System Data Management > Data Management Console.
2. Determine which tables are consuming the most storage in your instance by checking the Primary storage used (GB) chart.

   Figure 1. Primary storage used

   

   • View a summary of the total amount of primary storage used on your instance.
   • Compare usage between the top three tables and all other tables on your instance.
   • Access details in the Physical Table Stats [sys_physical_table_stats] table by selecting a portion of the chart.
3. Monitor the top three tables consuming the most amount of storage over time by checking the Primary storage trend (for last month) chart.

   Figure 2. Primary storage trend

   

   • Determine if usage has increased or decreased over time.
   • Compare usage between the top three tables and all other tables on your instance over time.
   • Access details in the Physical Table Stats [sys_physical_table_stats] table by selecting a line on the trend chart.
4. View the top 10 tables that are consuming the most storage on your instance.
   • Sort the top 10 tables by their size in GB.
   • Access details in the Physical Table Stats [sys_physical_table_stats] table for all tables in your instance by selecting View all.
5. Review your data management policies to determine if table data can be archived or cleaned after a point in time.
   • Determine if table data should be archived using an archive rule or deleted using a table cleaner rule.
   • If a table doesn't have a data management policy, create a data management policy by selecting Create Policy.
   • View a list of current data management policies on your instance by selecting View All Policies.
   • View a list of current archive rules on your instance by selecting View Archive Rules.