Space usage (SM203525)
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.
The window toolbar
- 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.
- 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.
- View tables
- Opens the Table sizes by tenant dialog box.
- 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.
- 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.
- View Tables
- Opens the Table sizes by snapshot dialog box.
- 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.
- 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.
- View used space by tenants and snapshots
- Opens the Used space by tenants and snapshots dialog box.
- 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.
- 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.