Use this report to view information about the databases within your environment. Some of the following fields are not available for all RDBMSs:
Field Name |
Description |
Name |
name of a database |
Owner |
owner of a database |
RDBMS Type |
RDBMS to which a database belongs (e.g., Sybase, Oracle, SQL Server, etc.) |
Status |
indicates whether a database is online or offline |
Total Size of All Storage |
total amount of storage space consumed by a database |
Free Space of Data Files |
amount of free space available in the data file(s) associated with a database |
Mirror Overhead |
amount of storage space allocated to the mirrored devices in an Instance |
Data Freespace |
amount of free space available in a database |
Total Size of Empty Used Space |
total size of storage allocated to a database but is not currently being used |
Total Log Size |
total size of a database log |
Log Freespace |
amount of freespace available in a database log |
Number of Devices |
number of devices on which a database resides |
Number of Data Files |
number of data files associated with a database |
Number of Fragments |
number of fragments associated with a database |
Number of Tables |
number of tables associated with a database |
Number of Indexes |
number of indexes associated with a database |
Number of Other Objects |
number of user-created objects that are not tables or indexes, such as rollback segments |
Page Size |
size of the pages associated with the database |
Discovered Time |
date/time when a database was discovered |
Scan Time |
date/time when a database was last scanned |
Dropped Time |
date/time when a database was dropped |
Use this tab to view information about the data files associated with a database.
Field Name |
Description |
Computer |
name of the computer on which the data file resides |
RDBMS Instance |
name of the Instance on which a data file resides |
Database |
name of the database with which a data file is associated |
Data File Path |
fully-qualified path to the physical data file |
Used Space |
amount of storage space consumed by a data file |
Percent Used |
percentage of allocated space that a data file is consuming |
Free Space |
amount of free space available in a data file |
Total Size |
total size of a data file (Used Space + Freespace) |
Auto Extend |
indicates whether SQL Server should automatically increase the size of data files when they fill up with data |
Growth |
percentage that a data file will grow if it becomes full |
Maximum Size |
maximum size to which SQL Server will auto extend a data file |
Create Time |
date/time when a data file was created |
Discovered Time |
date/time when a data file was discovered |
Use this tab to view information about the log files associated with a database.
Field Name |
Description |
Computer |
name of the computer on which a log file resides |
RDBMS Instance |
name of the Instance on which a log file resides |
Database |
name of the database to which a log file is associated |
Log File Path |
fully-qualified path to the physical log file |
Total Size |
total size of a log file (Used Space + Freespace) |
Auto Extend |
indicates whether SQL Server should automatically increase the size of log files when they fill up with data |
Growth |
percentage that a log file will grow if it becomes full |
Maximum Size |
maximum size to which SQL Server will auto extend a log file |
Create Time |
date/time when a log file was created |
Discovered Time |
date/time when a log file was discovered |
Use this tab to view information about the devices associated with a database.
Field Name |
Description |
Device Name |
name of the device(s) associated with a database |
Computer |
name of the computer on which a device resides |
RDBMS Instance |
name of the Instance on which a device resides |
Device Path |
fully-qualified path to the physical device file |
Free Space |
amount of free space available in the data file |
Percent Free |
percentage of allocated space for a device that is unused |
Used Space |
amount of storage consumed by a device |
Total Size |
total size of a device (Used Space + Freespace) |
Fragments |
number of fragments associated with the device |
Low |
low page number in a device. This number is derived from the Sybase system table sysdevices. |
High |
high page number in a device. This number is derived from the Sybase system table sysdevices. |
Mirror Path |
fully-qualified path to device mirror |
Discovered Time |
date/time when a device was discovered |
Dropped Time |
date/time when a device was dropped |
Use this tab to view information about the fragments associated with a database.
Field Name |
Description |
Computer |
name of the computer on which a fragment resides |
RDBMS Instance |
name of the Instance on which a fragment resides |
Fragment Path |
fully-qualified path to the physical fragment file |
Used Space |
amount of storage consumed by a device |
Percent Used |
percentage of allocated space that a fragment is consuming |
Free Space |
amount of free space available in the fragment |
Total Size |
total size of a fragment (Used Space + Freespace) |
Data Type |
indicates if a fragment is used to store Log Data, Object Data, or both |
Create Time |
date/time when a fragment was created |
Discovered Time |
date/time when a fragment was discovered |