Events: Infrastructure Performance and Repository Health
Performance and health tests are performed daily on all the repositories of all the environments.
Repository health events to be monitored:
|
Event
|
Type
(severity)
|
Context / JSON
|
Description / Content
|
|---|---|---|---|
|
RepositoryPerformanceROGraphCommentReadAlert
|
Alert
(+)
|
Reading of 1000 large existing text (BLOB)
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure
|
||
|
RepositoryPerformanceROGraphLoadAlert
|
Alert
(+)
|
Existing graph exploration (1000 objects and x MetaAssociations)
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryPerformanceROGraphQueryAlert
|
Alert
(+)
|
ERQL queries on existing graph (1000 objects and x MetaAssociations)
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryPerformanceRWGraphCommentWriteAlert
|
Alert
(+)
|
Writing of 1000 large texts (BLOB)
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryPerformanceRWGraphCreateAlert
|
Alert
(+)
|
Creation of a graph of 1000 objects and 500 MetaAssociations
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryPerformanceRWGraphDestroyAlert
|
Alert
(+)
|
Deletion of a graph of 1000 objects and 500 MetaAssociations
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryPerformanceRWGraphQueryAlert
|
Alert
(+)
|
ERQL queries on a recently created graph (1000 objects and 500 MetaAssociations)
|
This test execution time is higher/lower than the reference time calculated for the last 30 executions.
Event of this type may be due, for example, to:
- the CPU load and/or the server memory available at test execution time (4 pm GMT)
- an infrastructure change (e.g.: network, VM size, hardware)
- the SQL repository maintenance plan execution time, which is too old
- a cache configuration change (e.g.: redis, cache file)
- anti-virus policy
|
|
Performance
|
Test execution time (in ms)
|
||
|
Comparedtoaverage
|
Current measure characterization according to the standard measure (textual value)
|
||
|
RepositoryHealthSQLCompatibiltyLevelAlert
|
Alert
(++)
|
Compatibility check between your data SQL structure and your SQL server version
|
It is highly recommended not to work with a data structure version older than the SQL server one
|
|
Version
|
Version number of SQL server used (textual value)
|
||
|
Compatibility
|
API compatibility type (textual value)
|
||
|
RepositoryHealthWorkspaceAlert
|
Alert
(+)
|
A workspace is older than 7 days
|
Keeping older workspaces reduces HOPEX performances
|
|
IdAbs
|
Workspace absolute identifier
|
||
|
Type
|
Workspace type
|
||
|
Owner
|
Owner name
|
||
|
Device
|
Machine name
|
||
|
Duration
|
Activity duration
|
||
|
RepositoryHealthSQLTableAlert
|
Alert
(++)
|
The table execution plan has never been performed or has been performed more than a week ago
|
An SQL maintenance plan must be performed at least once a week
|
|
Table
|
Table name
|
||
|
LastExecution
|
Last execution time (or “never”)
|
||
|
RepositoryHealthSQLIndexAlert
|
Alert
(++)
|
An index fragmentation exceeds 50%
|
An SQL maintenance plan must be performed at least once a week
|
|
Table
|
Table name
|
||
|
Indexes
|
Index name
|
||
|
Ratio
|
Fragmentation percentage
|
||
|
RepositoryHealthSQLPrivateWorkspaceAlert
|
Alert
(+)
|
The RemovePrivateWorkspaceTempData stored procedure has never been performed or has been performed more than 7 days ago
|
The RemovePrivateWorkspaceTempData stored procedure must be performed at least once a week
|
|
LastExecution
|
Last execution time (or “never”)
|
||
|
RepositoryHealthSQLHistoricalDataAlert
|
Alert
(+)
|
The ShrinkUnusedHistoricalData stored procedure has never been performed or has been performed more than 7 days ago
|
The ShrinkUnusedHistoricalData stored procedure must be performed at least once a week
|
|
LastExecution
|
Last execution time (or “never”)
|
||
|
RepositoryHealthCustomisationAlert
|
Alert
(-)
|
HOPEX MetaClass customization
|
It is forbidden to modify a HOPEX MetaClass, as it may generate regressions at updates/migrations.
|
|
Metaclass
|
Customized MetaClass name
|
||
|
RepositoryHealthMetaClassVolumeAlert
|
Alert
(-)
|
A MetaClass for which a maximum cardinality is defined and for which the current cardinality is higher than the maximum cardinality
|
Exceeding the maximum number of recommended objects may degrade HOPEX performances
|
|
Name
|
Customized MetaClass name
|
||
|
Volume
|
Current cardinality
|
||
|
Volumemax
|
Maximum cardinality
|
||
|
RepositoryHealthMetaAssociationVolumeAlert
|
Alert
(-)
|
A MetaAssociation for which a maximum cardinality is defined and for which the current cardinality is higher than the maximum cardinality
|
Exceeding the maximum number of recommended objects may degrade HOPEX performances
|
|
Name
|
MetaAssociation name
|
||
|
Volume
|
Current cardinality
|
||
|
Volumemax
|
Maximum cardinality
|
||
|
RepositoryHealthMetaAssociationChildrenVolumeAlert
|
Alert
(-)
|
A MetaAssociation for which a maximum cardinality is defined on the children number and for which the children current cardinality is higher than the maximum cardinality
|
Exceeding the maximum number of recommended objects may generate usability issues
|
|
Name
|
MetaAssociation name
|
||
|
VolumeChildren
|
Children current cardinality
|
||
|
Volumechildrenmax
|
Children maximum cardinality
|