is there a way to check table data MB/GB SIZE?

reyservicenow
Tera Expert

‎06-20-2017 01:21 PM

is there a way to check table data MB/GB SIZE?

thanks

0 Helpfuls
  • 6,549 Views
6 REPLIES 6

reyservicenow
Tera Expert
In response to Shishir Srivast

‎06-20-2017 02:47 PM

well this might work but i am not able to run this.. let me see if someone can help goranlundqvist   hey Doc can you take a peek at this when you have time?




Thanks


0 Helpfuls

Community Alums
Not applicable

‎09-25-2024 01:05 AM - edited ‎09-25-2024 02:24 AM

Hi @reyservicenow 

Not sure if your query is addressed or you find the solution. Since this thread is open, please review below response that might help and address your query.

 

You can check the table by size (GB) using catalog on Now Support by generating an instance Database Footprint Report.Only users with the customer_admin or partner_admin roles on Now Support can utilize these catalogs on Now Support.

 

The following options are both automated workflows to request the database footprint of one or more instances via Service Catalogs and are completed using end-to-end automation:

  1. Instance Database Footprint
    Customers can view the total space occupied by one instance along with up to the top 100 tables that contribute to the occupied space.
  2. Cloud Usage Request
    Customers can view the total space occupied by all instances on account level, presented as a list.
  3.  

Though, for your use case this option will be relevant and provide accurate information. You can view Instance

 

Database Footprint by following these steps:

  1. Navigate to the Now Support
  2. Browse the Automation Store
  3. Under Instance Management, select Database Footprint

References:

Note:

  • Permissible Database size is 4TB as contractual limit, not a physical/Technical limit. The current servers are having capacity ranging from 12 TB -21 TB.


If this helps and address your query, please close this thread by marking the response as correct or helpful.