Space Usage

Form ID: (SM203525)

You can use this form to view statistics on the use of database space by your Acumatica ERP instance. You may need to view these statistics because your license for Acumatica ERP includes a limit on the database space that your instance can use.

The statistics of using database space, which is displayed on this form, does not include data related to the System tenant.

Initially, the form displays the statistics calculated most recently and the date and time when they were calculated. To view the current statistics, you click Calculate Used Space on the form toolbar.

In This Topic [Hide/Show]

Form Toolbar
Summary Area
Tenants Tab
   Table Toolbar
   Table Columns
   Table Sizes by Tenant Dialog Box
Snapshots Tab
   Table Toolbar
   Table Columns
   Table Sizes by Snapshot Dialog Box
Tables Tab
   Table Toolbar
   Table Columns
   Used Space by Tenants and Snapshots Dialog Box

Back to TopForm Toolbar

The form toolbar includes the buttons described below.

Button	Description
Calculate Used Space	Calculates the space used by the data of your instance in the Acumatica ERP database. The newly calculated data is displayed on the form.

Back to TopSummary Area

In this area, you can view general information about the database space usage of the current instance.

Element	Description
Last Calculated	The date and time when the database space used by the data of your instance was last calculated. If the box is empty, the space has never been calculated.
Used Database Space: Total	The space in the Acumatica ERP database used by all tenants and all snapshots in your Acumatica ERP instance.
Used Database Space: By Tenants	The space in the Acumatica ERP database used by all tenants that have been created in your instance.
Used Database Space: By Snapshots	The space in the Acumatica ERP database used by all snapshots stored in the system.
Free Space	The space in the Acumatica ERP database available for your instance for data storage.
Database Space Limit	The limit for the database space that can be used by your instance to store data for companies and snapshots. The limit is specified either in your Acumatica ERP license or in the `web.config` file.
Current Status	The status of the database space usage with regard to the limit. The system sets the status of the database space usage to one of the following: Database space limit is not set: The limit for the database space has not been set in your license or in the `web.config` file. OK: The limit has been set, and the used space does not exceed the limit Database space limit is exceeded: The limit has been set, and the used space exceeds the limit

Back to TopTenants Tab

On this tab, you can view the space used in the Acumatica ERP database by each tenant that has been created in your instance.

Table Toolbar

The table toolbar includes the buttons described below.

Button	Description
View Tables	Opens the Table Sizes by Tenant dialog box.

Table Columns

Column	Description
Current	A check box that indicates (if selected) that you are signed in to the tenant.
Tenant ID	The tenant identifier, which was generated automatically by the system when the tenant was created.
Tenant Name	The tenant name that is used on the site map.
Login Name	The name of the tenant that is displayed in the info area (in a multitenant system) and on the Sign-In page.
Status	The status of the tenant. The system sets the tenant status to one of the following: Active: A live tenant that has been used in production Test Tenant: A test tenant that has been used for testing application features and for training purposes. The system applies this status to a tenant automatically when it is used in the trial version of Acumatica ERP. Unlicensed: A tenant that was created after the license limit for tenants was reached. You cannot work with this tenant in the system.
Size in DB (MB)	The size of the data, in megabytes, used by the tenant in the Acumatica ERP database.

Table Sizes by Tenant Dialog Box

In this dialog box, which you open by clicking the View Tables button on the Tenants tab, you can view the list of tables that contain data for the selected tenant and the space that this data takes in the database.

The table toolbar has only standard buttons.

Element

Description

Summary Area

Tenant Name

The name of the tenant selected in the Tenants table.

Size in DB (MB)

The size of the data, in megabytes, used by the tenant in the Acumatica ERP database.

Table Columns

Table Name

The name of the table in the Acumatica ERP database.

Record Quantity

The quantity of records related to the selected tenant that are included in the table.

Size in DB (MB)

The size of the table in the Acumatica ERP database.

The size is calculated for only data related to the selected tenant.

Back to TopSnapshots Tab

On this tab, you can view the list of snapshots created in the system and the space each snapshot takes in the Acumatica ERP database.

Table Toolbar

The table toolbar includes the buttons described below.

Button	Description
View Tables	Opens the Table Sizes by Snapshot dialog box.

Table Columns

Column	Description
Name	The name of the snapshot.
Description	The description of the snapshot, which was specified during the creation of the snapshot.
Created	The date and time when the snapshot was created.
Export Mode	The export mode that was selected when the snapshot was created.
Size in DB (MB)	The size of the data, in megabytes, used by the snapshot in the Acumatica ERP database.

Table Sizes by Snapshot Dialog Box

