Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


Server Space Interval (PI_SI)

Organization of this page

Function

The Server Space Interval (PI_SI) record indicates interval 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

Over 10 Sec Collection Time

No

N

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

Microsoft SQL Server version 2014 or earlier

Microsoft SQL Server version 2016 or later

DB Size

(SIZE)

Size of the entire database (in megabytes)

COPY

double

No

dbo.sysfiles

sys.database_files

Data Mbytes

(DATA)

Size of database being used (in megabytes)

COPY

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

AVG

double

No

dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables

sys.database_files, 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)

LO

double

No

dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables

sys.database_files, sys.partitions, sys.allocation_units, sys.internal_tables

Index Mbytes

(IDX)

Size of index space being used (in megabytes)

COPY

double

No

sys.partitions, sys.allocation_units, sys.internal_tables

Log Mbytes

(LOG)

Size of log space being used that shows the user area. (in megabytes)

COPY

double

No

DBCC SQLPERF(LOGSPACE)

Record Time

(RECORD_TIME)

Interval end time (GMT format)

COPY

time_t

No

Remote Monitor Collector

Record Type

(INPUT_RECORD_TYPE)

Record type (always SI)

COPY

char(8)

No

Remote Monitor Collector

Rsvd Mbytes

(RESERVED)

Size of space already allocated (in megabytes)

COPY

double

No

sys.partitions, sys.allocation_units, sys.internal_tables

Start Time

(START_TIME)

Interval start time (GMT format)

COPY

time_t

No

Remote Monitor Collector

Unused %

(PERC_USED)

Unused space as a percentage of total allocated space

AVG

double

No

sys.partitions, sys.allocation_units, sys.internal_tables

Unused Mbytes

(UNUSED)

Size of allocated but unused space (in megabytes)

COPY

double

No

sys.partitions, sys.allocation_units, sys.internal_tables

VA DeviceID(VADEVICEID)

Device ID of virtual agent.

--

string(256)

No

Remote Monitor Collector