![[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 Server Space Detail (PD_SS) record indicates information related to the size of the disk space used by Microsoft SQL Server. One record is created for each Microsoft SQL Server instance.
Default and changeable values
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 60 | Y |
| Collection Offset | 0 | Y |
| Log | No | Y |
| LOGIF | (Blank) | Y |
ODBC key field
None
Lifetime
From the creation until deletion of an instance
Record size
Fields
| View name (Manager name) |
Description | Summary | Format | Delta | Data source |
|---|---|---|---|---|---|
| DB Size (SIZE) |
Size of the entire database (in megabytes) | -- | double | No | sp_databases.db_size |
| Data Mbytes (DATA) |
Size of the 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 SS) | -- | 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.