In this dialog box, which you open by clicking the View Tables button on the Snapshots tab, you can view the list of tables that contain data for the selected snapshot and the space that this data takes in the database.

The table toolbar has only standard buttons.

Element

Description

Summary Area

Snapshot Name

The name of the snapshot selected in the Snapshots table.

Size in DB (MB)

The size of the data, in megabytes, used by the snapshot in the Acumatica ERP database.

Table Columns

Table Name

The name of the table in the Acumatica ERP database.

Record Quantity

The quantity of records related to the selected snapshot that are included in the table.

Size in DB (MB)

The size of the table in the Acumatica ERP database.

The size is calculated for only data related to the selected snapshot and the size of indexes.

Back to TopTables Tab

On this tab, you can view the list of tables with data related to all tenants and snapshots in your instance and the size of each table in the Acumatica ERP database.

Table Toolbar

The table toolbar includes the buttons described below.

Button	Description
View Used Space by Tenants and Snapshots	Opens the Used Space by Tenants and Snapshots dialog box.

Table Columns

Column	Description
Table Name	The name of the table in the Acumatica ERP database.
Record Quantity	The quantity of records in the table calculated for all tenants and snapshots that include this table.
Size in DB (MB)	The size of the table in the Acumatica ERP database calculated for all snapshots and tenants that include this table.

Used Space by Tenants and Snapshots Dialog Box

In this dialog box, which you open by clicking the View Used Space by Tenants and Snapshots button on the Tables tab, you can view the list of snapshots and tenants in which the selected table is included and the size of this table in the Acumatica ERP database.

The table toolbar has only standard buttons.

Element	Description
Summary Area
Table Name	The name of the table in the Acumatica ERP database.
Size in DB (MB)	The size of the table in the Acumatica ERP database calculated for all snapshots and tenants that include this table.
Table Columns
Type	The type of object that includes the table. The value can be one of the following: Snapshot Tenant
Name	The name of the snapshot or tenant.
Record Quantity	The quantity of records in the selected table, which the tenant or snapshot contains.
Size in DB (MB)	The size of the table in the Acumatica ERP database for the tenant or snapshot.

Space Usage

Form ID:  ([~/?ScreenId=SM203525|SM203525]){br}

