![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Function
The Database Space Detail (PD_DS) record indicates information related to the size of the disk space used by a particular database. One record is created for each database. This is a multi-instance record.
Default and changeable values
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 60 | Y |
| Collection Offset | 0 | Y |
| Log | No | Y |
| LOGIF | (Blank) | Y |
ODBC key fields
Lifetime
From the creation until deletion of a database
Record size
Fields
| View name (Manager name) |
Description | Summary | Format | Delta | Data source |
|---|---|---|---|---|---|
| DB Name (DB_NAME) |
Database name | -- | string(257) | No | master..sysdatabases.name |
| DB Size (SIZE) |
Database size (in megabytes) | -- | double | No | dbo.sysfiles |
| DBID (DBID) |
Database ID | -- | word | No | master..sysdatabases.dbid |
| Data Mbytes (DATA) |
Size of database being used (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
| Free % (PERC_FREE) |
Free space as a percentage of the size of the entire database, including data files and transaction log files | -- | double | No | dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables |
| Free Mbytes (FREE_SPACE) |
Size of the free space in the area allocated to the entire database, including data files and transaction log files (in megabytes) | -- | double | No | dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables |
| Index Mbytes (IDX) |
Size of index space being used (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
| Log Mbytes (LOG) |
Size of log space being used (in megabytes) | -- | double | No | DBCC SQLPERF(LOGSPACE) |
| Record Time (RECORD_TIME) |
Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record type (always DS) | -- | char(8) | No | Remote Monitor Collector |
| Rsvd Mbytes (RESERVED) |
Size of space already allocated (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
| Start Time (START_TIME) |
Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
| Unused % (PERC_USED) |
Unused space as a percentage of total allocated space | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
| Unused Mbytes (UNUSED) |
Size of allocated but unused space (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
| VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.