Metasys databases - Metasys - LIT-12011202 - Software Application - Metasys Database Manager - 13.0

Metasys Database Manager Help

Brand
Metasys
Product name
Metasys Database Manager
Document type
User Guide
Document number
LIT-12011202
Version
13.0
Revision date
2023-08-14
Product status
Active
Language
English

The Metasys Databases section contains statistical information about the trend, alarm (event), audit, and annotation databases. The SQL Server software directly supplies all of the information on the tab. For more information on the fields in the tab, refer to your SQL Server software documentation. The following table outlines the Metasys Databases section fields.

Table 1. Metasys Databases Section Fields

Field

Description

Database Name

The SQL Server software database name.

Database Path

The system path where the database exists. When you place your cursor over the path, the entire path appears in a tooltip.

Backup Database Path

The current directory where database backups are created. When you place your cursor over the path, the entire path appears in a tooltip.

Database Size (actual data in files)

The physical size of the data (and only the data) inside the database. For the size of the file that contains the database, see Database Data File Size.

Database Index Size

The physical size of the index for the database.

Database Reserved Space

The physical size of space in the .mdf and .ldf file reserved for future use by objects within the database. This typically is space assigned to individual tables and indexes and log buffer space.

Database Unallocated Space

The physical size of space in the database .mdf and .ldf files that has not been reserved for use by objects within the database. The database can use this space to grow tables or logs without growing the physical file size on the hard disk.

Database Data File Size (.mdf)*

The size of the data file for the database (.mdf file) that takes up room on the computer. The Metasys Database Manager uses this value and the value in Database Log File Size to calculate the % Full for the database.

Database Log File Size (.ldf)*

The size of the log file for the database (.ldf file) that takes up room on the computer. The Metasys Database Manager uses this value and the value in Database Log File Size to calculate the % Full for the database.

Database File Size (.mdf and .ldf)*

The physical space taken up by the entire database. The entire database includes *.mdf and .ldf files. The size of the .mdf file is indicated in Database Data File Size. The size of the .ldf file is indicated in Database Log File Size.

Maximum Database File Size*

The size of the database, depending on the server type:

  • Express Edition: The maximum size is 10 GB (SQL Server® 2019 Express with CU18 (64-bit), SQL Server® 2017 Express with CU31 (64-bit), SQL Server® 2016 Express with SP3 CU9 (64-bit))
  • All others: The maximum size is half the physical size of the free disk space for the location of the database minus the size in the Database File Size field. Half the free space is required for a backup; therefore, the database can only take up half the free space.

% Full*

The percent of the maximum database file size that the database currently uses.

Note: An asterisk (*) in Table 1 indicates that the background of the database name changes color if this monitored attribute exceeds the warning or alarm limits defined in Choosing Monitoring Settings. The attributes in Figure 4 are within their limits. However, if you see a yellow background, the warning limit has been exceeded, and a red background, the alarm limit has been exceeded or the Database Manager cannot connect to the SQL Server database.