Space usage (SM203525)

This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

You can use this window to view statistics on the use of database space by your Visma Net instance. You may need to view these statistics because your license for Visma Net 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 database. The newly calculated data is displayed in the window.

The top part

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 database used by all companies and all snapshots in your Visma Net instance.
Used database space: by tenants	The space in the Visma Net database used by all companies that have been created in your instance.
Used database space: by snapshots	The space in the Visma Net database used by all snapshots stored in the system.
Free space	The space in the Visma Net 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 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

The Tenants tab

On this tab, you can view the space used in the Visma Net 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. 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 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 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 database.
Table Columns
Table Name	The name of the table in the Visma Net 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 database. The size is calculated for only data related to the selected company.

The Snapshots tab

On this tab, you can view the list of snapshots created in the system and the space each snapshot takes in the Visma Net 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 database.

The 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.

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 database.
Table name	The name of the table in the Visma Net 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 database. The size is calculated for only data related to the selected snapshot.

The Tables tab

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 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 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 database calculated for all snapshots and companies 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 companies in which the selected table is included and the size of this table in the Visma Net database.

Element	Description
Table name	The name of the table in the Visma Net database.
Size in DB (MB)	The size of the table in the Visma Net 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 database for the company or snapshot.