Space usage (SM203525)

Den här artikeln ger dig information om elementen du ser i det här fönstret i Visma.net ERP, till exempel fält, fältvärden, knappar och kryssrutor.

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

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

Initially, the window 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 window toolbar.

Button Description
Calculate used space Calculates the space used by the data of your instance in the Visma.net ERP database.
The newly calculated data is displayed in the window.

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 field is empty, the space has never been calculated.
Used database space: Total The space in the Visma.net ERP database used by all companies and all snapshots in your Visma.net ERP instance.
Used database space: by tenants The space in the Visma.net ERP database used by all companies that have been created in your instance.
Used database space: by snapshots The space in the Visma.net ERP database used by all snapshots stored in the system.
Free space The space in the Visma.net 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 Visma.net 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

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

 
Button Description
View tables Opens the Table sizes by tenant dialog box.
 
Column Description
Current

A check box that indicates (if selected) that you are signed in to the company.
Tenant ID

The company identifier, which was generated automatically by the system when the company was created.
Tenant name

The company name that is used on the site map.
Login name

The name of the company that is displayed in the info area (in a multi-company system) and on the Welcome page.
Status The status of the company. The system sets the company status to one of the following:
  • Active:
    A live company that has been used in production
  • Test tenant:
    A test company that has been used for testing application functionalities and for training purposes.
    The system applies this status to a company automatically when it is used in the trial version of Visma.net ERP.
  • Unlicensed:
    A company that was created after the license limit for companies was reached. You cannot work with this company in the system.
Size in DB (MB)

The size of the data, in megabytes, used by the company in the Visma.net ERP database.

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 company and the space that this data takes in the database.

 
Element Description
Tenant Name The name of the company selected in the Tenants table.
Size in DB (MB)

The size of the data, in megabytes, used by the company in the Visma.net ERP database.
Table Columns
Table Name

The name of the table in the Visma.net ERP database.
Record Quantity The quantity of records related to the selected company that are included in the table.
Size in DB (MB)

The size of the table in the Visma.net ERP database.

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

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

 
Button Description
View Tables Opens the Table sizes by snapshot dialog box.
 
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 Visma.net ERP database.

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.

 
Element Description
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 Visma.net ERP database.
Table name

The name of the table in the Visma.net 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 Visma.net ERP database.

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

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

 
Button Description
View used space by tenants and snapshots Opens the Used space by tenants and snapshots dialog box.
 
Column Description
Table name

The name of the table in the Visma.net ERP database.
Record quantity The quantity of records in the table calculated for all companies and snapshots that include this table.
Size in DB (MB)

The size of the table in the Visma.net ERP database calculated for all snapshots and companies that include this table.

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 companies in which the selected table is included and the size of this table in the Visma.net ERP database.

 
Element Description
Table name

The name of the table in the Visma.net ERP database.
Size in DB (MB)

The size of the table in the Visma.net ERP database calculated for all snapshots and companies that include this table.
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 company.
Record quantity The quantity of records in the selected table, which the company or snapshot contains.
Size in DB (MB) The size of the table in the Visma.net ERP database for the company or snapshot.