Database and schema size

I have multiple databases and I want to know the size of each database and monitor the growth at regular intervals. How can we check the database / schema and table sizes using TQL or any other method. Thanks.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Udaya, Admins will have access to a View called - "TS: Table Info". In that you will be able to see all the tables and the number of rows and the average size of a row. It has this data for each and every day. So make sure you filter down to just "Yesterday".

    This view can be accessed only through the front end and not through TQL. The table names are fully qualified, meaning they will show the database name and the schema name in it. You can use string functions to parse out the database name and the schema names and aggregate at those levels.

  • you can also see some of this information in the Admin --> System Health --> Data tab 

  • Hi

    Is it possible to see size for each column? We need to know impact for whole size specific column. For optimization reason.

Like Follow
  • Status Answered
  • 7 mths agoLast active
  • 3Replies
  • 95Views
  • 4 Following