Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%CSP] >  [Util] >  [Performance]
Private  Storage   

persistent class %CSP.Util.Performance extends %Persistent

This class is designed to map an existing global named ^["%SYS"]ISCcspPerformance which contains data about the CSP/ZEN Performance as long as the PAGETIMING parameter is set to 1 in the page. It contais data about each time a CSP/ZEN page is executed: Day, Time Slot, Hits, Global References, Lines Executed, and Maximum, Minimum and Total Execution Time. This class will allow SQL access to the data. Some sample queries are provided. One step further will be DeepSee enable it, to be able to use DeepSee against this data.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
12 2 1


Summary

Properties
Day Event Globals GlobalsPerHit Hits
Lines LinesPerHit MaxTime MinTime Page
Slot TotalTime

Methods
%AddToSaveSet %AddToSyncSet %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 %IsA
%IsModified %IsNull %KillExtent %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject


Properties

• property Day as %String(TRUNCATE=1);
Date in YYYY-MM-DD format
• property Event as %String(TRUNCATE=1);
Indicates the type of the event (currently there is only one event named 'Page')
• property Globals as %Numeric(SCALE=0);
Number of global references (read/write)
• property GlobalsPerHit as %Integer [ Calculated ];
• property Hits as %Numeric(SCALE=0);
Number of times the page was executed
• property Lines as %Numeric(SCALE=0);
Number of lines of COS code executed
• property LinesPerHit as %Integer [ Calculated ];
• property MaxTime as %Numeric(SCALE=6);
Maximum Page execution time
• property MinTime as %Numeric(SCALE=6);
Minimum Page execution time
• property Page as %String(MAXLEN=256,TRUNCATE=1);
The full CSP page name, includes the application name
• property Slot as %Integer;
The particular Slot within the Day the hit occured The total number of Time Slots in a day is defined in the page with the TIMINGSLOTS parameter
• property TotalTime as %Numeric(SCALE=6);
Total acumulated Page execution time

Queries

• query PageAndDay(Page As %String, Day As %String = ""_$zdate($h, 3))
SQL Query :
SELECT Hits,Globals,GlobalsPerHit,Lines,LinesPerHit,MaxTime,MinTime,TotalTime,Page,Day,Slot

FROM %CSP_Util.Performance

WHERE (Page = :Page AND Day = :Day)

ORDER BY Slot
• query Top10Pages(from As %String, until As %String)
SQL Query :
SELECT TOP 10 Page, Hits

FROM %CSP_Util.Performance

WHERE Day BETWEEN :from AND :until

GROUP BY Page

ORDER BY Hits DESC
top pages in number of Hits in a period of time

Indices

•index (IdKeyIdx on Event,Page,Day,Slot) [IdKey,Unique];


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.