Data Performance Dashboard (DataPerformance) table/entity reference (Microsoft Dataverse)

Data Performance Dashboard.

Messages

The following table lists the messages for the Data Performance Dashboard (DataPerformance) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Associate Event: True	Associate records	Associate records
Disassociate Event: True	Disassociate records	Disassociate records
Retrieve Event: False	GET /dataperformances(dataperformanceid) See Retrieve	Retrieve records
RetrieveMultiple Event: False	GET /dataperformances See Query data	Query data

Properties

The following table lists selected properties for the Data Performance Dashboard (DataPerformance) table.

Property	Value
DisplayName	Data Performance Dashboard
DisplayCollectionName	Data Performance Collection
SchemaName	DataPerformance
CollectionSchemaName	DataPerformances
EntitySetName	dataperformances
LogicalName	dataperformance
LogicalCollectionName	dataperformances
PrimaryIdAttribute	dataperformanceid
TableType	Standard
OwnershipType	OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

DataPerformanceId

Property	Value
Description	Unique identifier of the performance suggestion.
DisplayName	Id
IsValidForForm	False
IsValidForRead	True
LogicalName	dataperformanceid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• AnyOptimizationApplied
• AnyOptimizationAvailable
• Component
• Count
• Entity
• EstimatedOptimizationImpact
• ExecutionPeriod
• LastActionResult
• LastOptimizationDate
• MaxTime
• MedianTime
• MinTime
• Operation
• OptimizationStatus
• OptimizationStorage
• OrganizationId
• RealizedOptimizationImpact
• Solution
• Weight

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
GlobalChoiceName	dataperformance_anyoptimizationapplied
DefaultValue	False
True Label	Yes
False Label	No

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
GlobalChoiceName	dataperformance_anyoptimizationavailable
DefaultValue	False
True Label	Yes
False Label	No

Component

Property	Value
Description	Name of the component
DisplayName	Component
IsValidForForm	True
IsValidForRead	True
LogicalName	component
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

Count

Property	Value
Description	Number of times a queries were executed (Aggregated)
DisplayName	Count
IsValidForForm	True
IsValidForRead	True
LogicalName	count
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

Entity

Property	Value
Description	Primary entity
DisplayName	Entity
IsValidForForm	True
IsValidForRead	True
LogicalName	entity
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

EstimatedOptimizationImpact

Property	Value
Description	The expected average cost benefit of an optimization.
DisplayName	Estimated Optimization Impact
IsValidForForm	True
IsValidForRead	True
LogicalName	estimatedoptimizationimpact
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

ExecutionPeriod

Property	Value
Description	The execution period for which the performance metrics are calculated.
DisplayName	Execution Period
IsValidForForm	True
IsValidForRead	True
LogicalName	executionperiod
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

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
IsValidForForm	True
IsValidForRead	True
LogicalName	lastactionresult
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

LastOptimizationDate

Property	Value
Description	Last time an optimization was applied.
DisplayName	Last Optimization Date
IsValidForForm	True
IsValidForRead	True
LogicalName	lastoptimizationdate
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Auto
SourceTypeMask	0

MaxTime

Property	Value
Description	Maximum execution time in seconds. (Aggregated)
DisplayName	Max Time
IsValidForForm	True
IsValidForRead	True
LogicalName	maxtime
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

MedianTime

Property	Value
Description	Average execution time in seconds. (Aggregated)
DisplayName	Median Time
IsValidForForm	True
IsValidForRead	True
LogicalName	mediantime
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

MinTime

Property	Value
Description	Minimum execution time in seconds. (Aggregated)
DisplayName	Min Time
IsValidForForm	True
IsValidForRead	True
LogicalName	mintime
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

Operation

Property	Value
Description	Data operation that triggered the query (Retrieve Multiple, etc.)
DisplayName	Operation
IsValidForForm	True
IsValidForRead	True
LogicalName	operation
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

OptimizationStatus

Property	Value
Description	Current optimization status of the record, showed to the customer.
DisplayName	Optimization Status
IsValidForForm	True
IsValidForRead	True
LogicalName	optimizationstatus
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

OptimizationStorage

Property	Value
Description	Storage consumed by the optimization. (MB)
DisplayName	Optimization Storage
IsValidForForm	True
IsValidForRead	True
LogicalName	optimizationstorage
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

OrganizationId

Property	Value
Description	Unique identifier of the organization associated.
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	SystemRequired
Type	Lookup
Targets	organization

RealizedOptimizationImpact

Property	Value
Description	Actual performance change after taking an optimization action on the record.
DisplayName	Optimization Impact (%)
IsValidForForm	True
IsValidForRead	True
LogicalName	realizedoptimizationimpact
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Solution

Property	Value
Description	Name of the solution that owns the component
DisplayName	Solution
IsValidForForm	True
IsValidForRead	True
LogicalName	solution
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

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
RequiredLevel	None
Type	Decimal
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2
SourceTypeMask	0

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_dataperformance_organizationid

One-To-Many Relationship: organization lk_dataperformance_organizationid

Property	Value
ReferencedEntity	organization
ReferencedAttribute	organizationid
ReferencingAttribute	organizationid
ReferencingEntityNavigationPropertyName	organizationid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
dataperformance