SYS.History.PerfData
persistent class SYS.History.PerfData extends %Library.Persistent, %XML.Adaptor
SQL Table Name: SYS_History.PerfData
Basic detail collection class of Performance metrics for the Monitor History database. Properties represent metrics which get collected every few seconds by the %MONAPP Application Monitor process when the %Monitor.System.HistoryPerf class is "active". The values stored for most properties are deltas calculated from the last interval.For details, see History Monitor.
Property Inventory
Method Inventory
Properties
property DateTime as %TimeStamp;
Time of sample
Property methods: DateTimeDisplayToLogical(), DateTimeGet(), DateTimeGetStored(), DateTimeIsValid(), DateTimeLogicalToDisplay(), DateTimeLogicalToXSD(), DateTimeNormalize(), DateTimeOdbcToLogical(), DateTimeSet(), DateTimeXSDToLogical()
property Length as %Integer;
Length of sample in seconds
Property methods: LengthDisplayToLogical(), LengthGet(), LengthGetStored(), LengthIsValid(), LengthLogicalToDisplay(), LengthNormalize(), LengthSet(), LengthXSDToLogical()
property Perf as SYS.History.Performance;
Performance metrics
Property methods: PerfGet(), PerfGetObject(), PerfGetObjectId(), PerfGetStored(), PerfGetSwizzled(), PerfIsEmpty(), PerfIsValid(), PerfNewObject(), PerfSet(), PerfSetObject(), PerfSetObjectId(), PerfUnSwizzle()
property WD as array of SYS.History.WriteDaemon;
WriteDaemon metrics
Property methods: WDBuildValueArray(), WDCollectionToDisplay(), WDCollectionToOdbc(), WDDisplayToCollection(), WDGet(), WDGetObject(), WDGetObjectId(), WDGetStored(), WDGetSwizzled(), WDIsValid(), WDOdbcToCollection(), WDSet(), WDSetObject(), WDSetObjectId()
property ZDATE as %Integer [ Required ];
UTC date key
Property methods: ZDATEDisplayToLogical(), ZDATEGet(), ZDATEGetStored(), ZDATEIsValid(), ZDATELogicalToDisplay(), ZDATENormalize(), ZDATESet(), ZDATEXSDToLogical()
property ZTIME as %Integer [ Required ];
UTC time key
Property methods: ZTIMEDisplayToLogical(), ZTIMEGet(), ZTIMEGetStored(), ZTIMEIsValid(), ZTIMELogicalToDisplay(), ZTIMENormalize(), ZTIMESet(), ZTIMEXSDToLogical()
Methods
classmethod Export(FileName As %String, Start As %TimeStamp, End As %TimeStamp) as %Status
Export PerfData data for time range in CSV format. The default is all of the data
currently in the PerfData class. Note that Write Daemon cycle properties are exported
as the high-water mark for the cycles during an interval.
The default FileName is HistoryPerf_config_date_time.csv in the MGR directory.
'Start' and 'End' times (if necessary) are in YYYY-MM-DD HH:MM:SS format.
The default FileName is HistoryPerf_config_date_time.csv in the MGR directory.
'Start' and 'End' times (if necessary) are in YYYY-MM-DD HH:MM:SS format.
Purge PerfData interval data, keeping the last 'Keep' days. This is typically called at
the start of each day from the %Monitor.System.HistoryPerf class, using the current
system default for 'Keep' (see the SetPurge() method). The 'Keep' argument allows
you to over ride the system default (a value of "0" or "" uses the system default)
Returns the number of entries purged.
Returns the number of entries purged.
classmethod Sample() as SYS.History.PerfData
Instantiate the class and fetch current values for all metric properties.
Set the system parameter for the number of days of detail data to keep.
Initial system default is 7 days. Return value is the previous setting, and executing
this method with a "" argument will return the current setting without modifying it.
Collect summaries of the PerfData metrics for a day into the Hourly/Daily database.
This is typically done automatically by %Monitor.System.HistoryPerf at the
beginning of each day (for the previous day), but could be called manually
if there's a problem.
The 'Day' argument sets the end date of the collection, with the default of "0" being the start of today (i.e. $H+Day), which would collect everything for yesterday. A "-1" would collect the day before yesterday; a "1" would collect today (as much as there is).
The 'Day' argument sets the end date of the collection, with the default of "0" being the start of today (i.e. $H+Day), which would collect everything for yesterday. A "-1" would collect the day before yesterday; a "1" would collect today (as much as there is).
Queries
query DateList(Start As %TimeStamp = {$zdt(+$h, 3)}, End As %TimeStamp = {$zdt($h+1, 3)})
SQL Query:
SELECT * FROM PerfData WHERE (DateTime >= :Start AND DateTime <= :End)
SELECT * FROM PerfData WHERE (DateTime >= :Start AND DateTime <= :End)
Full listing of PerfData metrics for a day or range of date/times. Default is today.
query WDDateList(Start As %TimeStamp = {$zdt(+$h, 3)}, End As %TimeStamp = {$zdt($h+1, 3)})
SQL Query:
SELECT DateTime,PerfData_WD.* FROM PerfData,PerfData_WD WHERE ((PerfData_WD.PerfData = PerfData.ID) AND (DateTime >= :Start) AND (DateTime <= :End))
SELECT DateTime,PerfData_WD.* FROM PerfData,PerfData_WD WHERE ((PerfData_WD.PerfData = PerfData.ID) AND (DateTime >= :Start) AND (DateTime <= :End))
Full listing of WriteDaemon PerfData metrics for a day or range of date/times. Default is today.
Indexes
index (ZDTindex on ZDATE,ZTIME) [IdKey, Type = key];
Index methods: ZDTindexCheck(), ZDTindexDelete(), ZDTindexExists(), ZDTindexOpen(), ZDTindexSQLCheckUnique(), ZDTindexSQLExists(), ZDTindexSQLFindPKeyByConstraint(), ZDTindexSQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %%CLASSNAMELogicalToStorage()
- %%CLASSNAMEStorageToLogical()
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
Storage
Storage Model: Storage (SYS.History.PerfData)
^SYS.History("Detail")(ID) |
= | %%CLASSNAME
DateTime
Length
Perf
|
Storage Model: Storage (SYS.History.PerfData)
^SYS.History("Detail")(ID,"WD",n) |
= | WD(n) |