You can use this form to view statistics on the use of database space by your Acumatica ERP instance. You may need to view these statistics because your license for Acumatica ERP includes a limit on the database space that your instance can use.((({S:Warn}The statistics of using database space, which is displayed on this form, does not include data related to the System tenant.
)))
Initially, the form displays the statistics calculated most recently and the date and time when they were calculated. To view the current statistics, you click '''Calculate Used Space''' on the form toolbar.{br}{TOC}
==Form Toolbar==[anchor|#_2d8e426a-bb0e-4a4a-b6d3-563f74b65c2e]
The form toolbar includes the buttons described below.[anchor|#_74e2f5de-59d3-4be3-bfc9-d40b4c03cd05]
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Button
!width="80%" ! Description
|- 
| '''Calculate Used Space'''
| Calculates the space used by the data of your instance in the Acumatica ERP database. The newly calculated data is displayed on the form.
|}
==Summary Area==
In this area, you can view general information about the database space usage of the current instance.[anchor|#_f12462b0-be31-4fcf-a3d9-78922335d766]
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Element
!width="80%" ! Description
|- 
| '''Last Calculated'''
| The date and time when the database space used by the data of your instance was last calculated. If the box is empty, the space has never been calculated.
|- 
| '''Used Database Space: Total'''
| The space in the Acumatica ERP database used by all tenants and all snapshots in your Acumatica ERP instance.
|- 
| '''Used Database Space: By Tenants'''
| The space in the Acumatica ERP database used by all tenants that have been created in your instance.
|- 
| '''Used Database Space: By Snapshots'''
| The space in the Acumatica ERP database used by all snapshots stored in the system.
|- 
| '''Free Space'''
| The space in the Acumatica ERP database available for your instance for data storage.
|- 
| '''Database Space Limit'''
| The limit for the database space that can be used by your instance to store data for companies and snapshots. The limit is specified either in your Acumatica ERP license or in the <tt>web.config</tt> file.
|- 
| '''Current Status'''
| The status of the database space usage with regard to the limit. The system sets the status of the database space usage to one of the following: [anchor|#_88eab384-211c-4371-aa2a-3c836dae8b60]
*''Database space limit is not set'': The limit for the database space has not been set in your license or in the <tt>web.config</tt> file.
*''OK'': The limit has been set, and the used space does not exceed the limit
*''Database space limit is exceeded'': The limit has been set, and the used space exceeds the limit

|}
==Tenants Tab==
On this tab, you can view the space used in the Acumatica ERP database by each tenant that has been created in your instance.[anchor|#_8d8e6ab3-f4ba-4b72-bd76-007362e7450d]
===Table Toolbar===[anchor|#_65269710-84a8-4584-b9d9-78b91ce5a8d1]
The table toolbar includes the buttons described below.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Button
!width="80%" ! Description
|- 
| '''View Tables'''
| Opens the [[#_490e1e49-633d-4ab2-8f9b-35dc7aa74f42|Table Sizes by Tenant] dialog box.
|}[anchor|#_8c0841bf-a7a8-40bf-b30b-f64bf4dd8045]
===Table Columns===
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Column
!width="80%" ! Description
|- 
| '''Current'''
| [anchor|#_c20ddb29-23ce-472a-a564-0335e136099a]
A check box that indicates (if selected) that you are signed in to the tenant.
|- 
| '''Tenant ID'''
| [anchor|#_4462022f-723f-434b-8ffc-74785c302e4e]
The tenant identifier, which was generated automatically by the system when the tenant was created.
|- 
| '''Tenant Name'''
| [anchor|#_4b8fd568-28fc-4a6f-9e78-6711bf795db4]
The tenant name that is used on the site map.
|- 
| '''Login Name'''
| [anchor|#_5d6d8a2c-4242-452a-8d44-3c734daae75a]
The name of the tenant that is displayed in the info area (in a multitenant system) and on the Sign-In page.
|- 
| '''Status'''
| The status of the tenant. The system sets the tenant status to one of the following:[anchor|#_53d8d3cb-6f3c-45a6-91a3-535bcd0ee08b]
*''Active'': A live tenant that has been used in production
*''Test Tenant'': A test tenant that has been used for testing application features and for training purposes. The system applies this status to a tenant automatically when it is used in the trial version of Acumatica ERP.
*''Unlicensed'': A tenant that was created after the license limit for tenants was reached. You cannot work with this tenant in the system.

|- 
| '''Size in DB (MB)'''
| [anchor|#_4d937f92-0f76-4c1b-8d71-45522294ffa9]
The size of the data, in megabytes, used by the tenant in the Acumatica ERP database.
|}[anchor|#_490e1e49-633d-4ab2-8f9b-35dc7aa74f42]
===Table Sizes by Tenant Dialog Box===
In this dialog box, which you open by clicking the '''View Tables''' button on the '''Tenants''' tab, you can view the list of tables that contain data for the selected tenant and the space that this data takes in the database.[anchor|#_088519af-53e5-4c17-ae7b-de688dbb7793]{br}

The table toolbar has only standard buttons.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Element
!width="80%" ! Description
|- 
| colspan="2" | Summary Area
|- 
| '''Tenant Name'''
| The name of the tenant selected in the Tenants table.
|- 
| '''Size in DB (MB)'''
| [anchor|#_4d937f92-0f76-4c1b-8d71-45522294ffa9]
The size of the data, in megabytes, used by the tenant in the Acumatica ERP database.
|- 
| colspan="2" | Table Columns
|- 
| '''Table Name'''
| [anchor|#_fd2b0c4e-0782-40cc-95bb-2fd848b389af]
The name of the table in the Acumatica ERP database.
|- 
| '''Record Quantity'''
| The quantity of records related to the selected tenant that are included in the table.
|- 
| '''Size in DB (MB)'''
| [anchor|#_ab61b2cf-4238-46d7-ad59-8b07b3c3aeb1]
The size of the table in the Acumatica ERP database.((({S:Warn}The size is calculated for only data related to the selected tenant.
)))
|}
==Snapshots Tab==
On this tab, you can view the list of snapshots created in the system and the space each snapshot takes in the Acumatica ERP database.[anchor|#_183ff9dc-94a4-4d86-a3b8-1553c3ed3f66]
===Table Toolbar===[anchor|#_65269710-84a8-4584-b9d9-78b91ce5a8d1]
The table toolbar includes the buttons described below.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Button
!width="80%" ! Description
|- 
| '''View Tables'''
| Opens the [[#_e7751b00-1490-48cf-aa6d-b6ca0ab1dc7e|Table Sizes by Snapshot] dialog box.
|}[anchor|#_b073e361-da9b-4e27-a8e4-251d6421c202]
===Table Columns===
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Column
!width="80%" ! Description
|- 
| '''Name'''
| The name of the snapshot.
|- 
| '''Description'''
| The description of the snapshot, which was specified during the creation of the snapshot.
|- 
| '''Created'''
| The date and time when the snapshot was created.
|- 
| '''Export Mode'''
| The export mode that was selected when the snapshot was created.
|- 
| '''Size in DB (MB)'''
| [anchor|#_4216eecb-a23b-46f3-8f03-53a83cce3ec7]
The size of the data, in megabytes, used by the snapshot in the Acumatica ERP database.
|}[anchor|#_e7751b00-1490-48cf-aa6d-b6ca0ab1dc7e]
===Table Sizes by Snapshot Dialog Box===
In this dialog box, which you open by clicking the '''View Tables''' button on the '''Snapshots''' tab, you can view the list of tables that contain data for the selected snapshot and the space that this data takes in the database.[anchor|#_088519af-53e5-4c17-ae7b-de688dbb7793]{br}

The table toolbar has only standard buttons.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Element
!width="80%" ! Description
|- 
| colspan="2" | Summary Area
|- 
| '''Snapshot Name'''
| The name of the snapshot selected in the Snapshots table.
|- 
| '''Size in DB (MB)'''
| [anchor|#_4216eecb-a23b-46f3-8f03-53a83cce3ec7]
The size of the data, in megabytes, used by the snapshot in the Acumatica ERP database.
|- 
| colspan="2" | Table Columns
|- 
| '''Table Name'''
| [anchor|#_fd2b0c4e-0782-40cc-95bb-2fd848b389af]
The name of the table in the Acumatica ERP database.
|- 
| '''Record Quantity'''
| The quantity of records related to the selected snapshot that are included in the table.
|- 
| '''Size in DB (MB)'''
| [anchor|#_ab61b2cf-4238-46d7-ad59-8b07b3c3aeb1]
The size of the table in the Acumatica ERP database.((({S:Warn}The size is calculated for only data related to the selected snapshot and the size of indexes.
)))
|}
==Tables Tab==
On this tab, you can view the list of tables with data related to all tenants and snapshots in your instance and the size of each table in the Acumatica ERP database.[anchor|#_1236345c-fd0b-4d68-a4ff-a59defd9c606]
===Table Toolbar===[anchor|#_65269710-84a8-4584-b9d9-78b91ce5a8d1]
The table toolbar includes the buttons described below.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Button
!width="80%" ! Description
|- 
| '''View Used Space by Tenants and Snapshots'''
| Opens the [[#_d41bdf29-a5e6-4bcf-b0ca-909e22fd736e|Used Space by Tenants and Snapshots] dialog box.
|}[anchor|#_1490bfc0-6625-4bf1-a9c0-401cff012005]
===Table Columns===
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Column
!width="80%" ! Description
|- 
| '''Table Name'''
| [anchor|#_fd2b0c4e-0782-40cc-95bb-2fd848b389af]
The name of the table in the Acumatica ERP database.
|- 
| '''Record Quantity'''
| The quantity of records in the table calculated for all tenants and snapshots that include this table.
|- 
| '''Size in DB (MB)'''
| [anchor|#_a2df7da2-99d8-4b3f-8b8e-86abb501ad7d]
The size of the table in the Acumatica ERP database calculated for all snapshots and tenants that include this table.
|}[anchor|#_d41bdf29-a5e6-4bcf-b0ca-909e22fd736e]
===Used Space by Tenants and Snapshots Dialog Box===
In this dialog box, which you open by clicking the '''View Used Space by Tenants and Snapshots''' button on the '''Tables''' tab, you can view the list of snapshots and tenants in which the selected table is included and the size of this table in the Acumatica ERP database.[anchor|#_088519af-53e5-4c17-ae7b-de688dbb7793]{br}

The table toolbar has only standard buttons.
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Element
!width="80%" ! Description
|- 
| colspan="2" | Summary Area
|- 
| '''Table Name'''
| [anchor|#_fd2b0c4e-0782-40cc-95bb-2fd848b389af]
The name of the table in the Acumatica ERP database.
|- 
| '''Size in DB (MB)'''
| [anchor|#_a2df7da2-99d8-4b3f-8b8e-86abb501ad7d]
The size of the table in the Acumatica ERP database calculated for all snapshots and tenants that include this table.
|- 
| colspan="2" | Table Columns
|- 
| '''Type'''
| The type of object that includes the table. The value can be one of the following:[anchor|#_17e680b6-8af9-4027-80b6-9ee04ab3a5bf]
*''Snapshot''
* ''Tenant''

|- 
|  '''Name'''
| The name of the snapshot or tenant.
|- 
| '''Record Quantity'''
| The quantity of records in the selected table, which the tenant or snapshot contains.
|- 
| '''Size in DB (MB)'''
| The size of the table in the Acumatica ERP database for the tenant or snapshot.
|}