-
Article
-
- 2 minutes to read
-
Data Performance Dashboard.
Messages
Properties
| Property |
Value |
| CollectionSchemaName |
DataPerformances |
| DisplayCollectionName |
Data Performance Collection |
| DisplayName |
Data Performance Dashboard |
| EntitySetName |
dataperformances |
| IsBPFEntity |
False |
| LogicalCollectionName |
dataperformances |
| LogicalName |
dataperformance |
| OwnershipType |
OrganizationOwned |
| PrimaryIdAttribute |
dataperformanceid |
| PrimaryNameAttribute |
|
| SchemaName |
DataPerformance |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
| Property |
Value |
| Description |
Unique identifier of the performance suggestion. |
| DisplayName |
Id |
| IsValidForForm |
False |
| IsValidForRead |
True |
| IsValidForUpdate |
False |
| LogicalName |
dataperformanceid |
| RequiredLevel |
SystemRequired |
| Type |
Uniqueidentifier |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
AnyOptimizationApplied
| Property |
Value |
| Description |
An internal state which indicates whether at least one optimization is applied. |
| DisplayName |
Any Optimization Applied |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
anyoptimizationapplied |
| RequiredLevel |
None |
| Type |
Boolean |
AnyOptimizationApplied Choices/Options
| Value |
Label |
Description |
| 1 |
Yes |
|
| 0 |
No |
|
DefaultValue: False
AnyOptimizationAvailable
| Property |
Value |
| Description |
An internal state which indicates whether at least one optimization is available for this record. |
| DisplayName |
Any Optimization Available |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
anyoptimizationavailable |
| RequiredLevel |
None |
| Type |
Boolean |
AnyOptimizationAvailable Choices/Options
| Value |
Label |
Description |
| 1 |
Yes |
|
| 0 |
No |
|
DefaultValue: False
Component
| Property |
Value |
| Description |
Name of the component |
| DisplayName |
Component |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
component |
| MaxLength |
100000 |
| RequiredLevel |
None |
| Type |
String |
Count
| Property |
Value |
| Description |
Number of times a queries were executed (Aggregated) |
| DisplayName |
Count |
| Format |
None |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
count |
| MaxValue |
2147483647 |
| MinValue |
-2147483648 |
| RequiredLevel |
None |
| Type |
Integer |
Entity
| Property |
Value |
| Description |
Primary entity |
| DisplayName |
Entity |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
entity |
| MaxLength |
100000 |
| RequiredLevel |
None |
| Type |
String |
EstimatedOptimizationImpact
| Property |
Value |
| Description |
The expected average cost benefit of an optimization. |
| DisplayName |
Estimated Optimization Impact |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
estimatedoptimizationimpact |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
ExecutionPeriod
| Property |
Value |
| Description |
The execution period for which the performance metrics are calculated. |
| DisplayName |
Execution Period |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
executionperiod |
| MaxLength |
50 |
| RequiredLevel |
None |
| Type |
String |
LastActionResult
| Property |
Value |
| Description |
An internal state which shows the result of the last action that was taken on this record. |
| DisplayName |
Last Action Result |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
lastactionresult |
| MaxLength |
50 |
| RequiredLevel |
None |
| Type |
String |
LastOptimizationDate
| Property |
Value |
| DateTimeBehavior |
UserLocal |
| Description |
Last time an optimization was applied. |
| DisplayName |
Last Optimization Date |
| Format |
DateAndTime |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
lastoptimizationdate |
| RequiredLevel |
None |
| Type |
DateTime |
MaxTime
| Property |
Value |
| Description |
Maximum execution time in seconds. (Aggregated) |
| DisplayName |
Max Time |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
maxtime |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
| Property |
Value |
| Description |
Average execution time in seconds. (Aggregated) |
| DisplayName |
Median Time |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
mediantime |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
MinTime
| Property |
Value |
| Description |
Minimum execution time in seconds. (Aggregated) |
| DisplayName |
Min Time |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
mintime |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
Operation
| Property |
Value |
| Description |
Data operation that triggered the query (Retrieve Multiple, etc.) |
| DisplayName |
Operation |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
operation |
| MaxLength |
100000 |
| RequiredLevel |
None |
| Type |
String |
OptimizationStatus
| Property |
Value |
| Description |
Current optimization status of the record, showed to the customer. |
| DisplayName |
Optimization Status |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
optimizationstatus |
| MaxLength |
50 |
| RequiredLevel |
None |
| Type |
String |
OptimizationStorage
| Property |
Value |
| Description |
Storage consumed by the optimization. (MB) |
| DisplayName |
Optimization Storage |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
optimizationstorage |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
OrganizationId
| Property |
Value |
| Description |
Unique identifier of the organization associated. |
| DisplayName |
|
| IsValidForForm |
False |
| IsValidForRead |
True |
| LogicalName |
organizationid |
| RequiredLevel |
SystemRequired |
| Targets |
organization |
| Type |
Lookup |
RealizedOptimizationImpact
| Property |
Value |
| Description |
Actual performance change after taking an optimization action on the record. |
| DisplayName |
Optimization Impact (%) |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
realizedoptimizationimpact |
| MaxLength |
50 |
| RequiredLevel |
None |
| Type |
String |
Solution
| Property |
Value |
| Description |
Name of the solution that owns the component |
| DisplayName |
Solution |
| FormatName |
Text |
| IsLocalizable |
False |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
solution |
| MaxLength |
100000 |
| RequiredLevel |
None |
| Type |
String |
Weight
| Property |
Value |
| Description |
Query Weight of the component. Factored with the Optimization Impact to determine the overall importance of applying an optimization. (P2) |
| DisplayName |
Weight |
| IsValidForForm |
True |
| IsValidForRead |
True |
| LogicalName |
weight |
| MaxValue |
1000000000 |
| MinValue |
0 |
| Precision |
2 |
| RequiredLevel |
None |
| Type |
Decimal |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
See organization Table lk_dataperformance_organizationid One-To-Many relationship.
See also
About the table reference
Web API Reference
dataperformance EntityType